I am trying to use the Upsert component to perform and Update (if exists) and Insert (if not exists). The component is asking me to set an Id for the Upsert. If it is a new record, what should be the Id? I tried setting it to null, but that didn't work.
Yes, I am running into same error when trying to upsert with a NULL contact_id since i want this record to be created in Salesforce Sales Cloud and it doesnt exist so Salesforce should assign the internal application id
Able to resolve this on my end (v1.68.5), ensure that there is no ID value (should be NULL) in your stage table for your records you'd like created in SFDC. Also ensure that the Salesforce ID field value in the component is set to the native SFDC "Id" field of the object you're trying to create in SFDC. My below example is creating a new contact via upsert and currently working:
Hello @sadanamunduru, it may be hard for me to help you without seeing the data but if your custom object in SFCRM, "License__C" has duplicate IDs, this is normally the error I see. I'd login into your SFCRM "License__C" object and ensure there are no duplicate IDs. If SFCRM has no duplicate IDs, double-check your staging table you are pulling before pushing to SFCRM and also ensure no duplicate IDs exist. If there are no duplicates, I'd double-check with Matillion Support for them to help you. Best of luck!
Hi @DBATT
Thank You for your response. It is issue with some property not been properly given for salesforce output component. Now the issue is resolved.
