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

GET

api/databases/{dbid}/analytics/dimensions/{dimension}/query

This request is used for getting the given dimension table records list that includes values of selected fields only. Also this request can contain expressions which will calculate the values of selected fields according to the formulas.

Request:

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

Query parameter	Required	Options	Description
fields	1		Returns selected fields
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/analytics/dimensions/Dim_Project/query?fields=id;code;name;title
Accept: text/json
Accept-Encoding: deflate,deflate
Authorization: Basic YWRtaW46YWRtaW4=
Host: localhost:6496

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Wed, 26 Dec 2012 14:46:35 GMT
Set-Cookie: sid=10e0e5f6-1b0d-43f9-86d7-ff096f77009e; path=/;
Server: Microsoft-HTTPAPI/2.0
 
{
  "IsTooManyItems": false,
  "Items": [
    {
      "id": "11111111-1111-1111-1111-111111111111",
      "code": null,
      "name": null,
      "title": ""
    }
  ]
}