Generic Inquiry

IMan allows you to query data from a generic inquiry and the recommended approach for extracting data from Acumatica.

  • Quick - Performance, dependent on the query is typically better than querying the objects themselves.
  • Consumes a single API Call - Since all data is returned from a single request.

Filter Records Expression

The expression here allows you to pass values to the Parameters defined on the Generic Setup.

To pass a value to OrderNbr parameter would be:

OrderNbr = '000999'

The equal sign on the parameter expression does not have any impact on the query itself. The operation is controlled by the Generic Inquiry Condition(s).

Multiple Parameters

Multiple parameters can be specified by and-ing each parameter. For example:

OrderNbr = '000206' And CustomerClass = 'ABC'

Parameterising from Incoming Data

It is possible to dynamically set the values of the parameters by mapping an incoming transform to the Acumatica reader.

For example:

OrderNbr = '%[OrderNumberStart]' And CustomerClass = '%[CustClass]'

If the example incoming IMan fields were OrderNumberStart and CustClass

Top N Records Expression

Returns on the first X number of records.

Use Individual Records for Each Record

Not used for Generic Inquiries.

Acumatica Setup - Generic Inquiry Setup

When configuring the Generic Inquiry, it is important to add it to Webservices.

  1. Expose the Generic Inquiry to OData.
  2. Ensure the Generic Inquiry is added to the Webservice Endpoint.