query
Creates, updates, deletes, gets or lists a query resource.
Overview
| Name | query |
| Type | Resource |
| Id | azure.digital_twins_core.query |
Fields
The following fields are returned by SELECT queries:
- query_twins
| Name | Datatype | Description |
|---|---|---|
continuationToken | string | A token which can be used to construct a new QuerySpecification to retrieve the next set of results. |
value | array | The query results. Required. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
query_twins | select | endpoint | traceparent, tracestate, max-items-per-page | Executes a query that allows traversing relationships and filtering by property values. Status codes: * 200 OK * 400 Bad Request * BadRequest - The continuation token is invalid. * SqlQueryError - The query contains some errors. * TimeoutError - The query execution timed out after 60 seconds. Try simplifying the query or adding conditions to reduce the result size. * 429 Too Many Requests * QuotaReachedError - The maximum query rate limit has been reached. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
endpoint | string | The service endpoint host (no scheme). (default: ) |
max-items-per-page | integer | |
traceparent | string | |
tracestate | string |
SELECT examples
- query_twins
Executes a query that allows traversing relationships and filtering by property values. Status codes: * 200 OK * 400 Bad Request * BadRequest - The continuation token is invalid. * SqlQueryError - The query contains some errors. * TimeoutError - The query execution timed out after 60 seconds. Try simplifying the query or adding conditions to reduce the result size. * 429 Too Many Requests * QuotaReachedError - The maximum query rate limit has been reached.
SELECT
continuationToken,
value
FROM azure.digital_twins_core.query
WHERE endpoint = '{{ endpoint }}' -- required
AND traceparent = '{{ traceparent }}'
AND tracestate = '{{ tracestate }}'
AND max-items-per-page = '{{ max-items-per-page }}'
;