OData API & Reporting

Load file data into the database with Simple Import or Import-Merge.

8 articles

Reporting and Data Export OverviewThe platform stores data that can be reviewed directly within the application for most day-to-day needs.

OData API ReferenceThe platform provides two versions of its OData API.

Configuring OData ResourcesThe platform exposes data to external tools through its OData interface.

Creating XML OutputProcesses can be configured to generate XML output instead of the standard spreadsheet-based reports.

Using Power QueryOnce you have connected Excel to the platform via OData, Power Query opens with a preview of your data.

Connecting to OData in ExcelYou can connect Excel directly to your instance using the OData interface, allowing you to load data into Excel and use Power Query to filter,…

Retrieving Deleted Records via ODataStandard OData queries return new and updated records, but do not indicate which records have been deleted.

Creating a Virtual Object without UnitsWhen numeric attributes are exposed through the OData interface, any attribute that has a unit of measure configured is returned as a combined field…