[Bug]: Salesforce upsert using internal id: the id field tuple not to be sent if stream field is empty (insert)

[liosc]

Apache Hop version?

2.3.0

Java version?

jdk-11.0.15.10

Operating system

Windows

What happened?

When in Salesforce upsert transform you used the internal id as "Upsert comparison field", the tuple regarding this field should not be sent in case the stream field value is null or empty. This is the insert scenario where you don't have a Salesforce id so you leave the stream field empty or null. At the moment in this case the transform gives back the error "Errors were found on item 0 Error code is: INVALID_ID_FIELD Error message: ID referente: tipo non corretto valore ID: ". Removing the field from the fields table, the error disappears but that means the need to have two transforms, one for inserting and one for updating. The same concept of "upsert" is lost.

Issue Priority

Priority: 1

Issue Component

Component: Transforms