I stumbled upon a "problem" with the Salesforce Component - or I am actually not sure if the behavior is desired or not.
If I update ( upsert ) values from existing entries in Salesforce, these changes are not recognized since the value is an empty String. To get the desired behavior - I have to replace all "" with null.
I have a few scenarios how I think this is solvable - but, since I don't want to write a helper function and use it in each field I map, I am looking for something more generic.
- Improved SF component, with that option just checkable (replace all "" with null).
- custom component, looking through all rows, replacing "" with null.
So my question is : How can I create this custom component, automatically "recieving" all the rows and work through them - any ideas?
Can you please clarify in which Talend version/edition you are?
Are you able to try adding one more component tmap in between both your connectors and for that column alone check for empty string if so then set null, something like
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to use an API-First Approach to Modernize your Applications
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs