Used to get data from Data Table.
Method | POST |
Endpoint | https://{{host}}/api/public/tables/{{tableName}}/query?sys_limit={{limit_value}}&sys_offset={{offset_value}} |
Content Type | application/json |
Authorization |
|
App Access |
Read access to the Data Table from the Data Definition in DaaS. For more information, see app assignment for accessing the data in a table and Data as a Service articles. |
Path Parameters
Parameter | Description |
---|---|
host | Environment URL, for example, https://bots.kore.ai |
tableName | Name of the Table to fetch data |
sys_limit | The maximum number of records to be fetched. By default this is set to 10 and the maximum allowed is 100. |
sys_offset | The number of records to be skipped from the beginning of the results dataset. |
Sample Request
curl -X POST \ 'https://{{host}}/api/public/tables/{{tableName}}/query?sys_limit=4&sys_offset=0' \ -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}' \ -H 'content-type: application/json' \ -d '{ "query":{ "expressions": [ {"field": "firstName", "operand": "=", "value": "Jane"}, {"field": "lastName", "operand": "=", "value": "Doe"} ], "operator": "or" } }'
Body Parameters
Parameter | Description |
---|---|
query |
Filter criteria identifying the rows to be fetched  "query":{ "expressions": [ {"field": "<col1_name>", "operand": "=/!=/</>", "value": "<value1>"}, {"field": "<col2_name>", "operand": "=/!=/</>", "value": "<value2>"} ], "operator": "and/or" } |
Sample Response
{ "hasMore": true, "total": 2, "metaInfo": [ { "name": "gender", "type": "string" }, { "name": "lastName", "type": "string" } ], "queryResult": [ { "age": male, "last_name":tony, } ] }