Bulk Query
A 3-step recipe with Salesforce. We can help you get access.
Recipe · 3 steps
Bulk Query
with Salesforce
Extract records from Salesforce with a Bulk API 2.0 query job.
- Create a new Bulk API 2.0 query job from the supplied SOQL statement. The job is processed asynchronously.
- Poll the query job state. When the job reaches JobComplete, continue to retrieve results; while still InProgress or UploadComplete, loop back to poll again; if the job Failed or Aborted, stop the workflow.
- Retrieve the query results as CSV once the job has reached JobComplete. The first row is a header of field API names.
What you'll need to have ready
- query: The SOQL query to run (e.g. SELECT Id, Name, Email FROM Contact WHERE CreatedDate = LAST_YEAR).
- operation: The query operation: query for active records only, or queryAll to include soft-deleted and archived records. Defaults to query.
- maxRecords: Maximum number of records to return when fetching results.
For your developer
Arazzo workflow salesforce:bulk-query, 3 operations: createQueryJob → getQueryJobInfo → getQueryJobResults. Specs on APIs.io.