AX1749

OData API

You can use the Axiom OData API in your custom solutions to access data from the Axiom database. The Open Data Protocol (OData) is a standard data access protocol for the web. Information technology professionals can use the OData API to enable connectivity from third-party tools such as Tableau, Microsoft PowerBI, Qlik, and any others that follow the OData standard.

In order to use the OData API, you must:

  • Enable the OData API for use in your system using the EnableODataAPI system configuration setting.

  • Authenticate the API request using an Axiom user name and password. All requests for data from the API will honor the security settings for the specified user.

  • Use standard OData API syntax to request data from tables in Axiom. Data is returned in a JSON format.