Table of Contents | ||
---|---|---|
|
Overview
Description | Getting the schema of a table |
Resource Path | /analytics/tables/{tableName}/schema |
HTTP Method | GET |
Request/Response Format | application/json |
Authentication | Basic |
Parameter description
Parameter | Description |
---|---|
{tableName} | The name of the table of which the schema is required. |
Sample cURL command
Code Block |
---|
curl -H "Content-Type: application/json" -H "Authorization: Basic YWRtaW46YWRtaW4=" -v https://localhost:9443/analytics/tables/ORG_WSO2_DAS_SAMPLE_SMART_HOME_DATA/schema -k |
Example
Code Block | ||
---|---|---|
| ||
GET https://localhost:9443/analytics/tables/testtable/schema |
Sample output
Code Block | ||
---|---|---|
| ||
{
"columns":
{"house_id":{"type":"INTEGER","isScoreParam":false,"isIndex":false},"metro_area":{"type":"STRING","isScoreParam":false,"isIndex":false},"state":{"type":"STRING","isScoreParam":false,"isIndex":false},"device_id":{"type":"INTEGER","isScoreParam":false,"isIndex":false},"power_reading":{"type":"FLOAT","isScoreParam":false,"isIndex":false},"is_peak":{"type":"BOOLEAN","isScoreParam":false,"isIndex":false}},
"primaryKeys":[]
} |
REST API response
HTTP status code | 200, 404 For descriptions of the HTTP status codes, see HTTP Status Codes. |