Salesforce Upsert

[Raj008]

Hi All,

We're using the salesforce output tool to regulalrly update datasets in a customer app, which will mean dong an upsert behvaiour to update existing rows form the previous load, and add new ones. With 'existing' essentially being an external identifier field (ie not the Salesforce record ID) and the new ones being...well the new ones.

The output tool allows an update operation only, and requires the 'Id' field.

So my questions is will the handle inserts too, and can the id be identified as an external identifier.

Thanks,

Raj...

[jrgo]

Hi @Raj008 

According to the help doc for the Salesforce Output tool, it does support inserts, but the "id" field should not exist... I assume because it will automatically be added with its unique value.

https://help.alteryx.com/20212/designer/salesforce-output-tool