Error while importing related field to salesforce from csv

minald2 — Fri, 15 Nov 2024 21:34:32 GMT

Hi,

I'm trying to import invoice and invoice products from a csv file to Salesforce. I'm getting required field missing for Invoice__c relationship field on Invoice products. But I'm mapping the field with Invoice Id. Can someone help me resolve this issue. Thanks.

Below is the error log and the job ss

Starting job Invoice_Import at 11:19 17/07/2023.

[statistics] connecting to socket on port 3860

[statistics] connected

Exception in component tSalesforceOutput_1 (Invoice_Import)

java.io.IOException: Required fields are missing: [Invoice__c]

at org.talend.components.salesforce.runtime.SalesforceWriter.handleReject(SalesforceWriter.java:536)

at org.talend.components.salesforce.runtime.SalesforceWriter.doInsert(SalesforceWriter.java:357)

at org.talend.components.salesforce.runtime.SalesforceWriter.logout(SalesforceWriter.java:679)

at org.talend.components.salesforce.runtime.SalesforceWriter.close(SalesforceWriter.java:666)

at org.talend.components.salesforce.runtime.SalesforceWriter.close(SalesforceWriter.java:66)

at testpudumjee.invoice_import_0_1.Invoice_Import.tFileInputDelimited_2Process(Invoice_Import.java:7630)

at testpudumjee.invoice_import_0_1.Invoice_Import.tFileInputDelimited_1Process(Invoice_Import.java:3514)

at testpudumjee.invoice_import_0_1.Invoice_Import.runJobInTOS(Invoice_Import.java:10396)

at testpudumjee.invoice_import_0_1.Invoice_Import.main(Invoice_Import.java:10225)

[statistics] disconnected

Job Invoice_Import ended at 11:19 17/07/2023. [Exit code = 1]

Re: Error while importing related field to salesforce from csv

Anonymous — Mon, 17 Jul 2023 06:40:10 GMT

Hello,

Is there any type convert inside tMap_2 component? As we know that it required case sensitive currently. so you should type the field with case sensitive. else it maybe lost when send request to server side.

Please make sure that you write the field in studio as it is written in salesforce.

Feel free to post your issue here.

Best regards

Sabrina

topic Error while importing related field to salesforce from csv in Talend Studio

Error while importing related field to salesforce from csv

Re: Error while importing related field to salesforce from csv