/sqlflow/exportFullLineageAsCsv

Export full lineage as CSV

Export the full lineage as CSV, this api is for query mode

export sqlflow full lineage as csv format

export sqlflow full lineage as csv format

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

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/exportFullLineageAsCsv', {
    method: 'POST',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

"text"

Sample response:

A CSV file

source_db,source_schema,source_table,source_column,target_db,target_schema,target_table,target_column,relation_type,effect_type
DEFAULT,SCOTT,EMP,SAL,DEFAULT,DEFAULT,VSAL,Salary,fdd,create_view
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,SMALL_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,SMALL_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,SMALL_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,SMALL_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,SMALL_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,SMALL_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,MEDIUM_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,MEDIUM_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,MEDIUM_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,MEDIUM_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,LARGE_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,LARGE_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,LARGE_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,LARGE_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,LARGE_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,LARGE_ORDERS,CEM,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,OID,fdd,insert
DEFAULT,DEFAULT,ORDERS,CUSTOMER_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,CID,fdd,insert
DEFAULT,DEFAULT,ORDERS,ORDER_TOTAL,DEFAULT,DEFAULT,SPECIAL_ORDERS,OTTL,fdd,insert
DEFAULT,DEFAULT,ORDERS,SALES_REP_ID,DEFAULT,DEFAULT,SPECIAL_ORDERS,SID,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CREDIT_LIMIT,DEFAULT,DEFAULT,SPECIAL_ORDERS,CL,fdd,insert
DEFAULT,DEFAULT,CUSTOMERS,CUST_EMAIL,DEFAULT,DEFAULT,SPECIAL_ORDERS,CEM,fdd,insert
DEFAULT,SCOTT,EMP,DEPTNO,DEFAULT,DEFAULT,VSAL,Department,fdd,create_view

Try it out!