/api/reports/views/:id/table/bounds

This method returns bounds of the table.

Resource Information

Resource URL

https://service.belladati.com/api/reports/views/:id/table/bounds

HTTP Method

GET

Request Parameters

Parameters

Detail

Example
id

ID of the table. This ID is part of the /api/reports/:id response.

1234

filter

(Optional) Filter applied to the table, with following structure:

Name
Description
drilldown

Drilldown defined with attribute code and following structure:

Name
Description
opFilter operation type - please see list of supported values.
value/values(Optional) Depends on selected "op". Contains value or values for filter.
countOp

(Optional) Used with COUNT operation. Specifies the second operation used together with count.

Supported values: EQ, NEQ, GT, GTE, LT, LTE

{
   "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"
      }
   }
}

Response Structure

JSON response has following definition:

NameDescription

leftHeaderColumnsCount

Number of columns in left header

columnsCount

Number of columns in data part of table

topHeaderRowsCount

Number of rows in top header

rowsCount

Number of rows in data part of table

cleverTitle

View title with description of applied filter.

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/bounds

The JSON format response:

{
  "leftHeaderColumnsCount" : 2,
  "columnsCount" : 3,
  "topHeaderRowsCount" : 1,
  "rowsCount" : 5,
  "cleverTitle" : "<div class=\"cleverTitle\"><\/div>"
}

 

Next steps

 

  • No labels