/api/bigDataSets/tables/:id
This endpoint is used for getting the table defined in the GUI. In case the drillDownConfig is not set, the columns defined via GUI are returned. In case the drillDownConfig parameter is set, the columns defined in the request are returned.
Resource Information
Resource URL | https://service.belladati.com/api/bigDataSets/tables/:id |
---|---|
HTTP Method |
|
Request Parameters
| ID of the table to fetch. You can find the ID in the response to /api/bigDataSets/:id/tables | 123 | ||||||||||||
| (Optional) (body) Replaces the table drill-down with custom configuration. When ROW_UID is set, indicators aggregation is turned off If you put any indicator in drilldownConfig, it will overwrite indicators set in table. If no indicator is set in drilldown, an indicator from table will be used. | [ { "dataSetDrilldownAttribute":"ROW_UID" }, { "dataSetDrilldownAttribute":"L_CONTINENT" }, { "dataSetDrilldownAttribute":"L_CITY" }, { "dataSetDrilldownAttribute":"M_VALUE", "aggregator":"Sum" } ] | ||||||||||||
filter | (Optional) (body) 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) Specifies the number of entries on each page if pagination is necessary. | 15 | ||||||||||||
offset | (Optional) Specifies the page offset if pagination is necessary. | 5 | ||||||||||||
worker | (Optional) Specifies number of workers, that will load data in parallel | 1 |
Sample Request / Response
Using curl
:
|
The JSON format response:
|