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

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.


Argument Type Description
dbid GUID  The ID of the database
table String  The name of the database table
Query parameter Required Default Options Description
fields     Returns selected fields
filter       Sets filter
skip       Returns data starting from the given item
top     Max 200  Returns the given number of data items



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

  1. GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Notifications/query?fields=id;Subject;NotificationName;new;read&filter=[new] or not [read]
  2. Accept: text/json
  3. Accept-Encoding: deflate,deflate,deflate
  4. Authorization: Basic YWRtaW46YWRtaW4=
  5. Host: localhost:6496
  6. Cookie: sid=f90ee664-ac23-45e3-b1a4-f64dd3bb82af
  1. Transfer-Encoding: chunked
  2. Content-Encoding:
  3. Cache-Control: no-store
  4. Content-Type: text/json; charset=utf-8
  5. Date: Tue, 08 Jan 2013 14:32:16 GMT
  6. Server: Microsoft-HTTPAPI/2.0
  8. {
  9. "IsTooManyItems": false,
  10. "Items": [
  11. {
  12. "id": "634ab5fb-75cb-41a3-b706-704b7a7cf0f3",
  13. "Subject": "You have delayed task ‘T2688’",
  14. "NotificationName": "Overdue task event (Executor)",
  15. "new": true,
  16. "read": false
  17. }
  18. ]
  19. }