/sqlflow/erdiagramSelectGraph

Show the E-R Diagram based on the given source (sqltext/sessionId). Check here for more information about this feature in SQLFlow UI.

Retrieve E-R Diagram in Json

/sqlflow/generation/sqlflow/erdiagramSelectGraph

generate ER-Diagram Graph

generate ER-Diagram Graph

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph

Authorization

Authorization

Query parameters

Body

multipart/form-data

sqlfilestring (binary)

sqlfile

Response

200201401403404

OK

Body

application/json;charset=utf-8

string

Request

JavaScriptCurl

const response = await fetch('https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph', {
    method: 'POST',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

"text"

Sample:

curl --location 'https://<SQLFLOW URL>/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph' \
--header 'accept: application/json' \
--form 'userId="gudu|0123456789"' \
--form 'sessionId="85b5119f83fcfefa93136e79dc05f2f61efe3b75e6a2b733568e0879c24f0c08_1680615728918"' \
--form 'dbvendor="dbvmssql"' \
--form 'jobId="6def00e8796e4c20ba216826c0ab5b73"' \
--form 'databse="hr"' \
--form 'schema="dbo"'

Retrieve E-R Diagram image

/sqlflow/generation/sqlflow/erdiagramSelectGraph/image

generate ER-Diagram Graph image

generate ER-Diagram Graph image

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph/image

Authorization

Authorization

Query parameters

Body

multipart/form-data

sqlfilestring (binary)

sqlfile

Response

200201401403404

OK

Body

image/pngimage/jpegimage/gif

string (byte)

Request

JavaScriptCurl

const response = await fetch('https://api.gudusoft.com/api/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph/image', {
    method: 'POST',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

"Ynl0ZXM="

Sample:

curl --location 'https://<SQLFLOW URL>/gspLive_backend/sqlflow/generation/sqlflow/erdiagramSelectGraph/image' \
--header 'accept: image/*' \
--form 'userId="gudu|0123456789"' \
--form 'sessionId="85b5119f83fcfefa93136e79dc05f2f61efe3b75e6a2b733568e0879c24f0c08_1680615728918"' \
--form 'dbvendor="dbvmssql"' \
--form 'jobId="6def00e8796e4c20ba216826c0ab5b73"' \
--form 'databse="hr"' \
--form 'schema="dbo"'