Skip to content

Exporting General Inquiry Data from Acumatica

This task can export data from any general inquiry (GI) in your Acumatica account, so long as it is exposed via the OData API. The data will be saved to an XML file.

This task is often used to export modified stock item quantity available data, because the contract based REST API does not have the ability to do so.

Settings

Acumatica Connection

Required
The Acumatica connection to use. See the Connecting to Acumatica article if you require more information on how to create/manage connections.

Export Settings

Required
Settings to control whether new, modified or all records will be exported from Acumatica. The following options are available:

  • Date Field - The name of the field to use for date filtering. This would usually be the last modified date or the created date.
  • Date Value - When date filtering is enabled, only records where the value of the date field is greater than this will be exported. The date will update automatically each time the task runs, to the greatest date among the records returned.
  • Enabled - Set to True to enable date filtering, or False to export all records.

Filters

Optional
Filter the export based on the value of specific fields. The filter is specified using OData syntax, e.g. CustomerID eq 'C0001'. For more details on the syntax, please refer to Acumatica's documentation.

Page Size

Required
The maximum number of records to fetch from the Acumatica API at a time. The value must be at least 1. Defaults to 100.

Parameters

Optional
If the General Inquiry takes any input parameters, they can be specified here. Add a new variable to the collection for each parameter you want to provide, then set the key to the parameter name, and value to the parameter value.

Resource

Required
The name of the general inquiry to export data from.

Select

Optional
Used to specify the fields that should be exported. The fields can either be specified as a comma separated string, or using the 'List' Zynk object type. Leave empty to export all fields. For more details on how to specify fields, please refer to Acumatica's documentation.

Tenant Name

Required
Enter the name of the tenant to export data from.

Timeout

Optional
The length of time to wait for responses from the Acumatica API. If not specified, the timeout will default to 100 seconds.

Output File

Required
The name of the file to export the data to. The data will be output in XML format, a sample of which is shown below.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<Records xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Record>
    <InventoryID>TSHIRT-M-WHITE</InventoryID>
    <Description>Medium t-shirt in white</Description>
    <Warehouse>01</Warehouse>
    <QtyOnHand>131</QtyOnHand>
    <QtyAvailable>127</QtyAvailable>
    <INSiteStatusByCostCenter_lastModifiedDateTime>2026-08-28T13:00:53.8000000Z</INSiteStatusByCostCenter_lastModifiedDateTime>
  </Record>
</Records>