/sqlflow/downstreamGraph

Retrieve the upstream data lineage for data elements in regular Job. This API corresponds to the downstream/upstream feature in SQLFlow UI.

Get downstream data lineage in Json

/sqlflow/generation/sqlflow/downstreamGraph

generate downstream Graph

generate downstream Graph

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph

Query parameters

Response

200201401403404

OK

Body

application/json;charset=utf-8

string

Request

JavaScriptCurl

const response = await fetch('https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph', {
    method: 'POST',
    headers: {},
});
const data = await response.json();

Response

"text"

Get downstream data lineage image

/sqlflow/generation/sqlflow/downstreamGraph/image

generate downstream Graph image

generate downstream Graph image

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph/image

Authorization

Authorization

Query parameters

Response

200201401403404

OK

Body

image/pngimage/jpegimage/gif

string (byte)

Request

JavaScriptCurl

const response = await fetch('https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph/image', {
    method: 'POST',
    headers: {},
});
const data = await response.json();

Response

"Ynl0ZXM="

Sample:

curl --location 'https://<SQLFlow URL>/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph/image' \
--header 'accept: image/*' \
--form 'userId="gudu|0123456789"' \
--form 'sessionId="85b5119f83fcfefa93136e79dc05f2f61efe3b75e6a2b733568e0879c24f0c08_1680615728918"' \
--form 'dbvendor="dbvmssql"' \
--form 'jobId="6def00e8796e4c20ba216826c0ab5b73"' \
--form 'tableNamePattern="dwdb.dbo.tbl_headblockersummary"'