Processing SalesForce Input Row by Row and handle error in one record but keep working
Hello community,
I have a job that extracts some data from a custom object in SalesForce. It has to do some transformation an change the value of a field for that record. The problem is, while processing each record, an error may arise (federation, user validation, etc) but the whole job fails (in case Die on Error is checked) or all the records go by without making the appropiate changes.
The expected behaviour should be: get Record 1, make the change, if it's no-ok then leave that record and continue with Record 2 that might be ok.
If I leave the checkbox of Die on Error unchecked then both records are sent to the log and the jobs stops without failure.
Tried to put a tFlowToIterate connected from the tMap to the tSalesforceOutput but It doesn't get connected.
