You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: