/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

post

generate downstream Graph

Query parameters

dbvendorstringoptional

dbvendor

distanceinteger · int32optional

distance

hideColumnboolean · default: falseoptional

hideColumn

ignoreFunctionboolean · default: falseoptional

ignoreFunction

ignoreRecordSetboolean · default: falseoptional

ignoreRecordSet

isReturnModelboolean · default: trueoptional

isReturnModel

jobIdstringoptional

jobId

normalizeIdentifierboolean · default: trueoptional

normalizeIdentifier

sessionIdstringoptional

sessionId

showConstantTableboolean · default: falseoptional

showConstantTable

showLinkOnlyboolean · default: trueoptional

showLinkOnly

showRelationTypestring · default: "fdd"optional

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 · default: falseoptional

showTransform

simpleOutputboolean · default: falseoptional

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

tableColumnstringoptional

target table column

tableNamePatternstring · default: ".*"optional

target table name, supports regex expression

tokenstringrequired

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

treatArgumentsInCountFunctionAsDirectDataflowboolean · default: falseoptional

Whether treat the arguments in COUNT function as direct Dataflow

userIdstringoptional

userId

Responses

application/json;charset=utf-8

cURL

JavaScript

Python

HTTP

curl -L \
  --request POST \
  --url 'https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/downstreamGraph?token=text'

200

201

401

403

404

text

Get downstream data lineage image

/sqlflow/generation/sqlflow/downstreamGraph/image

generate downstream Graph image