/sqlflow/selectedgraph/image

Get selected dbobject in Json

/sqlflow/generation/sqlflow/selectedgraph

generate selected dbobject graph

generate selected dbobject graph

post

/sqlflow/generation/sqlflow/selectedgraph

Query parameters

columnstring

column

columnLevelstring

columnLevel

databasestring

database

dbvendorstring · enum · default: dbvoraclerequired

db vendor

Options: dbvazuresql, dbvbigquery, dbvcouchbase, dbvdb2, dbvgreenplum, dbvhana, dbvhive, dbvimpala, dbvinformix, dbvmdx, dbvmysql, dbvnetezza, dbvopenedge, dbvoracle, dbvpostgresql, dbvredshift, dbvsnowflake, dbvmssql, dbvsparksql, dbvsybase, dbvteradata, dbvvertica

hideColumnboolean

hide column

Example: false

ignoreFunctionboolean

ignore function

Example: false

ignoreRecordSetboolean

ignore record set

Example: false

isReturnModelboolean · default: true

whether to return model

jobIdstring

jobId

normalizeIdentifierboolean · default: true

normalizeIdentifier

schemastring

schema

sessionIdstring

sessionId

showConstantTableboolean

showConstantTable

showLinkOnlyboolean · default: true

show link only

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.

Example: false

tablestring

table

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

user id

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/selectedgraph?dbvendor=dbvoracle&token=text&userId=text'

200

201

401

403

404

200

text

OK

Get selected dbobject image

Retrieve the data lineage image file for the selected dbobject graph

/sqlflow/generation/sqlflow/selectedgraph/image

generate selected dbobject graph image

generate selected dbobject graph image

post

/sqlflow/generation/sqlflow/selectedgraph/image

Query parameters

columnstring

column

columnLevelstring

columnLevel

databasestring

database

dbvendorstring · enum · default: dbvoraclerequired

db vendor

Options: dbvazuresql, dbvbigquery, dbvcouchbase, dbvdb2, dbvgreenplum, dbvhana, dbvhive, dbvimpala, dbvinformix, dbvmdx, dbvmysql, dbvnetezza, dbvopenedge, dbvoracle, dbvpostgresql, dbvredshift, dbvsnowflake, dbvmssql, dbvsparksql, dbvsybase, dbvteradata, dbvvertica

hideColumnboolean

hide column

Example: false

ignoreFunctionboolean

ignore function

Example: false

ignoreRecordSetboolean

ignore record set

Example: false

isReturnModelboolean · default: true

whether to return model

jobIdstring

jobId

normalizeIdentifierboolean · default: true

normalizeIdentifier

schemastring

schema

sessionIdstring

sessionId

showConstantTableboolean

showConstantTable

showLinkOnlyboolean · default: true

show link only

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.

Example: false

tablestring

table

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

user id

Responses

image/*

cURL

JavaScript

Python

HTTP

cURL

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

200

201

401

403

404

200

text

OK

Sample response: