/displayUserLatestJobTableLevelLineage

display user latest job table level lineage

display user latest job table level lineage

post

/sqlflow/job/displayUserLatestJobTableLevelLineage

Query parameters

ignoreSelfLineageboolean · default: true

whether ingore self lineage

tokenstringrequired

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

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/job/displayUserLatestJobTableLevelLineage?token=text&userId=text'

200

201

401

403

404

200

{
  "jobId": "939fdbbaf52b45139b86c0761d6036b0",
  "code": 200,
  "sessionId": "24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725",
  "job": {
    "ignoreFunction": true,
    "lastExecuteTime": "2022-10-04 10:45:05",
    "schedulable": false,
    "parallel": false,
    "ignoreRecordSet": true,
    "userEmail": "[e-mail]",
    "persist": false,
    "executeTimeMillis": 0,
    "jobName": "yuanhao1",
    "dataflowOfAggregateFunction": "direct",
    "showTransform": false,
    "sessionId": "24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725",
    "incremental": false,
    "showConstantTable": false,
    "userId": "auth0|6326be4047c1dfdd3bf553d0",
    "showRelationType": "fdd",
    "version": "5.2.0",
    "jobId": "939fdbbaf52b45139b86c0761d6036b0",
    "createTime": "2022-10-04 10:45:04",
    "onTop": false,
    "cancelSchedule": false,
    "dbVendor": "dbvoracle",
    "status": "success",
    "executeTime": "0min 1sec",
    "subJobs": [],
    "fileNames": [
      "test.sql"
    ]
  },
  "data": {
    "mode": "global",
    "summary": {
      "schema": 0,
      "process": 1,
      "database": 0,
      "view": 0,
      "column": 3,
      "relationship": 0,
      "table": 1,
      "mostRelationTables": []
    },
    "graph": {
      "relationshipIdMap": {},
      "tooltip": {},
      "listIdMap": {},
      "elements": {
        "tables": [],
        "edges": []
      }
    },
    "sqlflow": {
      "dbvendor": "dbvoracle",
      "relationships": [],
      "dbobjs": [
        {
          "queryHashId": "04ebc5aec1a07e1db80b0bc798742875",
          "name": "QUERY INSERT-1",
          "id": "8",
          "type": "process",
          "coordinates": [
            {
              "hashCode": "0",
              "x": 1,
              "y": 1
            },
            {
              "hashCode": "0",
              "x": 1,
              "y": 73
            }
          ]
        },
        {
          "name": "RAW_CUSTOMERS",
          "id": "4",
          "type": "table",
          "coordinates": [
            {
              "hashCode": "0",
              "x": 1,
              "y": 13
            },
            {
              "hashCode": "0",
              "x": 1,
              "y": 26
            }
          ],
          "columns": [
            {
              "name": "ID",
              "id": "5",
              "coordinates": [
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 28
                },
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 30
                }
              ]
            },
            {
              "name": "FIRST_NAME",
              "id": "6",
              "coordinates": [
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 32
                },
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 42
                }
              ]
            },
            {
              "name": "LAST_NAME",
              "id": "7",
              "coordinates": [
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 44
                },
                {
                  "hashCode": "0",
                  "x": 1,
                  "y": 53
                }
              ]
            }
          ]
        }
      ]
    }
  }
}

OK

Sample response:

{
  "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",
  "job": {
    "ignoreFunction": true,
    "lastExecuteTime": "2022-10-04 10:45:05",
    "schedulable": false,
    "parallel": false,
    "ignoreRecordSet": true,
    "userEmail": "[e-mail]",
    "persist": false,
    "executeTimeMillis": 0,
    "jobName": "yuanhao1",
    "dataflowOfAggregateFunction": "direct",
    "showTransform": false,
    "sessionId": "24a4455c71fa35c0393d5747f9c23a9d99f32fa4c130a6b8da8d6a7db8d157ae_1664880305725",
    "incremental": false,
    "showConstantTable": false,
    "userId": "auth0|6326be4047c1dfdd3bf553d0",
    "showRelationType": "fdd",
    "subJobs": [],
    "version": "5.2.0",
    "jobId": "939fdbbaf52b45139b86c0761d6036b0",
    "createTime": "2022-10-04 10:45:04",
    "onTop": false,
    "cancelSchedule": false,
    "dbVendor": "dbvoracle",
    "fileNames": [
      "test.sql"
    ],
    "status": "success",
    "executeTime": "0min 1sec"
  }
}