Salesforce upsert on child table

aba57870 — Sat, 16 Nov 2024 00:59:15 GMT

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)

Checkins Table:

Label , Name, Type

Check_ID Check_ID__c Auto Number

Checked_In Response Checked_In_Response__c Text(10)

Checkin_date Checkin_date__c Date

Contact Contact__c Master-Detail(Contact)

Created By CreatedById Lookup(User)

Ivy_Daily_Checkins Name Name Text(80)

Last Modified By LastModifiedById Lookup(User)

Signed_CS Signature__c Text(50)

Term Term__c Text(50)

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?

Re: Salesforce upsert on child table

manodwhb — Tue, 08 Dec 2020 05:38:03 GMT

@Alex Baker , as part of the input you need to change the column/filed name as you required.

Thanks,

Manohar

Re: Salesforce upsert on child table

aba57870 — Tue, 08 Dec 2020 17:26:20 GMT

Manohar, which input are you referring to?

Thanks,

Alex

topic Salesforce upsert on child table in Talend Studio

Salesforce upsert on child table

Re: Salesforce upsert on child table

Re: Salesforce upsert on child table