|
Code Block |
---|
{
"drilldown": {
"L_COUNTRY_OR_AREA": {
"op": "EQ",
"value": "Slovakia"
},
"L_TYPE": {
"op": "IN",
"values": [ "Type 1", "Type 2", "Type 3" ]
},
"L_DATE": {
"op": "NOT_NULL"
},
"L_PRODUCT":{
"op":"COUNT",
"countOp":"LTE",
"value":"816"
}
}
}
Example of a between filter:
{"drilldown":[{"L_ID":{"op":"GT","value":"10"}},{"L_ID":{"op":"LT","value":"20"}}]} |
| combineFilters | If any static filter is present, filter set in this request will combine with static filter set in view | true | drilldownConfig | (Optional) 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: Name | Description |
---|
vertical | Definition of header that should be set (vertical header) | horizontal | Definition of header that should be set (horizontal header) | dataSetDrilldownAttribute | Code of the attribute (e.g. L_CITY) | dataSetDrilldownAttributeSubset | (Optional) ID of the used subset | hideDataSetCustomMembers | Defines whether custom members will be displayed | limit | Sets limit for members displayed in the selected drill-down. Set this value to "ALL" if all available members should be loaded. |
|
Code Block |
---|
{
"horizontal":[
{
"dataSetDrilldownAttribute":"L_PRODUCT_TYPE",
"hideDataSetCustomMembers": false,
"limit": "ALL"
},
{
"dataSetDrilldownAttribute":"L_PRODUCT",
"dataSetDrilldownAttributeSubset": "TdPgywXkmB",
"hideDataSetCustomMembers": true,
"limit": 1000
}
],
"vertical":[
{
"dataSetDrilldownAttribute":"L_DATE",
"dataSetDrilldownAttributeSubset":"0EE39yrVHY",
"hideDataSetCustomMembers": false
}
]
} |
| 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. |
Code Block |
---|
subsetValueId=F2Qx2LrYRX |
| expand | Will expand all available drill-downs. Available values: true / false | |
Response Structure Code Block |
---|
{
"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 |
Sample request/responseUsing curl : Code Block |
---|
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: Code Block |
---|
{
"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"
}
]
]
} |
Next steps |