Request address

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

Request message

Request parameter

required parameter:xmlData (required)

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

<info>      

<user></user>  

<getdata>      

<dbpath>table</dbpath>    

</getdata> </info>

parametric description

Parameter is node information :

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

2) dbpath(required)：dashboard path

Sample

function getDbLineage() {

        var xml = getXml();

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

           {xmlData : xml},

           function(result) {

           writeXml(result);

        });

     }

Response message

Response result

1) Successful operation

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

<info>

   <grid>

       <row>

           <col>{"name":"table","attrValue":"table","attrName":"Dashboard Path"}</col>

           <col>{"name":"Table1","attrValue":"Table1","attrName":"Table Name"}</col>

           <col>{"name":"coffee","attrValue":"coffee","attrName":"SQL Data Set Path"}</col>

           <col>{"name":"anna","attrValue":"anna","attrName":"Database Name"}</col>

           <col>{"name":"coffee","attrValue":"anna/coffee","attrName":"Database TablePath"}</col>

           <col>{"name":"mysql","attrValue":"Connection/mysql","attrName":"Connection MySQL Path"}</col>

       </row>

   </grid>

</info>

2）Operation failure

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

<results>

   <result>

       <level>6</level>

       <message>User 'user1' is not found.</message>

   </result>

</results>

Result description

The response result information is xml, direct parse.

Level return type, different values represent different return status, 1 indicates success, 6 indicates failure.