SAP Data Services for Updating Records in Salesforce

[former_member733020]

We have a process that aggregates data from SAP and updating Contact record in SalesForce. Part of the data enrichment is to find an Account record in SFDC and include it in the Contact record.

This process is properly updating Contact in SFDC by using a custom field that is marked as External ID on the Contact object

We are trying to use exact same process to update Account record in SFDC (without having Account ID), by utilizing similar External ID field on Account record, but instead of finding an Account and updating it, it is always trying to create a new record, and because this field is also marked as unique. The Insert operation is failing when Account Record with such value already existing.

Would appiciate any ideas on what may be the reason why it is working as designed for Contacts but not Accounts.

[KatiNonhebel]

Thank you for visiting SAP Community to get answers to your questions. I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond:https://www.youtube.com/watch?v=46bt1juWUUM

Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

Good Luck

Kati - SAP Community Moderator