CONTENTS
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,