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	1			Returns selected fields
filter				Sets filter
keeptreestructure		0	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:

GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/entities/Task/query?fields=id;name;project:project.entityitemtitle
Accept: text/json
Accept-Encoding: deflate
Host: localhost:6496
Cookie: sid=9a5c18b8-a39e-4361-9c48-b3d4d98e4815

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Fri, 21 Dec 2012 09:28:57 GMT
Set-Cookie: sid=9a5c18b8-a39e-4361-9c48-b3d4d98e4815; path=/;
Server: Microsoft-HTTPAPI/2.0
 
{
  "IsTooManyItems": false,
  "Items": [
    {
      "id": "d33dbe30-9e14-4b7c-ab52-805b87bdc789",
      "name": "New Task name",
      "project": null
    },
    {
      "id": "c683c4de-1a4a-4a29-a40c-19e9a263d3c5",
      "name": "New Task name 1",
      "project": null
    },
    {
      "id": "e90bbd21-3c97-4da1-9ca0-e49cc86b2a9b",
      "name": "New Task 58",
      "project": null
    },
    {
      "id": "13be971f-e65f-464a-9f70-9eb47e42b6fd",
      "name": "Celebrate the end of the world",
      "project": null
    }
  ]
}