Request address

http://ip:port/bi/api?action=getElemDatas&token=xxxx

Request message

Request parameter

required parameter ：xmlData(required)

<?xml version="1.0" encoding="utf-8"?>                        

<info >                        

 <user>admin</user>                        

 <dbpath>api/coffee</dbpath>                        

 <elements>                        

   <element>                        

     <name>chart1</name>                        

     <page>                        

       <pageSize>1</pageSize>                        

       <pageNow>1</pageNow>                        

     </page>                        

   </element>                                                

 </elements>                        

 <params>                        

   <param name="market">Central</param>                        

 </params>                        

</info>

parametric description

Parameter is node information：

1)user(optional)：The target user name you want to view.

2)dbpath(required)：The path of the dashboard

3)name(required)：Dashboard element name

4)pageSize(optional) and pageNow(optional) value needs to be greater than or equal to 1. pageSizeis how many bars per page are displayed，pageNow is the result of returning a few pages.

5)params(optional) Some parameters can be passed inside to control the query. type is the type of parameter，There are mainly the following：string 、boolean、float、double、char、byte、short、int、long、date、time 、dateTime。If the parameter has multiple values, Use comma "," can be separated.

6)The parameter format for the date type is as follows:

➢The format of date is "yyyy-MM-dd"

➢The format of datetime is "yyyy-MM-dd HH:mm:ss"

➢The format of time is "HH:mm:ss"

Sample

function getData() {

        var xml = getXml();

        $.post("http://" + ip + ":" + port + "/" + project + "/api?action=getElemDatas&token=xxxx",

           {xmlData : xml},

           function(result) {

           writeXml(result);

        });

     }

Response message

Response result

Successful operation

<info>

   <elem name="chart1">

       <page>

           <rowCount>1</rowCount>

           <pageCount>1</pageCount>

           <pageSize>5</pageSize>

           <pageNow>1</pageNow>

       </page>

       <type>Stacked Bar</type>

       <grid>

           <row>

               <header type="string">MARKET</header>

               <header type="int">Sum_ID</header>

           </row>

           <row>

               <col>Central</col>

               <col>2774016</col>

           </row>

       </grid>

   </elem>

</info>

Result description

1)The type label is the type of chart, as shown in the Appendix . You cannot use automatic type and organization charts, otherwise type has no value. If a chart contains multiple types, you get a comma-spliced string of multiple types.

2)The grid label returns the data table structure.Row as a row,Header column name,Col as a column. Corresponding values within the label. Non-administrator accounts cannot view other account data.

➢Note: crosstab only supports single row header crosstab.