Now, after we have persisted data in the table, we will start looking at ways of querying data from the server. Querying data should be our main concern when designing our tables in order to achieve maximum performance and avoid performance pitfalls.
Remember that tables are designed to store large amounts of records with extremely fast read/write operations; there are no relations between tables and thus no complex joins or queries.
Table service REST API supports querying the tables by performing GET
operations; the service is actually a partial implementation of the OData protocol. All requests should be authenticated using HTTPS
; responses from the service can be retrieved in Atom Pub, XML, or JSON format depending on the HTTP request header.
An authenticated request to get all tables under a storage account might have a URI as follows:
https://<account-name>.table.core.windows.net/Tables
To get all entities in a table, the URI would look like:
https://<account...