This task exports data from your Zuora data source as the result of executing AQuA queries and based on the conditions you define. The exported data is saved in a CSV file and available for use by subsequent tasks. This task does not work with the iterate task.

To create an AQuA query task, select the data object and fields to retrieve and add the fields to the aggregation list. You can reorder the fields in the list and assign the aggregation function.

If Invoice Settlement is enabled, the following objects are not available:

• InvoicePayment

• RefundInvoicePayment

• InvoiceItemAdjustment

• CreditBalanceAdjustment

• InvoiceAdjustment

Difference between Export and Query

Both the export and query tasks can be used for data retrieval.

The export task, such as this Retrieve: AQuA Query task, retrieves data asynchronously. It initiates the request and checks the status of the data retrieval process later. When the status indicates that all data is retrieved, it exports the data in a CSV file. The export task does not have a limit on the amount of data entries in the result. You can select multiple data objects to export data from.

The query task retrieves data synchronously. It initiates the request and waits for the data to be returned. The maximum amount of data entries in a query task is 2000. You can only select one data object to query data from.

If your workflow requires synchronous data retrieval or runs multiple times per minute, consider using the Object Query task. Frequent export requests may degrade the performance significantly.