GetData Request¶
-
GET/GetData¶ This get request returns data from table.
Example request:
GET /GetData HTTP/1.1 Host: example.com Accept: application/json { "local_database_name": "some-local-name" "query": "SELECT * FROM public.test_table" }
- Request Headers
user_token – User token.
- Query Parameters
local_database_name – Database name for query execution.
query – SQL query to extract data.
Note
Schema name is neccessary in sql request, even if schema is public.
Example response:
HTTP/1.1 200 OK Vary: Accept Content-Type: text/javascript [ { "data": [] } ]
- Status Codes
200 OK – No errors.
403 Forbidden – Access denied. Check token in a header.
400 Bad Request – Bad request. Check request body or headers.
404 Not Found – Table not found