/sqlflow/leftMostSourceTableGraph

This API returns the left most result for the data element. Corresponds to this feature in SQLFlow UI.

Get the left-most lineage in Json

/sqlflow/generation/sqlflow/leftMostSourceTableGraph

generate left-most source table graph

generate left-most source table graph

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

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/leftMostSourceTableGraph?dbvendor=text&sessionId=text&token=text&userId=text', {
    method: 'POST',
    headers: {},
});
const data = await response.json();

Response

200

text

Sample:

curl --location 'https://<SQLFLOW URL>/gspLive_backend/sqlflow/generation/sqlflow/leftMostSourceTableGraph' \
--header 'accept: application/json' \
--form 'userId="gudu|0123456789"' \
--form 'sessionId="85b5119f83fcfefa93136e79dc05f2f61efe3b75e6a2b733568e0879c24f0c08_1680615728918"' \
--form 'dbvendor="dbvmssql"' \
--form 'jobId="6def00e8796e4c20ba216826c0ab5b73"' \
--form 'tableNamePattern="msdb.@event_data.nodes"'

Retrieve the left-most lineage image

/sqlflow/generation/sqlflow/leftMostSourceTableGraph/image

generate left-most source table graph image

generate left-most source table graph image

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/leftMostSourceTableGraph/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/leftMostSourceTableGraph/image?dbvendor=text&sessionId=text&token=text&userId=text', {
    method: 'POST',
    headers: {},
});
const data = await response.json();

Response

200

Ynl0ZXM=

Sample:

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