Home

Returns the list of all records of the given entity table

GET
api/databases/{dbid}/entities/{entity}/{id}/{table}
This request is used for getting the list of all records of the given entity table. The list can be filtered by using parameters 'filter', 'skip' and 'top'.

Request:

Argument Type Description
dbid GUID  The ID of the database
entity String  The name of the entity
id GUID  The ID of the entity
table String  The name of the entity table
Query parameter Required Default 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:
  1. GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/entities/Task/08a11e00-188f-45d0-b767-d8620bedbad2/TaskScheduleItems
  2. Accept: text/json
  3. Accept-Encoding: deflate
  4. Host: localhost:6496
  5. Cookie: sid=41f1cc3d-2701-4185-8d3c-8dcd60be24dc
Response:
  1. Transfer-Encoding: chunked
  2. Content-Encoding: 
  3. Cache-Control: no-store
  4. Content-Type: text/json; charset=utf-8
  5. Date: Wed, 26 Dec 2012 13:38:44 GMT
  6. Server: Microsoft-HTTPAPI/2.0
  7.  
  8. {
  9.   "IsTooManyItems": false,
  10.   "Items": [
  11.     {
  12.       "Id": "a3570b1d-3a72-427e-ac38-c3324fb97031",
  13.       "InfoName": "TaskScheduleItems",
  14.       "ETag": "634921327955103976",
  15.       "ModifiedStamp": "2012-12-26T15:33:15.5103976+02:00",
  16.       "IsMarkedAsDeleted": false,
  17.       "Properties": {
  18.         "Id": "a3570b1d-3a72-427e-ac38-c3324fb97031",
  19.         "Users": {
  20.           "Values": [
  21.             {
  22.               "Id": "ae18dea5-4f60-4f70-ae31-d8052984e31e",
  23.               "DisplayText": "admin"
  24.             }
  25.           ],
  26.           "DisplayText": "admin"
  27.         },
  28.         "ReminderForStart": {
  29.           "Offset": {
  30.             "Value": 1.0,
  31.             "Kind": 2,
  32.             "PureWorkTime": 1.0,
  33.             "Title": "1 Days"
  34.           },
  35.           "Users": [
  36.             {
  37.               "Id": "ae18dea5-4f60-4f70-ae31-d8052984e31e",
  38.               "DisplayText": "admin"
  39.             }
  40.           ],
  41.           "HideUsers": false,
  42.           "OffsetKind": -1,
  43.           "Description": "'reminder before start' set via API"
  44.         },
  45.         "ReminderForFinish": null,
  46.         "Start": "2013-01-01T08:00:00+02:00",
  47.         "Finish": "2013-01-01T12:00:00+02:00",
  48.         "AllDay": true,
  49.         "RecurrenceInfo": null,
  50.         "RecurrencePatternId": null,
  51.         "DeletedRecurrences": null,
  52.         "RecurrenceExceptions": null
  53.       }
  54.     },
  55.     {
  56.       "Id": "7c7870ab-015a-43ef-b574-cd8f1b3e7a22",
  57.       "InfoName": "TaskScheduleItems",
  58.       "ETag": "634921330912969733",
  59.       "ModifiedStamp": "2012-12-26T15:38:11.2969733+02:00",
  60.       "IsMarkedAsDeleted": false,
  61.       "Properties": {
  62.         "Id": "7c7870ab-015a-43ef-b574-cd8f1b3e7a22",
  63.         "Users": {
  64.           "Values": [
  65.             {
  66.               "Id": "ae18dea5-4f60-4f70-ae31-d8052984e31e",
  67.               "DisplayText": "admin"
  68.  
  69.             }
  70.           ],
  71.           "DisplayText": "admin"
  72.         },
  73.         "ReminderForStart": {
  74.           "Offset": {
  75.             "Value": 1.0,
  76.             "Kind": 1,
  77.             "PureWorkTime": 0.041666666666666664,
  78.             "Title": "1 Hours"
  79.           },
  80.           "Users": [
  81.             {
  82.               "Id": "ae18dea5-4f60-4f70-ae31-d8052984e31e",
  83.               "DisplayText": "admin"
  84.             }
  85.           ],
  86.           "HideUsers": false,
  87.           "OffsetKind": -1,
  88.           "Description": "'reminder before start' set via API"
  89.         },
  90.         "ReminderForFinish": null,
  91.         "Start": "2013-01-01T08:00:00+02:00",
  92.         "Finish": "2013-01-01T12:00:00+02:00",
  93.         "AllDay": true,
  94.         "RecurrenceInfo": null,
  95.         "RecurrencePatternId": null,
  96.         "DeletedRecurrences": null,
  97.         "RecurrenceExceptions": null
  98.       }
  99.     }
  100.   ]
  101. }