cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How does the Salesforce Update snap work?

GBekkanti
New Contributor III

There is no unique id/field/column to select in the snap so that, we can update that particular record/row in the table.

7 REPLIES 7

You stated that you canโ€™t see the empNo column in the mapper snap. It may be due to the permissions on the column for the user id you are using.

del
Contributor III

@GBekkanti, to use the Salesforce Update snap, you must have the Salesforce record โ€œIdโ€ present in the document. So your upstream snaps will need to capture the Id from Salesforce for the particular record(s) you want to update and pass the Id through to where you can include it in the Mapper before the update snap.

Hereโ€™s a simplistic example to increase all the Sales department by $5. Notice, only Id and Salary__c are required in the Mapper. Department__c is not required in the Mapper. (I did include it in the Read snap Output fields, but it wasnโ€™t necessary unless you want to use a downstream Filter snap instead of the Read snapโ€™s Where clause.)
image


Salesforce Read
image


Mapper
image

Disclaimer: I mocked this up without testing, so please excuse any typos.

GBekkanti
New Contributor III

Thank You @del