/exportFullLineageAsJson
Export the full data lineage in json format
export full sqlflow lineage as json format
Query parameters
jobIdstringOptional
job to export. will return user's latest job if empty
tokenstringRequired
The token is generated from userid and usersecret. It is used in every Api invocation.
userIdstringRequired
userId
showRelationTypestringOptionalDefault:
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
fdd
Responses
200
OK
application/json;charset=utf-8
Responsestring
201
Created
401
Unauthorized
403
Forbidden
404
Not Found
post
POST /api/gspLive_backend/sqlflow/job/exportFullLineageAsJson HTTP/1.1
Host: api.gudusoft.com
Accept: */*
text
Sample Response is a file in Json format:
{
"jobId":"939fdbbaf52b45139b86c0761d6036b0",
"code":200,
"data":{
"mode":"global",
"summary":{
"schema":0,
"process":1,
"database":0,
"view":0,
"mostRelationTables":[],
"column":3,
"relationship":0,
"table":1
},
"sqlflow":{
"dbvendor":"dbvoracle",
"relationships":[],
"dbobjs":[
{
"queryHashId":"04ebc5aec1a07e1db80b0bc798742875",
"name":"QUERY INSERT-1",
"coordinates":[
{
"hashCode":"0",
"x":1,
"y":1
},
{
"hashCode":"0",
"x":1,
"y":73
}
],
"id":"8",
"type":"process"
},
{
"columns":[
{
"name":"ID",
"coordinates":[
{
"hashCode":"0",
"x":1,
"y":28
},
{
"hashCode":"0",
"x":1,
"y":30
}
],
"id":"5"
},
{
"name":"FIRST_NAME",
"coordinates":[
{
"hashCode":"0",
"x":1,
"y":32
},
{
"hashCode":"0",
"x":1,
"y":42
}
],
"id":"6"
},
{
"name":"LAST_NAME",
"coordinates":[
{
"hashCode":"0",
"x":1,
"y":44
},
{
"hashCode":"0",
"x":1,
"y":53
}
],
"id":"7"
}
],
"name":"RAW_CUSTOMERS",
"coordinates":[
{
"hashCode":"0",
"x":1,
"y":13
},
{
"hashCode":"0",
"x":1,
"y":26
}
],
"id":"4",
"type":"table"
}
]
},
"graph":{
"relationshipIdMap":{},
"elements":{
"tables":[],
"edges":[]
},
"tooltip":{},
"listIdMap":{}
}
},
"sessionId":"24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725"
}
Last updated