The following characters must be encoded if they are to be used in a query string: Within a $filter clause, you can use comparison operators to specify the criteria against which to filter the query results.įor all property types, the following comparison operators are supported: OperatorĪdditionally, the following operators are supported for Boolean properties: Operatorįor more information about filter syntax, see the OData Protocol Specification. Note that the $top query option in the case where results are paginated specifies the maximum number of results per page, not the maximum number of results in the whole response set.Īdditional query options defined by OData are not supported by the Table service. See Query Timeout and Pagination for additional information. Otherwise your subsequent requests may return unexpected results. For example, if you have specified a $filter, $select, or $top query option as part of the original request, you will want to include that option on subsequent requests. When making subsequent requests that include continuation tokens, be sure to pass the original URI on the request. You can specify additional options to limit the set of tables or entities returned, as described in the following Supported Query Options section.Ī request that returns more than the default maximum or specified maximum number of results returns a continuation token for performing pagination. Ordering results in any other way is not currently supported. Query results are sorted by PartitionKey, then by RowKey. To return all entities in a table, specify the table name on the URI, without the Tables resource: () To return a single named table, specify that table as follows: ('MyTable') The basic URI for addressing the Tables resource is as follows: To return all of the tables in a given storage account, perform a GET operation on the Tables resource, as described in the Query Tables operation. The following sections describe query options and demonstrate some common scenarios. Querying tables and entities in the Table service requires careful construction of the request URI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |