Update a data field with automation

[Automagical]

Hi,

I’m trying to update Salesforce Records using the Beta automation. I was able to successfully create new records, but when I try to update records the automation test fails:

Salesforce reported an error while processing this action:
NOT_FOUND: Provided external ID field does not exist or is not accessible

I’m not quite sure what to enter as the Salesforce record ID. The Salesforce record type doesn’t have a primary key. Is that what’s causing the error or is the record ID something else?

[Abhishek_Kumar]

Hi Annelise,
Did you find any answer?
Im
I’m facing the same problem.

[ScottWorld]

Every record in a Salesforce object has a unique ID.

If you don’t know what the ID is, try setting up a Salesforce Sync which will bring the ID’s into Airtable for you:

Airtable Support

Airtable Sync: How to sync Salesforce with Airtable

External source sync allows you to bring information from Airtable bases and other external tools into a single, centralized table. This feature will be available for all enterprise customers. This...

You can also update Salesforce records without knowing the ID in advance by using a professional automation tool like Integromat, which lets you perform more advanced automations — for example, you can search for records in Salesforce based on a criteria that you specify, and then update all of (or some of) the records that match your search results:

Integromat

Salesforce Integrations

Integromat gives you the ability to integrate Salesforce with many other services.