/exportLineageAsJson

Export the same graph data lineage in json format

export sqlflow lineage as json format

post

export sqlflow lineage as json format

Query parameters

columnstringOptional

column to export

databasestringOptional

source database

schemastringOptional

schema

tablestringOptional

table

ignoreFunctionbooleanOptional

whether ignore function

Default: falseExample: false

ignoreRecordSetbooleanOptional

whether ignore record set

Default: falseExample: false

jobIdstringOptional

job to export. will return user's latest job if empty

showConstantTablebooleanOptional

whether show constant table

Default: false

showLinkOnlybooleanOptional

whether show link only

Default: true

showRelationTypestringOptional

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

Default: fdd

showTransformbooleanOptional

whether show Transform

Default: false

simpleOutputbooleanOptional

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

Default: falseExample: false

tableToTablebooleanOptional

whether show table to table relation only

Default: falseExample: false

tokenstringRequired

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

treatArgumentsInCountFunctionAsDirectDataflowbooleanOptional

Whether treat the arguments in COUNT function as direct Dataflow

Default: false

userIdstringRequired

the user id of sqlflow web or client

Responses

200

OK

application/json

201

Created

401

Unauthorized

403

Forbidden

404

Not Found

post

HTTPcURLJavaScriptPython

POST /api/gspLive_backend/sqlflow/job/exportLineageAsJson HTTP/1.1
Host: api.gudusoft.com
Accept: */*

{
  "jsonResonse": "binary"
}