Versions Compared

Old Version 4

changes.mady.by.user Lubomir Micko

Saved on

compared with

New Version 5

changes.mady.by.user Lubomir Elko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Parameters

Detail

id

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

filter

Filter applied to the table.
Example:

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

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/1234/table/json

The JSON format response: 

Code Block
{ 
  "rowsCount" : 5, 
  "name" : "My Table Name", 
  "bodyheader" : [ 
    [ 
      { 
        "value" : "Value", 
        "type" : "header" 
      }, 
    ], 
   { [ 
      { 
 "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); "value" : "", 
        "valuetype" : "1,033,054,533,155header" 
      } 
    ] 
  ], 
  "body" : [ 
    [ 
      { 
        "value" : "Value Footnotes", 
        "type" : "header" 
      }, 
      { 
        "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", 
        "value" : "1,033,054,533,155" 
      } 
    ], 
    [ 
      { 
        "value" : "BValue Footnotes", 
        "type" : "header" 
      }, 
      { 
        "style" : " color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", 
        "value" : "51" 
      } 
    ] 
  ], 
  "name" : "Table", 
  "header" : [ 
    [ 
      { 
        "value" : "B", 
        "type" : "header" 
      }, 
    ], 
 { 
  [ 
     "style" {: 
        "value" : """ color:rgb(77, 77, 77) !important ; background-color:rgb(237, 237, 237); ", 
        "typevalue" : "header5" 
      } 
    ] 
  ] 
}

Next steps

List siblings