Understanding Bulk API 2.0 Query

Learn about Bulk API 2.0 availability, supported methods, and limits.

Availability

Query jobs in Bulk API 2.0 are available in API version 47.0 and later.

This table lists the URIs and methods supported by queries in Bulk API 2.0.

URI	HTTP Method	Description
`/services/data/vXX.X/jobs/query`	POST	Creates a query job.
`/services/data/vXX.X/jobs/query`	GET	Gets information about all query jobs in the org.
`/services/data/vXX.X/jobs/query/queryJobId`	GET	Gets information about one query job.
`/services/data/vXX.X/jobs/query/queryJobId/results`	GET	Gets the results for a query job.
`/services/data/vXX.X/jobs/query/queryJobId`	PATCH	Aborts a query job.
`/services/data/vXX.X/jobs/query/queryJobId`	DELETE	Deletes a query job.

Bulk API 2.0 doesn’t support 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 address fields or compound geolocation fields.
Parent-to-child relationship queries. (Child-to-parent relationship queries are supported.)

This table lists the limits of query jobs in Bulk API 2.0.

Item	Limit
The maximum number of query jobs per 24-hour rolling window). The current number can be seen in the DailyBulkV2QueryJobs value in the response to the `/vXX.X/limits/` REST API method.	10,000
The maximum query result size that can be stored in a 24 hour rolling window. The current size can be seen in the DailyBulkV2QueryFileStorageMB value in the response to the `/vXX.X/limits/` REST API method.	1 TB