/submitUserJob

Submit a simple sqlflow job. Send the SQL files and get the data lineage result. SQLFlow job supports both of multiple files and zip archive file.

submit user job

Submit a simple sqlflow job. Send the SQL files and get the data lineage result. SQLFlow job supports both of multiple files and zip archive file.

POSThttps://api.gudusoft.com/api/gspLive_backend/sqlflow/job/submitUserJob

Query parameters

Body

multipart/form-data

sqlfilesarray of string (binary)

Response

200201401403404

OK

Body

application/json;charset=utf-8

string

Example: "{code=200, data={jobId=c359aef4bd9641d697732422debd8055, jobName=job1, userId=google-oauth2|104002923119102769706, dbVendor=dbvmssql, dataSource={}, fileNames=[1.sql, 1.zip], createTime=2020-12-15 15:14:39, status=create}}"

Request

JavaScriptCurlPython

const response = await fetch('https://api.gudusoft.com/api/gspLive_backend/sqlflow/job/submitUserJob?dbvendor=dbvazuresql&jobName=text&token=text&userId=text', {
    method: 'POST',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

200

{code=200, data={jobId=c359aef4bd9641d697732422debd8055, jobName=job1, userId=google-oauth2|104002923119102769706, dbVendor=dbvmssql, dataSource={}, fileNames=[1.sql, 1.zip], createTime=2020-12-15 15:14:39, status=create}}

Sample response:

{
	"code":200,
	"data":{
		"jobId":"c359aef4bd9641d697732422debd8055",
		"jobName":"job1",
		"userId":"google-oauth2|104002923119102769706",
		"dbVendor":"dbvmssql",
		"dataSource":{
			
		},
		"fileNames":["1.sql","1.zip"],
		"createTime":"2020-12-15 15:14:39",
		"status":"create"
	}
}

Try it out!

hint: Ignoring the temporary table starting with "#" in sqlserver is a mandatory behavior, therefore it cannot be changed.