Returns the list of all entities with selected fields

GET
api/databases/{dbid}/entities/{entity}/query
This request is used for getting the entity list that includes values of selected fields only. Also this request can contain expressions.
For example, you can get the list of tasks, including their names and names of folders they relate to: ?fields=name;folder:folder.name

Request:

Argument Type Description
dbid GUID  The ID of the database
entity String  The name of the entity
Query parameter Required Default Options Description
fields     Returns selected fields
filter       Sets filter
keeptreestructure   1/0  Returns complete tree structure
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/query?fields=id;name;project:project.entityitemtitle
  2. Accept: text/json
  3. Accept-Encoding: deflate
  4. Host: localhost:6496
  5. Cookie: sid=9a5c18b8-a39e-4361-9c48-b3d4d98e4815
Response:
  1. Transfer-Encoding: chunked
  2. Content-Encoding:
  3. Cache-Control: no-store
  4. Content-Type: text/json; charset=utf-8
  5. Date: Fri, 21 Dec 2012 09:28:57 GMT
  6. Set-Cookie: sid=9a5c18b8-a39e-4361-9c48-b3d4d98e4815; path=/;
  7. Server: Microsoft-HTTPAPI/2.0
  8.  
  9. {
  10. "IsTooManyItems": false,
  11. "Items": [
  12. {
  13. "id": "d33dbe30-9e14-4b7c-ab52-805b87bdc789",
  14. "name": "New Task name",
  15. "project": null
  16. },
  17. {
  18. "id": "c683c4de-1a4a-4a29-a40c-19e9a263d3c5",
  19. "name": "New Task name 1",
  20. "project": null
  21. },
  22. {
  23. "id": "e90bbd21-3c97-4da1-9ca0-e49cc86b2a9b",
  24. "name": "New Task 58",
  25. "project": null
  26. },
  27. {
  28. "id": "13be971f-e65f-464a-9f70-9eb47e42b6fd",
  29. "name": "Celebrate the end of the world",
  30. "project": null
  31. }
  32. ]
  33. }