This method returns table in JSON format.
Resource URL | https://service.belladati.com/api/reports/views/:id/table/json |
HTTP Method |
|
Parameters | Detail | Example | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID of the table. This ID is part of the | 123 | |||||||||||||||
drilldownConfig | (Optional - RAW) Replaces the table drill-down with custom configuration. Both horizontal and vertical drill-down configurations can be replaced. Each configuration is an array with the following elements:
|
| |||||||||||||||
subsetValueId | If defined, response will return value for selected member of the subset. In case, this parameter is combined with expand = true, all child of the selected member will be loaded. |
| |||||||||||||||
expand | Will expand all available drill-downs. Available values: true / false |
| |||||||||||||||
filter | (Optional - RAW) Filter applied to the table, with following structure:
|
|
{ "drilldownConfig": { "vertical": [ { "dataSetDrilldownAttribute": "L_THELONGESTTITLETHERECAN01", "limit": "ALL", "hideDataSetCustomMembers": false }, { "dataSetDrilldownAttribute": "L_THELONGESTTITLETHERECAN30", "limit": "ALL", "hideDataSetCustomMembers": false } ] }, "filter": { "drilldown": { "L_THELONGESTTITLETHERECAN30": { "op": "EQ", "value": "10" } } } } |
{ "rowsCount" : ..., "name" : ..., "header" : [ ], "body" : [ ] } |
JSON response contains elements with following definition:
Name | Description |
---|---|
rowsCount | Total number of rows including headers and data |
name | Table view name |
header | Array containing header elements |
body | Array containing data elements |
Using curl
:
curl -H "Authorization: OAuth realm=\"https://service.belladati.com/\", oauth_consumer_key=\"myConsumer\", oauth_token=\"mh7an9dkrg59\", oauth_timestamp=\"135131231\", oauth_nonce=\"randomString\"" https://service.belladati.com/api/reports/views/1234/table/json |
The JSON format response:
{ "rowsCount" : 5, "name" : "My Table Name", "header" : [ [ { "value" : "", "type" : "header" } ], [ { "value" : "", "type" : "header" } ] ], "body" : [ [ { "value" : "Value", "type" : "header" }, { "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", "value" : "1,033,054,533,155" } ], [ { "value" : "Value Footnotes", "type" : "header" }, { "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", "value" : "1" } ], [ { "value" : "B", "type" : "header" }, { "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", "value" : "5" } ] ] } |