Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Mysql-Table and want to update Salesforce Account. I have an externalId in Mysql matching an externalId in Salesforce Account. I want to update 5 fields in SF with Values from MySql. Which components do I need on my way?
@TheodoreMateo , your job design should be as shown below.
This design is not the better if you know the Accounts always exist on Salesforce side.
As soon as you have an external ID, I suggest you to use the UPSERT operation on tSalesforceOutput component. Don't need to read the Account object first to retrieve the Salesforce Id and proceed with an UPDATE.