BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
7 / 81 · Module 4 — Salesforce Connector · filtered: interview← prev⊞ allnext →

4.6QUERY ALL

There is also:

Query All

The distinction is important.

Regular Query retrieves normal records.

Query All can include records that have been deleted.

The current connector describes query-all as retrieving objects whether or not they've been deleted.

When would you care?

For example:

Data warehouse synchronization

source-of-truth reconciliation

audit pipeline

replication

detect Salesforce deletions

Interview question:

What's Query versus Query All?

Answer:

“Query operates on the normal active Salesforce dataset; Query All is useful for synchronization scenarios because it can return deleted records as well.”

Good enough.