Excel Add-In for Acumatica

Build 24.0.9060

OData Data Model

The add-in models the Acumatica OData API as relational views. Only read only tables (views) are supported on OData schema.
Any changes to the remote data are immediately reflected in your queries; the table definitions are dynamically retrieved. When you connect, the add-in connects to Acumatica and gets the list of views and the metadata for the views by calling the appropriate Web services.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Views

Shows all the Generic Inquires exposed via OData from Acumatica. The CData Excel Add-In for Acumatica reads view and column metadata dynamically, so it will include both your customizations and any new features that are added to standard Acumatica entities in the future.

Note: Generic Inquiries are not exposed via OData by default, and you may need to expose them. To do this, on the Acumatica Generic Inquiries Screen check the "Expose via OData" checkbox.

Stored Procedures

Stored Procedures are function-like interfaces to Acumatica. They can be used to peform extra tasks that do not fit into the standard operation of directly interacting with a table.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060