Skip to main content
Zuora Logo

AQuA Job Finder

Zuora

AQuA Job Finder

  1. Last updated
  2. Save as PDF

The AQuA Job Finder enables you to view all AQuA requests and results executed on your tenant up to the last 72 hours. AQuA results older than 72 hours are automatically purged from the system. Excessive usage of non-stateful, full queries is not advised, and instead, stateful AQuA should be used. 

Note that the completed AQuA jobs that were created 180 days ago are deleted permanently from Zuora, so you cannot query these jobs through API or AQuA job finder.

AQuA Job Finder

To browse to the AQuA Job Finder:

  1. Click your username at the top right-hand side.
  2. Navigate to Settings > Reporting > AQuA job finder.

AQuA Job Finder

 

Column Name Description
Start Time The time the AQuA job was started.
Partner

The partner field indicates the unique ID of a data integration partner. The dropdown list of this field displays partner IDs for the past thirty days.

It must be used together with "project" field to uniquely identify a data integration target.  

For example, if a continuous AQuA session is to retrieve data incrementally for a

Salesforce.com Org 00170000011K3Ub, you can use partner as "Salesforce", and "project" as "00170000011K3Ub." 

This field is required only if you are using AQuA in stateful mode. Otherwise, if you are using AQuA in stateless mode, partner field can be null.

Submit a request at Zuora Global Support to obtain a partner ID.
Project

The project field contains the unique ID of a data integration project for a particular partner. The dropdown list of this field displays project IDs for the past thirty days.

This field must be used together with partner field to uniquely identify a data integration target. 

This field is required only if you are using AQuA in stateful mode. Otherwise, if you are using AQuA in stateless mode, partner field can be null.
Status

The job status. Status types are:

  • Submitted: The job was successfully submitted upon successful validation of the JSON request.
  • Executing: The job is being processed.
  • Completed: The query was executed successfully. Click completed to download a gzip archive of the results.
  • Error: There are some validation errors in the JSON input, and the job ID will not be available.
  • Aborted: The execution stopped because one of the queries failed. Check the error code and error messages for more details.
  • Pending: The job is extracting data from the database.