I am attempting to upsert from Microsoft SQL Server to two different Salesforce tables via Talend. This is my first time using Talend and first time doing anything with Salesforce as this is a proof of concept sort of integration.
In Talend, I connect to the SQL Server, perform my queries, and save the outputs to 2 different csv files
My Salesforce field details are as follows, where contact__c in the Checkins (child) table is a reference to netID__c in the Contact (parent) table.
I am only listing one column for Contact because it is really the only field in question here.
Contact Table:
Label , Name, Type
netID, netID__c, Text(10), (External ID), (Unique Case Insensitive)
In Talend I can upsert to the Contact salesforce table just fine with the tSalesforceOutputBulkExec component, using netID__c for the upsert key column. But when I go on to the upsert for the Checkins object using
tSalesforceOutputBulkExec I am never successful. My relationship mapping for upsert is as follows:
column name of talend schema : Contact__c
lookup relationship field name: Contact__r
module name: Contact
external id name: netID__c
for my upsert key column, I currently have it set to Contact__c but in the salesforce bulk job monitor, my result file shows an error for each record:
"
MISSING_ARGUMENT:Contact__c not specified"
I realize in the salesforce schema, Contact__c is not set to an external ID.
What am I missing here? How do I get Contact__c from Checkins to map to netID__c in Contact so I can do a successful upsert on the child table?
