ExecuteQuery
Run SQL queries to retrieve metadata and time-series data from asset models, assets, measurements, metrics, transforms, and aggregates.
Request Syntax
POST /queries/execution HTTP/1.1
Content-type: application/json
{
"maxResults": number
,
"nextToken": "string
",
"queryStatement": "string
"
}
URI Request Parameters
The request does not use any URI parameters.
Request Body
The request accepts the following data in JSON format.
- maxResults
-
The maximum number of results to return at one time. The default is 25.
Type: Integer
Valid Range: Minimum value of 1.
Required: No
- nextToken
-
The string that specifies the next page of results.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 4096.
Required: No
- queryStatement
-
The AWS IoT SiteWise query statement.
Type: String
Length Constraints: Minimum length of 1.
Pattern:
^[\s\S]+$
Required: Yes
Response Syntax
HTTP/1.1 200
Content-type: application/json
{
"columns": [
{
"name": "string",
"type": {
"scalarType": "string"
}
}
],
"nextToken": "string",
"rows": [
{
"data": [
{
"arrayValue": [
"Datum"
],
"nullValue": boolean,
"rowValue": "Row",
"scalarValue": "string"
}
]
}
]
}
Response Elements
If the action is successful, the service sends back an HTTP 200 response.
The following data is returned in JSON format by the service.
- columns
-
Represents a single column in the query results.
Type: Array of ColumnInfo objects
- nextToken
-
The string that specifies the next page of results.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 4096.
- rows
-
Represents a single row in the query results.
Type: Array of Row objects
Errors
For information about the errors that are common to all actions, see Common Errors.
- AccessDeniedException
-
Access is denied.
HTTP Status Code: 403
- InternalFailureException
-
AWS IoT SiteWise can't process your request right now. Try again later.
HTTP Status Code: 500
- InvalidRequestException
-
The request isn't valid. This can occur if your request contains malformed JSON or unsupported characters. Check your request and try again.
HTTP Status Code: 400
- QueryTimeoutException
-
The query timed out.
HTTP Status Code: 400
- ServiceUnavailableException
-
The requested service is unavailable.
HTTP Status Code: 503
- ThrottlingException
-
Your request exceeded a rate limit. For example, you might have exceeded the number of AWS IoT SiteWise assets that can be created per second, the allowed number of messages per second, and so on.
For more information, see Quotas in the AWS IoT SiteWise User Guide.
HTTP Status Code: 429
- ValidationException
-
The validation failed for this query.
HTTP Status Code: 400
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following: