Error while importing related field to salesforce from csv

[minald2]

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]

[Anonymous]

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