/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

post

/sqlflow/generation/sqlflow/leftMostSourceTableGraph

Query parameters

columnLevelstring

columnLevel

dbvendorstringrequired

dbvendor

hideColumnboolean

hideColumn

ignoreFunctionboolean

ignoreFunction

ignoreRecordSetboolean

ignoreRecordSet

isReturnModelboolean · default: true

isReturnModel

jobIdstring

jobId

normalizeIdentifierboolean · default: true

normalizeIdentifier

sessionIdstringrequired

sessionId

showConstantTableboolean

showConstantTable

showLinkOnlyboolean · default: true

showLinkOnly

showRelationTypestring · default: fdd

show relation type, required false, default value is 'fdd', multiple values seperated by comma like fdd,frd,fdr,join. Availables are 'fdd' value of target column from source column, 'frd' the recordset count of target column which is affected by value of source column, 'fdr' value of target column which is affected by the recordset count of source column, 'join' combines rows from two or more tables, based on a related column between them

showTransformboolean

showTransform

simpleOutputboolean

simple output, ignore the intermediate results, defualt is false.

tableColumnstring

target table column

tableNamePatternstring · default: .*

tableNatarget table name, supports regex expressionmePattern

tokenstringrequired

The token is generated from userid and usersecret. It is used in every Api invocation.

treatArgumentsInCountFunctionAsDirectDataflowboolean

Whether treat the arguments in COUNT function as direct Dataflow

userIdstringrequired

userId

Responses

application/json;charset=utf-8

cURL

JavaScript

Python

HTTP

cURL

curl -L \
  --request POST \
  --url 'https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/leftMostSourceTableGraph?dbvendor=text&sessionId=text&token=text&userId=text'

200

201

401

403

404

200

text

OK

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

post

/sqlflow/generation/sqlflow/leftMostSourceTableGraph/image

Authorizations

Query parameters

columnLevelstring

columnLevel

dbvendorstringrequired

dbvendor

hideColumnboolean

hideColumn

ignoreFunctionboolean

ignoreFunction

ignoreRecordSetboolean

ignoreRecordSet

isReturnModelboolean · default: true

isReturnModel

jobIdstring

jobId

normalizeIdentifierboolean · default: true

normalizeIdentifier

sessionIdstringrequired

sessionId

shareboolean

whether generate the sharable URL for the result

showConstantTableboolean

showConstantTable

showLinkOnlyboolean · default: true

showLinkOnly

showRelationTypestring · default: fdd

showRelationType

showTransformboolean

showTransform

simpleOutputboolean

simpleOutput

tableColumnstring

target table column

tableNamePatternstring · default: .*

target table name, supports regex expression

tokenstringrequired

token

treatArgumentsInCountFunctionAsDirectDataflowboolean

treatArgumentsInCountFunctionAsDirectDataflow

userIdstringrequired

userId

Responses

image/pngimage/jpegimage/gif

cURL

JavaScript

Python

HTTP

cURL

curl -L \
  --request POST \
  --url 'https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/leftMostSourceTableGraph/image?dbvendor=text&sessionId=text&token=text&userId=text' \
  --header 'Authorization: YOUR_API_KEY'

200

201

401

403

404

200

image/png

image/jpeg

image/gif

image/png

text

OK

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"'