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?
@meta-carl ,you need to use tSalesforceOutput component to update.
I need tDBInput and tSalesforceOutput. Where do i specify the conditions for my update? Update where msyql.externalId = Salesforce.Account.externalId ?
@meta-carl , you need to get the data from mysql and do join with salesforce object and get external id and update salesforce object.
your job should be like below.
tLogRow shows the data I want to update.
I get an Error-Message:
Exception in component tSalesforceOutput_1 (ContactDetail_Account_InvoiceAddress_innerjoin_tMap)
java.io.IOException: Account ID: id value of incorrect type:
What can I do regarding this error?
Exception in component tSalesforceOutput_1 (ContactDetail_Account_InvoiceAddress_innerjoin_tMap)
java.io.IOException: Account ID: id value of incorrect type: