Publishing a table to the API

DataMart tables can optionally be published for consumption directly from the Access API.

There are several benefits to doing so. Firstly, users that are not well versed in writing SQL queries can utilize standard tools with graphical user interfaces to access mart data, including as OmniFi Access query, Power BI or Tableau. Users don't have to be aware of the source of the information, data is accessed using the same methods used to access other information published through OmniFi Functions or Snapshots.

Secondly, users don't require direct database access to the mart database, instead they have access to mart data over a standard HTTPS connection. This improves security by enforcing the standard practice of not allowing end users into databases, and allows OmniFi to preserve an audit trail of how the data is consumed, and by whom.

To publish an ednpoint for a table, click the the Create Endpoint button in the toolbar:

This will take you to the Endpoints screen, where you can set up the endpoint name, permissions and other configuration. Please refer to Table APIs for further details on publishing tables as API endpoints.