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

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.

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
15:57, 27 Jun 2017

Tags

Classifications

(not set)