Hi, We have a scenario wherein we have to update a field which already have a value in it. We dont want to remove/overwrite the existing value but we would like to append the value coming from a file. Any ideas would be highly appreciated Cheers Jenny.
Hi Jennifer, Can you detail a little more? If you want to update existing records in Salesforce, just use tSalorsforceOutput* component with Update as the action. For this, you need to query first to retrieve the corresponding record Id. You may also use Upsert with an external Id, but in such a case, records not retrieved by Salesforce will be inserted. Regards, TRF
Hi TRF Thank you for the response. File Input: Record 1: Name: jenny Customer Id: 100 Comments: Incorrect Phone Record 2: Name: jenny Customer Id: 100 Comments: Not qualified Now comments field is mapped to a salesforce field of type TextArea. I would like to append data coming from the file, when i use update or upsert the same is not working Cheers J