Use the Search parameters button to configure your export search. For example, if you export a list of all your vendors, you can use the search parameters to include or exclude specific fields.
Use the Custom search parameter to specify undefined fields, values not included in entity definitions, and values added to Acumatica ERP from a customized project.
Notice
BAccount.UsrAddress_Code,BAccount.UsrVendor_Code
Use the Expand parameter to specify the linked and detailed entities that should be expanded. By default, no linked or detail entities are expanded; only the top-level entity's fields are returned. Example:
Maincontact/Address
Use the Filter parameter to determine which records should be selected from Acumatica. Let’s say that you want to get a specific list of vendors. In the Filter field, you can specify that you want to get all the exported vendors modified after a specific date and time. You can use handlebars to refine your filters.
Notice
LastModifiedDateTime ge datetimeoffset'{{encodeURI lastExportDateTime}}'
Use the Select parameter to specify the entity's fields to be returned from Acumatica ERP. By default, all fields of the entity are returned. The Select field is optional for operations that “list all” (List all vendors, List all warehouses, and so on). The default value of the Select field is blank, meaning all fields from the entity are returned.
Comments
Please sign in to leave a comment.