Example curl Request
The following example demonstrates accessing the data service tables endpoint using curl:
curl -X GET
-u "<username>:<password>"
https://<url>/ebis/api/v1/dataservice/metadata/tables
The variables in the previous example should be replaced with the following information when accessing the data service:
<username>: The username of an application user which will access the data service. <password>: The password associated with the user account used to access the data service. <url>: The URL provided to you when the application was deployed.
Limitations
Complex SQL queries cannot be replicated in JSON input. The API supports only:
- Basic select statements with Where conditions for operators EQUALS, NOT_EQUALS, GREATER_THAN, LESS_THAN, GREATER_THAN_OR_EQUALS, LESS_THAN_OR_EQUALS, BETWEEN.
- The API does not support queries using the LIKE, or IN conditions.
In order to execute the complex queries (sub queries, multiple joins, aggregate methods), it is recommended that you:
- Pull the required tables data using the basic select run query endpoint.
- Load the data into a local database.
- Execute complex queries against the local database.
Last Published Tuesday, February 6, 2024