Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Lost output fields salesforce_id and salesforce_upsert_status after making changes and cannot get them back

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?

Labels (3)
7 Replies
TRF
Champion II
Champion II

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.

Anonymous
Not applicable
Author

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?

TRF
Champion II
Champion II

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)

Anonymous
Not applicable
Author

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

 

 

 

 

TRF
Champion II
Champion II

Not the same for 6.4.1, maybe an other bug (?) for the new version

Anonymous
Not applicable
Author

Feel free to upgrade and let me know 0683p000009MA9p.png

TRF
Champion II
Champion II

No thanks! At this time I prefer to stay with 6.4.1 until the end of my current project...