BookatlasTwo-Day MuleSoft → Salesforce Bootcamp
473 / 1048 · Module 11 — Salesforce Bulk Processing + Mule Batch Jobs← prev⊞ allnext →

11.7Bulk query

Bulk isn't only for writes.

Suppose:

Extract 2 million Accounts from Salesforce.

Normal synchronous query may be inappropriate.

Bulk Query API:

Create Query Job
      ↓
Salesforce runs SOQL asynchronously
      ↓
check status
      ↓
retrieve pages/results

The current connector supports Create Query Job Bulk API V2, including QUERY and QUERY_ALL.