/api/reports/views/:id/table/data
This method returns table data in HTML format.
Resource Information
Resource URL | https://service.belladati.com/api/reports/views/:id/table/data |
HTTP Method |
|
Request Parameters
Parameters | Detail | Example | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID of the table. This ID is part of the | 123 | ||||||||||||
| (Optional) Filter applied to the table, with following structure:
| { "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"}}]} | ||||||||||||
| (Optional) Rows from. | 0 | ||||||||||||
| (Optional) Rows to. | 10 | ||||||||||||
| (Optional) Columns from. | 0 | ||||||||||||
| (Optional) Columns to. | 20 | ||||||||||||
drilldownConfig | (Optional) Replaces the table drill-down with custom configuration. Both horizontal and vertical drill-down configuration can be replaced. Each configuration is an array with the following elements:
If only one drilldown is specified (horizontal/vertical) the other one is left as currently in configuration for the request. | { "horizontal":[ { "dataSetDrilldownAttribute":"L_PRODUCT_TYPE" }, { "dataSetDrilldownAttribute":"L_PRODUCT" } ], "vertical":[ { "dataSetDrilldownAttribute":"L_DATE", "dataSetDrilldownAttributeSubset":"0EE39yrVHY" } ] } |
Sample request/response
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/data
The JSON format response:
{ "content" : "<tr><td data-column=\"0\" data-row=\"0\" style=\" color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); \">1,033,054,533,155<\/td><\/tr>" }