Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!!
I'm trying to upsert data into 'Asset' object in Salesforce.
I want to upsert the field ExternalId, for that I'm using the AccountId (lookup) like key column.
The problem is the next one:
failed to release the resource in tSalesforceOutput_1 :[InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD'
exceptionMessage='Field name provided, Account does not match an External ID for Asset'
extendedErrorDetails='{[0]}'
]
row='-1'
column='-1'
]
]
Exception in component tSalesforceOutput_1 (Ucav_Sfdc_Ps_Id_Titulaciones_Prueba)
java.io.IOException: [InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD'
exceptionMessage='Field name provided, Account does not match an External ID for Asset'
extendedErrorDetails='{[0]}'
]
row='-1'
column='-1'
]
]
at org.talend.components.salesforce.runtime.SalesforceWriter.doUpsert(SalesforceWriter.java:458)
at org.talend.components.salesforce.runtime.SalesforceWriter.upsert(SalesforceWriter.java:415)
at org.talend.components.salesforce.runtime.SalesforceWriter.write(SalesforceWriter.java:192)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.tFileInputDelimited_1Process(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:2354)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.tWarn_7Process(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:4705)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.tFTPGet_1Process(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:4573)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.tSetGlobalVar_1Process(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:9331)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.runJobInTOS(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:9846)
at ucav_2.ucav_sfdc_ps_id_titulaciones_prueba_0_1.Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.main(Ucav_Sfdc_Ps_Id_Titulaciones_Prueba.java:9415)
Caused by: [InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD'
exceptionMessage='Field name provided, Account does not match an External ID for Asset'
extendedErrorDetails='{[0]}'
]
row='-1'
column='-1'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:673)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:556)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:236)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:210)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:156)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
at com.sforce.soap.partner.PartnerConnection.upsert(PartnerConnection.java:1151)
at org.talend.components.salesforce.runtime.SalesforceWriter.doUpsert(SalesforceWriter.java:438)
... 8 more
I've try to write the lookup component in the advances settings and I've try to change the name of the field as well ( trying with the api name, target name, child name....), but it doesn't work....
Anyone knows what I'm forgetting??
I attach screenshot.
Thank you in advance.
Kind regards,
Jorge
