Skip to navigation
ExtensibilityWorkflowCreate and manage workflow definitionsWorkflow referenceWorkflow task referenceRetrieve: AQuA Query

Retrieve: AQUA Query - Task settings

View as Markdown

Describes the task settings of the Retrieve: AQUA Query task.

Fields tab

  • Object: Select the data object to export data from. Once the object is selected, the field dropdown list is shown.

  • Select the data field to return results for and click Add. Repeat to add all the fields you need.

  • Reorder the list by dragging and dropping the field. The fields will be exported to the output file in the order of top to bottom and left to right.

  • Click the Aggregation button to change the aggregation function to be used. The available functions include Min, Max, Count, Average, and Sum, which vary for different types of fields.

    • Min: Return the minimum value in the set of results for a data field.
    • Max: Return the minimum value in the set of results for a data field.
    • Count: Return the number of results (entries) for a data field.
    • Average: Return the average of all values in the set of results for a data field.
    • Sum: Return the sum of all values in the set of results for a data field.

Conditions tab

Enter a query in the query text field. The two dropdown lists are intended to help you enter object fields and workflow data fields in your query.

  • Convert to currencies: Optional. Specify the currency that you want to convert transaction amounts into by using the ISO currency codes.
  • Project: The unique ID of a data integration project for a particular partner. This field must be used together with the Partner field to uniquely identify a data integration target. This field is required only if you are using AQuA in stateful mode.
  • Partner: The unique ID of a data integration partner. It must be used together with the Project field to uniquely identify a data integration target. This field is required only if you are using AQuA in stateful mode. Submit a request at to obtain a partner ID.
  • Stop when no result returned: If a query returns no results, the subsequent tasks in the workflow will have no data to process. If you want the workflow to stop in this case, enable this option.
  • Use query labels: When this option is enabled, the object and field API names are used for the CSV header output instead of the field labels.
  • Standardize datetime to UTC: When this option is enabled, the exported records are rendered according to ISO-8601 generic UTC form when using WSDL 69 and later.

Concurrency Mode

Concurrency Mode: Controls whether Workflow processes tasks in a single or multi-threaded manner for this task type. Select Sequential to single-thread, or Parallel to allow multi-threaded processing.

If you select Parallel, the Max Concurrency setting controls the maximum number of threads for this task type that can be utilized. You can specify a value from 1 up to the allowed maximum for this task type. A value of 1 behaves the same as Sequential processing.