<< Click to Display Table of Contents >> Gets the SQL statement for a SQL dataset |
![]() ![]() ![]() |
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. |