Multiple External Id field for Salesforce Integration

[BlueOcean_ProvePharm]

We are using TOS for data Upsert from Excel file to Salesforce . We have a requirement to consider two fields as unique identifier to upsert the Account data. Is there a way we can achieve this?

[Anonymous]

Hello,

Could you please have a look at this related topic to see if it helps?

https://community.talend.com/s/question/0D53p00007vCnVACA0/upsert-into-salesforce-using-2-columns

Best regards

Sabrina

[BlueOcean_ProvePharm]

@Xiaodi Shi​ Thank you for the response. I actually tried it in a different way. In the excel file I added a new column with formula to consider one of the multiple fields as Unique Identifier and mapped that to External Id to Salesforce . Though the insert operation is working when I am trying to Upsert I am getting below error:

failed to release the resource in tSalesforceOutput_1 :External_Id__c not specified

Exception in component tSalesforceOutput_1 (AccountsIntegrationJob)

java.io.IOException: External_Id__c not specified

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

at org.talend.components.salesforce.runtime.SalesforceWriter.doUpsert(SalesforceWriter.java:454)

at org.talend.components.salesforce.runtime.SalesforceWriter.upsert(SalesforceWriter.java:418)

at org.talend.components.salesforce.runtime.SalesforceWriter.write(SalesforceWriter.java:191)

at salesforce_integration_project.accountsintegrationjob_0_1.AccountsIntegrationJob.tFileInputExcel_1Process(AccountsIntegrationJob.java:4140)

at salesforce_integration_project.accountsintegrationjob_0_1.AccountsIntegrationJob.runJobInTOS(AccountsIntegrationJob.java:4606)

at salesforce_integration_project.accountsintegrationjob_0_1.AccountsIntegrationJob.main(AccountsIntegrationJob.java:4444)

[statistics] disconnected