Understanding 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 a business view and return aggregate amounts.

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

When you add a data request to an orchestration, all the defined fields are automatically added to the orchestration as inputs. As a result, you can 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.