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?
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.
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.
