liosc opened a new issue, #2820: URL: https://github.com/apache/hop/issues/2820
### 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 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@hop.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org