โ04-18-2018 03:31 AM
There is no unique id/field/column to select in the snap so that, we can update that particular record/row in the table.
โ04-23-2018 09:43 AM
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.
โ04-23-2018 12:57 PM
@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.)
Salesforce Read
Mapper
Disclaimer: I mocked this up without testing, so please excuse any typos.
โ04-25-2018 02:45 AM
Thank You @del