Returns the list of all records with selected fields of the given database table

GET

api/databases/{dbid}/tables/{table}/query

This request is used for getting the given database table records list that includes values of selected fields only. For example, you can get the list of records from table 'TmSchedulerRecord', including fields as 'start', 'finish', 'allday' only: ?fields=start;finish;allday
Also this request can contain expressions which will calculate the values of selected fields according to the formulas.

Request:

Argument	Type	Description
dbid	GUID	The ID of the database
table	String	The name of the database table

Query parameter	Required	Options	Description
fields	1		Returns selected fields
filter			Sets filter
skip			Returns data starting from the given item
top		Max 200	Returns the given number of data items

Response:

Content

Name	Type	Options	Description
IsTooManyItems	Boolean		Is too many result objects
Items	Array of Object		Result object list

The query returns a list of notifications according to the condition [new] or not [read] with selected fields only Id, Subject, NotificationName, New, Read

Request:

GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Notifications/query?fields=id;Subject;NotificationName;new;read&filter=[new] or not [read]
Accept: text/json
Accept-Encoding: deflate,deflate,deflate
Authorization: Basic YWRtaW46YWRtaW4=
Host: localhost:6496
Cookie: sid=f90ee664-ac23-45e3-b1a4-f64dd3bb82af

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Tue, 08 Jan 2013 14:32:16 GMT
Server: Microsoft-HTTPAPI/2.0
 
{
  "IsTooManyItems": false,
  "Items": [
    {
      "id": "634ab5fb-75cb-41a3-b706-704b7a7cf0f3",
      "Subject": "You have delayed task ‘T2688’",
      "NotificationName": "Overdue task event (Executor)",
      "new": true,
      "read": false
    }
  ]
}