Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Create a Query Job

Creates a query job.

Syntax

URI: /services/data/vXX.X/jobs/query

Available since release:

This resource is available in API version 47.0 and later.

Format: application/json

HTTP method: POST

Authentication: Authorization:Bearer token

Headers: Optionally, use the Sforce-Call-Options header to specify a default namespace.

Request body

The request body specifies the query to be performed.

1{
2  "operation": "query",
3  "query": "SELECT Id FROM Account"
4}

Bulk API 2.0 doesn’t support SOQL queries that include any of these items:

GROUP BY, OFFSET, or TYPEOF clauses.
Aggregate Functions such as COUNT().
Date functions in GROUP BY clauses. (Date functions in WHERE clauses are supported.)
Compound data, such as compound address fields, compound geolocation fields, and FIELDS(). (Instead, query the individual components of compound fields.)
Parent-to-child relationship queries. (Child-to-parent relationship queries are supported.)

Note

You can also specify some optional parameters. For example:

1{
2  "operation" : "query",
3  "query" : "SELECT Id FROM Account",
4  "contentType" : "CSV",
5  "columnDelimiter" : "CARET",
6  "lineEnding" : "CRLF"
7}

Request parameters:

Parameter	Description	Required or Optional
operation	The type of query. Possible values are: `query`—Returns data that hasn’t been deleted or archived. For more information, see query() in SOAP API Developer Guide. `queryAll`—Returns records that have been deleted because of a merge or delete, and returns information about archived Task and Event records. For more information, see queryAll() in SOAP API Developer Guide.	Required
query	The query to be performed.	Required
contentType	The format to be used for the results. Currently the only supported value is `CSV` (comma-separated variables). Defaults to `CSV`. The actual separator can be a character other than a comma. The columnDelimiter parameter specifies what character to use.	Optional
columnDelimiter	The column delimiter used for CSV job data. The default value is `COMMA`. Possible values are: `BACKQUOTE`—back quote character (`) `CARET`—caret character (^) `COMMA`—comma character (,) `PIPE`—pipe character (\|) `SEMICOLON`—semicolon character (;) `TAB`—tab character	Optional
lineEnding	The line ending used for CSV job data, marking the end of a data row. The default is `LF`. Possible values are: `LF`—linefeed character `CRLF`—carriage return character followed by a linefeed character	Optional

Response Body

1{
2   "id" : "750R0000000zlh9IAA",
3   "operation" : "query",
4   "object" : "Account",
5   "createdById" : "005R0000000GiwjIAC",
6   "createdDate" : "2018-12-10T17:50:19.000+0000",
7   "systemModstamp" : "2018-12-10T17:50:19.000+0000",
8   "state" : "UploadComplete",
9   "concurrencyMode" : "Parallel",
10   "contentType" : "CSV",
11   "apiVersion" : 46.0,
12   "lineEnding" : "LF",
13   "columnDelimiter" : "COMMA"
14}

Response Parameters:

Parameter	Description
id	The unique ID for this job.
operation	The type of query.
object	The object type being queried.
createdById	The ID of the user who created the job.
createdDate	The UTC date and time when the job was created.
systemModstamp	The UTC date and time when the API last updated the job information.
state	The current state of processing for the job. Possible values are: `UploadComplete`—The job is ready to be processed and Salesforce has put the job in the queue. `InProgress`—Salesforce is processing the job. `Aborted`—The job has been aborted. See Abort a Query Job. `JobComplete`—Salesforce has finished processing the job. `Failed`—The job failed.
concurrencyMode	Reserved for future use. How the request is processed. Currently only parallel mode is supported. (When other modes are added, the API chooses the mode automatically. The mode isn’t user configurable.)
contentType	The format to be used for the results. Currently the only supported value is `CSV`. JunctionIdList fields and embedded lists can't be returned.
apiVersion	The API version that the job was created in.
lineEnding	The line ending used for CSV job data, marking the end of a data row.
columnDelimiter	The column delimiter used for CSV job data.

Example

This example creates a job that queries Accounts.

1curl --include --request POST \
2--header "Authorization: Bearer token" \
3--header "Accept: application/json " \
4--header "Content-Type: application/json" \
5--data '{
6  "operation": "query",
7  "query": "SELECT Id, Name FROM Account"
8}' \
9https://instance.salesforce.com/services/data/vXX.X/jobs/query

The response is:

1HTTP/1.1 200 OK
2{
3   "id" : "750R0000000zw4yIAA",
4   "operation" : "query",
5   "object" : "Account",
6   "createdById" : "005R0000000GiwjIAC",
7   "createdDate" : "2018-12-17T21:00:17.000+0000",
8   "systemModstamp" : "2018-12-17T21:00:17.000+0000",
9   "state" : "UploadComplete",
10   "concurrencyMode" : "Parallel",
11   "contentType" : "CSV",
12   "apiVersion" : 46.0,
13   "lineEnding" : "LF",
14   "columnDelimiter" : "COMMA"
15}

Bulk API 2.0 and Bulk API Developer Guide

Create a Query Job

Syntax

Example

See Also