Request address

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

Request message

Request parameter

required parameter:xmlData (required)

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

<info>

   <user>admin</user>

   <path>test</path>

   <type>sql</type>

   <maxRows>0</maxRows>

   <params>

       <param name="Short" type="int">1</param>

   </params>

</info>

parametric description

Parameter is node information：

1)user(optional)：The user who wants to query.

2)path(required)：Path to the dataset.

3)type(required)：The type of data set. See appendix.（Note: multi-dimensional data set  does not support preview and materialized data set）

4)maxRows(optional)：Set the size of the amount of data that can be retrieved. When maxRows is equal to 0, the maximum number of data sets obtained is the qry.preview.rows value set by the system. When greater than 0, the set value is used, and all data is taken out when it is less than 0.

5)params(optional) There are some parameters that can be passed inside to control the data set. Type is a type of parameter, which is mainly the following: string 、boolean 、float 、double、char、byte、short、int、long、time、time、dateTime。

Sample

function getQueryData() {

         var xml = getXml();

         $.post("http://" + ip + ":" + port + "/" + project

                 + "/api?action=getQueryData&token=xxxx", {

                 xmlData : xml

         }, function(result) {

                 writeXml(result)

         });

 }

Response message

Response result

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

<info>

   <page>

       <rowCount>1</rowCount>

       <pageCount>1</pageCount>

       <pageSize>1</pageSize>

       <pageNow>1</pageNow>

   </page>

   <grid>

       <row>

           <header type="int">&lt;rrr&gt;</header>

           <header type="boolean">Boolean</header>

           <header type="short">Byte</header>

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

           <header type="date">Date</header>

           <header type="dateTime">DateTime</header>

           <header type="double">Double</header>

           <header type="double">Float</header>

           <header type="long">Long</header>

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

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

           <header type="time">time</header>

       </row>

       <row>

           <col>1</col>

           <col>false</col>

           <col>0</col>

           <col>字</col>

           <col>2016-05-12</col>

           <col>2016-05-12 00:00:00.0</col>

           <col>0.111112</col>

           <col>0.0</col>

           <col>2147483647</col>

           <col>1</col>

           <col>string</col>

           <col>00:00:00</col>

       </row>

   </grid>

</info>

Result description

Returns the correct form; an error prompt string is returned when the permission validates that the non-administrator account views other account data.