Configuring a Data Request

You can configure a data request to:

  • Query and return data from an EnterpriseOne table or business view.

  • Perform an aggregation of data from a table or business view and return aggregate amounts.

In a standard data request that returns data directly from a table or business view, you can use variables to define the return fields. In a data request that performs an aggregation, you can use variables to define the "group by" fields and the returned aggregate amounts.

When you add a data request to an orchestration, any variables used to define the returned data in the data request are automatically added to the orchestration as inputs. This enables you to map the returned data to subsequent steps in an orchestration.

Important: Variables are only supported in the first row of a response. If a query contains multiple rows, only the values from the first row will be available as variables.