Configuring a Data Request to Retrieve a Data Set

1. On the Data Requests design page, enter a name for the data set in the Data Set Variable Name field.

2. Define the filtering criteria for the data set.

3. In the grid, click the Return icon ( ) next to the fields that you want the data request to return in a data set.

4. In the Return Fields and Variable Names section, enter a variable name for each return field.

Starting with Tools Release 9.2.8.2, you can reorder all the selected columns in each section of the data request, including the Returns and Aggregations, by dragging and dropping the rows. The system preserves the order that you set when you Save the changes and reflects this order in Orchestration Outputs when the Data Request is added to an orchestration. This feature improves readability and enables orchestrations to easily integrate with user interfaces or third-party systems that might be sensitive to the order of outputs.

Note: Order of name-value pairs in JSON is not important or guaranteed but in most cases, the orchestration output reflects the order set at design time. If you use Output Array to File to create a CSV file, the system reflects the order of grid data specified at design time.

For more information about configuring a data request, see Configuring a Data Request.