Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Background
I am inserting CSV data into Salesforce.
The tSalesforceOuput component has the Retrieve Id checkbox ticked, and it's doing an UPSERT, yet the salesforce_id and salesforce_upsert_status fields are missing from the schema.
Questions
1. Why would they disappear after originally being there?
2. How can I get Talend to put them back?
The tSalesforceOutput schema corresponds to the input schema for this component.
Fields salesforce_id and salesforce_upsert_status are available on the output schema only.
They disappear when you untick the Retrieve Id option.
Thanks for responding.
When you say "Fields salesforce_id and salesforce_upsert_status are available on the output schema only."
Are you referring to the output schema I see on the right-hand-side when I select Edit schema on the tSalesforceOutput component?
There is no right-hand-side on the schema popup in this case, but if you click on the link after the tSalesforceOutput or if you open the schema for the next component, you will see these fields (at least for version 6.4.1)
When I select Edit schema in the Basic setting panel of the tSalesforceOutput I get a left and right side.
Left: RowName (Input)
Right: ComponentName (Output)
And then connected to the tSalesforceOutput is a tHashOuput and then connected to that is a tFileOutputDelimited
I am using version: 7.0.1.20180411_1414
Not the same for 6.4.1, maybe an other bug (?) for the new version
Feel free to upgrade and let me know
No thanks! At this time I prefer to stay with 6.4.1 until the end of my current project...