/sqlflow/upstreamGraph

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

Get upstream data lineage in Json

/sqlflow/generation/sqlflow/upstreamGraph

generate upstream Graph

generate upstream Graph

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

Query parameters

Response

200201401403404

OK

Body

application/json;charset=utf-8

string

Request

JavaScriptCurlPython

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

Response

200

text

Get upstream data lineage image

/sqlflow/generation/sqlflow/upstreamGraph/image

generate upstream Graph image

generate upstream Graph image

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

Authorization

Authorization

Query parameters

Response

200201401403404

OK

Body

image/pngimage/jpegimage/gif

string (byte)

Request

JavaScriptCurlPython

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

Response

200

Ynl0ZXM=

Sample:

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