AQuA API Introduction
The Aggregate Query API (AQuA) is a REST API that executes multiple Export ZOQL or ZOQL queries. The queries are performed in a sequential order and in a single read-only database transaction.
Why Use AQuA API?
Using the AQuA API, you can do the following:
- Continuously query data
You can export data incrementally, instead of exporting all of the data, all the time.
- Export deleted data
- Export files in segments
When you have large amounts of data, you can export your data in segments, instead of using bulky exports which can timeout.
In addition, AQuA API supports the following:
- Stateless and Stateful Modes
- AQuA Job Finder for monitoring purposes
- Notification upon completion
Authentication
Zuora recommends that you use OAuth v2.0 to authenticate to the REST API. Authenticating via OAuth requires the following steps:
-
Authenticate subsequent API requests by providing a valid bearer token in an HTTP header:
Authorization: Bearer {token}
If you have Zuora Multi-entity enabled and your bearer token is valid for more than one entity, use the Zuora-Entity-Ids
header to specify which entity to perform each API request in. If your bearer token is only valid for a single entity, or you do not have Zuora Multi-entity enabled, you do not need to set the Zuora-Entity-Ids
header in your API calls.
See Authentication for more information about how to authenticate to the REST API.
Steps overview
-
View AQuA requests and results in the AQuA Job Finder (optional)
Limits
AQuA enforces the following limits:
- The maximum processing time per query is 3 hours. If a query in an AQuA job is executed for longer than 3 hours, this job will be killed automatically. See the best practices for bulk data extraction with AQuA.
- The maximum number of queries in an AQuA job is 50.
- AQuA enforces limits on both the stateful concurrent AQuA jobs and the stateless concurrent AQuA jobs per tenant:
- The maximum number of stateful concurrent AQuA jobs per tenant is 50.
- The maximum number of stateless concurrent AQuA jobs per tenant is 50.
- Submitted
- Executing
- The ChargeMetrics and ChargeMetricsDiscountAllocationDetail objects are not available through AQuA. You can access them through Data Query or Charge Metrics API.