Endpoints for Client Users

The following information provides information on Data Insights API endpoints available for client users. Available endpoints include:

/apim_3E_url/datainsights/odata/$metadata

/apim_3E_url/datainsights/odata/{entity}

/apim_3E_url/datainsights/odata/{entity}{id}

Click here for examples of global and country-based OData API URLs.

/apim_3E_url/datainsights/odata/$metadata

GET /apim_3E_url/datainsights/odata/$metadata - Retrieves Schema/Table/View information from Database

Metadata would return the schema name, all tables/columns properties and views from the Database.

Example Request

/apim_3E_url/datainsights/odata/{entity}

GET /apim_3E_url/datainsights/odata/{entity} - Retrieves all records of a table from a Database

Note: If the schema(dbo) is not specified then the API would return a 500 error. Schema and Entity name are separated by _ (underscore) e.g. dbo_Activity

Example Response

/apim_3E_url/datainsights/odata/{entity}{id}

GET /apim_3E_url/datainsights/odata/{entity}{id} - Retrieves entity from a database table by primary key of the table.

The following keys are accepted in the request body 

$filter, $orderby, $select, $top, $skip,