tSalesforceOutput "Relationship mapping for upsert" parameters

One Star

tSalesforceOutput "Relationship mapping for upsert" parameters

I can't get this to work. There are 4 parameters to input:
Column name of Talend schema
Lookup field name
Module name
External id name
But there is no description of what to enter or how to use it.
Account has a lookup to RB_Country__c: Country__c
RB_Country__c has an externalid field: ExternalId__c
Talend schema column Country__c contains the value of the RB_Country__c.ExternalId__c field.
What are the parameters and how to enter them?
Moderator

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Hi,
Here is a component reference with scenario tSalesforceOutput and Setting up a Salesforce connection. Hope it will help you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Hey is your problem solved?
One Star

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Thnx xdshi but it is not clear to me what a lookup module is. Is this a component I need in my Talend Job?
Do I enter all the names with quotes or without them? Just a simple example would be so helpful
AmparoEmmy: No I have not got it to work sadly..
This feature would be so helpful.
One Star

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Hi,
I got it to work for upserting Cases that have relations to existing Accounts and Contacts. Please note that Accounts and Contacts are somehow special in that they dont't use that "__r" extension like modern (or custom) objects / relations do. (Compare SOQL queries created by e.g. ApexExplorer to get that difference.)
That values I used are:
Column name of Talend Schema Lookup field name Module name External id name
ExtContactId "Contact" "Contact" "ExtContactId__c"
ExtAccountId "Account" "Account" "ExtAccountId__c"
Regards, N.
One Star

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Thanx AIN123. You're example lines helped a lot. Got it working with custom objects.