Returns the list of all records of the given database table

GET

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

This request is used for getting the list of all records of the given database table. The list can be filtered by using parameters 'filter', 'skip' and 'top'.

Request:

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

Query parameter	Options	Description
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

Request:

GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Notifications
Accept: text/json
Accept-Encoding: deflate
Host: localhost:6496
Cookie: sid=d8ee1782-edf8-4ca0-88df-514db7d23043

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Fri, 21 Dec 2012 14:53:33 GMT
Server: Microsoft-HTTPAPI/2.0
 
{
  "IsTooManyItems": false,
  "Items": [
    {
      "Id": "634ab5fb-75cb-41a3-b706-704b7a7cf0f3",
      "InfoName": "Notifications",
      "ModifiedStamp": "2012-12-21T16:53:29.7320511+02:00",
      "Properties": {
        "Id": "634ab5fb-75cb-41a3-b706-704b7a7cf0f3",
        "RecipientUser": "ae18dea5-4f60-4f70-ae31-d8052984e31e",
        "DatabaseId": "00000000-0000-0000-0000-000000000000",
        "NotificationName": "Overdue task event (Executor)",
        "New": true,
        "Tag": "bd4bec9c-84bf-4647-80d0-775150a0c881",
        "Urgent": true,
        "Tags": null,
        "CreatorUser": "943ed8ca-efd5-4315-842d-b52c3c7becc6",
        "EventKind": "OverdueEventKind",
        "Subject": "You have delayed task ‘T2688’",
        "Description": "Task: ‘Celebrate the end of the world’\r\nDue date: 21.12.2012 8:00\r\nAssignments: admin",
        "CreatedTime": "2012-12-21T16:53:29.7270506+02:00",
        "Read": false,
        "Url": "centriqs://findentity/T2688",
        "ModifiedStamp": "2012-12-21T16:53:29.7320511+02:00"
      }
    }
  ]
}