Home

Returns the list of all records of the given dimension table

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

Request:

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
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/analytics/dimensions/Dim_Project
  2. Accept: text/json
  3. Accept-Encoding: deflate
  4. Host: localhost:6496
  5. Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45
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 16:15:42 GMT
  6. Set-Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45; path=/;
  7. Server: Microsoft-HTTPAPI/2.0
  8.  
  9. {
  10.   "IsTooManyItems": false,
  11.   "Items": [
  12.     {
  13.       "Id": "11111111-1111-1111-1111-111111111111",
  14.       "InfoName": "Dim_Project",
  15.       "ModifiedStamp": "2012-12-18T16:54:18.5591966+02:00",
  16.       "Properties": {
  17.         "Code": null,
  18.         "EntityCreator": {
  19.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Users/11111111-1111-1111-1111-111111111111",
  20.           "Title": ""
  21.         },
  22.         "EntityCreatedTime": {
  23.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/11111111-1111-1111-1111-111111111111",
  24.           "Title": ""
  25.         },
  26.         "EntityModifiedTime": {
  27.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/11111111-1111-1111-1111-111111111111",
  28.           "Title": ""
  29.         },
  30.         "Name": null,
  31.         "Folder": {
  32.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Folders/11111111-1111-1111-1111-111111111111",
  33.           "Title": ""
  34.         },
  35.         "Key": null,
  36.         "Title": "",
  37.         "Id": "11111111-1111-1111-1111-111111111111",
  38.         "ModifiedStamp": "2012-12-18T16:54:18.5591966+02:00"
  39.       }
  40.     },
  41.     {
  42.       "Id": "e9ae7e7e-c935-4e7c-9d82-4ab829c3f6b9",
  43.       "InfoName": "Dim_Project",
  44.       "ModifiedStamp": "2012-12-21T18:12:42.0857118+02:00",
  45.       "Properties": {
  46.         "Code": "PRJ23",
  47.         "EntityCreator": {
  48.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Users/ae18dea5-4f60-4f70-ae31-d8052984e31e",
  49.           "Title": ""
  50.         },
  51.         "EntityCreatedTime": {
  52.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/00000000-0000-0063-4917-031200000000",
  53.           "Title": ""
  54.         },
  55.         "EntityModifiedTime": {
  56.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/00000000-0000-0063-4917-031200000000",
  57.           "Title": ""
  58.         },
  59.         "Name": "New Project 1",
  60.         "Folder": {
  61.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Folders/11111111-1111-1111-1111-111111111111",
  62.           "Title": ""
  63.         },
  64.         "Key": "e9ae7e7e-c935-4e7c-9d82-4ab829c3f6b9",
  65.         "Title": "(PRJ23) New Project 1",
  66.         "Id": "e9ae7e7e-c935-4e7c-9d82-4ab829c3f6b9",
  67.         "ModifiedStamp": "2012-12-21T18:12:42.0857118+02:00"
  68.       }
  69.     },
  70.     {
  71.       "Id": "18a6b2ab-cc8b-4e38-b3f6-0641449919f6",
  72.       "InfoName": "Dim_Project",
  73.       "ModifiedStamp": "2012-12-21T18:12:47.0927118+02:00",
  74.       "Properties": {
  75.         "Code": "PRJ24",
  76.         "EntityCreator": {
  77.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Users/ae18dea5-4f60-4f70-ae31-d8052984e31e",
  78.           "Title": ""
  79.         },
  80.         "EntityCreatedTime": {
  81.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/00000000-0000-0063-4917-031200000000",
  82.           "Title": ""
  83.         },
  84.         "EntityModifiedTime": {
  85.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_TimeKey/00000000-0000-0063-4917-031200000000",
  86.           "Title": ""
  87.         },
  88.         "Name": "New Project 2",
  89.         "Folder": {
  90.           "Url": "api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/tables/Dim_Folders/11111111-1111-1111-1111-111111111111",
  91.           "Title": ""
  92.         },
  93.         "Key": "18a6b2ab-cc8b-4e38-b3f6-0641449919f6",
  94.         "Title": "(PRJ24) New Project 2",
  95.         "Id": "18a6b2ab-cc8b-4e38-b3f6-0641449919f6",
  96.         "ModifiedStamp": "2012-12-21T18:12:47.0927118+02:00"
  97.       }
  98.     }
  99.   ]
  100. }