Skip to main content

AQuA API Introduction


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:


Zuora recommends that you use OAuth v2.0 to authenticate to the REST API. Authenticating via OAuth requires the following steps:

  1. Create an OAuth client in the Zuora UI

  2. Generate a bearer token

  3. 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.


AQuA query jobs have the following limitations:

  • If a query in an AQuA job is executed longer than 8 hours, this job will be killed automatically.
  • The killed AQuA job can be retried three times before returned as failed.