Knowledge Center

Knowledge Center > API > Aggregate Query API (AQuA) > AQuA Job Finder

AQuA Job Finder

Table of contents

The AQuA Job Finder enables you to view all AQuA requests and results executed on your tenant over the last seven days.  AQuA results older than seven days are purged from the system.

AQuA Job Finder

You can find the AQuA Job Finder at one of the following URLs: 

  https://www.zuora.com/apps/BatchQuery.do

  https://apisandbox.zuora.com/apps/BatchQuery.do

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.

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

 

Last modified
13:54, 5 Apr 2016

Tags

Classifications

(not set)