Request address

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

Request message

Request parameter

required parameter:xmlData (required)

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

<info>

<ref>

 <path>API_test</path>

 <type>db</type>

</ref>

<querys>

 <query>

  <oldRef>

   <type>sql</type>

 <path>dataset_test</path>

  </oldRef>

  <newRef>

 <type>sql</type>

 <path>dataset_test_user</path>

  </newRef>

 </query>

</querys>

</info>

parametric description

1) ref-path (required): the path of the report that needs to be replaced.

2) ref-type (required): the type of report that needs to be replaced: db.

3) querys-query-oldRef-type (required): the type of data set that needs to be replaced.

4) querys-query-oldRef-path (required): the path of the data set that needs to be replaced.

5) querys-query-newRef-type (required): the type of data set that needs to be replaced.

6) querys-query-newRef-path (required): the path of the data set that needs to be replaced.

Description:

1) There can be multiple queries to support the replacement of data sets corresponding to all components under the report.

Sample

function replaceDbQuery() {

        var xml = getXml();

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

           {xmlData : xml},

           function(result) {        

              writeXml(result);

           });

Response message

Response result

1) Successful operation

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

 <results>

  <result>

   <level>1</level>

   <message>Operates successfully.</message>

  </result>

</results>>

2) Operation failed

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

<results>

 <result>

  <level>6</level>

  <message>\Yonghong\bihome\dashboard\tes1t.db (The system cannot find the specified file.)</message>

 </result>

</results>

or

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

<results>

 <result>

  <level>6</level>

  <message>Data set "test" does not exist in the report. </message>

 </result>

</results>

Result description

The response result information is xml. direct parse.

1) Level return type, different values represent different return status, see appendix.

2) Message is the interface operation result information.