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

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.


Argument Type Description
dbid GUID  The ID of the database
dimension String  The name of the analytics dimension table
Query parameter Required Default Options Description
fields     Returns selected fields
filter       Sets filter
skip       Returns data starting from the given item
top     Max 200  Returns the given number of data items



Name Type Options Description
IsTooManyItems Boolean  Is too many result objects
Items Array of Object  Result object list

  1. GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/analytics/dimensions/Dim_Project/query?fields=id;code;name;title
  2. Accept: text/json
  3. Accept-Encoding: deflate,deflate
  4. Authorization: Basic YWRtaW46YWRtaW4=
  5. Host: localhost:6496
  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 14:46:35 GMT
  6. Set-Cookie: sid=10e0e5f6-1b0d-43f9-86d7-ff096f77009e; path=/;
  7. Server: Microsoft-HTTPAPI/2.0
  9. {
  10. "IsTooManyItems": false,
  11. "Items": [
  12. {
  13. "id": "11111111-1111-1111-1111-111111111111",
  14. "code": null,
  15. "name": null,
  16. "title": ""
  17. }
  18. ]
  19. }