Hello!
I am new to Talend Open Studio and cannot get a "simple" upsert to a custom Salesforce object to work. Using the "upsert" action, I have attempted to insert and update records and I am receiving the same error on both. The error is:
java.lang.Exception: java.lang.Exception: P21_Quote_Number__c not specified
The salesforce custom object is named Quote__c and has P21_Quote_Number__c set up as an external ID. (Our current Boomi integration is working okay, so the salesforce set up should be okay.)
The tLogRow output shows that data for P21_Quote_Number__c is populated.
In Talend on the basic settings tab I have set the "Upsert Key Column" to P21_Quote_Number__c.
I have also tried setting up the Relationship mappings on the advance settings tab and I still get the same message.
What am I doing wrong?
You don't need a tMap to remove the entries.
Just click the Edit Schema button and remove the fields that you don't need.
The export jobs you right click on it and choose Export Items...
Glad your issue is resolved.
Hi, there, I have a job in which data is coming from an input file and is being loaded in Salesforce through DataMap. There is an Upsert operation on a custom object named Recurring Donation which has a lookup for Account and Contact. Object: Recurring_Donation__c Lookup Account: Organization__c Lookup Contact: Primary_Contact__c In Advance setting of tSalesforceOutputBulkExec component, I have specified the fields from drop down menu, and in Lookup Relationship Field name I have written Organization__r and Primary_Contact__r and specified their External_IDs. It is giving me an error of Invalid Batch Found. Please help me out. Thanks, Stuti
