Gets the SQL statement for a SQL dataset

<< Click to Display Table of Contents >>

Current:  System Integration > WebAPI 

Gets the SQL statement for a SQL dataset

Previous pageReturn to chapter overviewNext page

Request address

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

Request message

Request parameter

required parameter:xmlData (required)

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

<info>

  <queryPath>coffee</queryPath>

</info>

parametric description

queryPath(required):The path to the sql dataset.

Sample

function getQueryInfo() {

         var xml = getXml();

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

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

                 xmlData : xml

         }, function(result) {

                 writeXml(result)

         });

 }

Response message

Response result

 

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

<results>

   <result>

       <level>1</level>

       <message>select * from COFFEE_CHAIN  </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.