Versions Compared

Old Version 20

changes.mady.by.user Ondrej Špalek

Saved on

compared with

New Version 21

changes.mady.by.user Ondrej Špalek

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

/api/reports/views/:id/chart

Returns chart metadata for rendering.

Tip

Charts can be rendered using BellaDati Charts SDK.

Resource Information

Resource URL

https://service.belladati.com/api/reports/views/:id/chart

HTTP Method

GET

Request Parameters

Parameters

Detail

Example

id

ID of the view. You can find the ID in the response to /api/reports/:id.

123

filter

(Optional) Filter used in the chart 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

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

dateTimeDefinition

(Optional) Date and time definition used in the chart with following structure:

NameDescription
dateInterval

(Optional) Date interval to filter values. Has following structure:

Name
Description
aggregationTypeDate interval period - please see list of supported values.
interval

Interval definition with following structure:

Name
Description
typeInterval type - please see list of supported values.
fromInterval start value - please see Setting Date Interval
toInterval end value - please see Setting Date Interval
timeInterval

(Optional) Time interval to filter values. Has following structure:

Name
Description
aggregationTypeTime interval period - please see list of supported values.
interval

Interval definition with following structure:

Name
Description
typeInterval type - please see list of supported values.
fromInterval start value - please see Setting Date Interval
toInterval end value - please see Setting Date Interval
Code Block
{
   "dateInterval": {
      "interval": {
          "from": "actualYear-1y",
          "to": "actualYear-1d",
          "type": "custom"
      },
      "aggregationType": "DAY"
   },
   "timeInterval": {
      "interval": {
          "from": {"hour":"14","minute":"15","second":"16"},
          "to": {"hour":"20","minute":"0","second":"0"},
          "type": "absolute"
      },
      "aggregationType": "SECOND"
   }
}

Response Structure

JSON response has following definition:

NameDescription
contentJSON charts data - please see Charts SDK for more details.
cleverTitleView title with description of applied filter and datetime definition.

Sample Request / Response

Using 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/88738/chart

The JSON format response:

Code Block
javascript
javascript
{
  "content": {
    "chartId": "chart_88738",
    "bg_colour": "#e5e5e5",
    "is_decimal_separator_comma": 1,
    "elements": [
    ],
    "is_thousand_separator_disabled": 1,
    "options": {
    },
    "tooltip": {
      "colour": "#202020",
      "stroke": 1,
      "mouse": "2",
      "shadow": true,
      "background": "#ffffff"
    }
  },
  "cleverTitle": "<div class=\"cleverTitle\"><\/div>"
}

Sample request with filter, using 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/88738/chart?filter={"drilldown":{"L_STATE":{"op": "IN","values":["Arizona"]}}}

...