Salesforce Update Change Data

Questions
1

Describe the problem/error/question

I am using the Salesforce Account Updated node as a trigger for a workflow. Is there any way to get the changed data in the event? So for example if the name of the company has changed then I would like to know that this field has changed.

What is the error message (if any)?

There is no error message, but the payload of the node only contains references to the Account that has been updated, like the id

Please share your workflow

Use the Salesforce Account Updated Trigger, pasting it here contained access credentials, so I am not sure how to share that properly.

Share the output returned by the last node

{
  attributes: [
    type: "Account",
    url: "/services/data/v59.0/sobjects/Account/0010600002ESSxbAAH",
  ],
  id: "0010600002ESSxbAAH",
  name: "Acme",
  type: "Prospect"
}

Information on your n8n setup

  • n8n version: 1.75.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system:
2

Welcome to the community @pdobrigkeit !

Tip for sharing information

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!

I do not have admin access to Salesforce but I think there should be a few things done to achieve what you want.

  1. Enable Tracking Object Field History
  2. Query the History object with Salesforce node using Search resource and custom Query.

The query example is givan on Salesforce Help and looks something like

SELECT ParentId, FieldHistoryType, Field, Id, NewValue, OldValue 
FROM FieldHistoryArchive 
WHERE FieldHistoryType = 'Account' AND ParentId='0010600002ESSxbAAH'