List Jobs¶
Get the data reading jobs or data writing jobs of a specified channel.
Prerequisites¶
Channels are created and started in the organization.
Request Format¶
GET https://{apigw-address}/data-federation/v2.0/channels/read/{channelId}/jobs
Request Parameters (Header)¶
Name |
Mandatory/Optional |
Data Type |
Description |
---|---|---|---|
Content-Type |
Mandatory |
String |
Content or file type. The default value is application/json. |
Request Parameters (URI)¶
Name |
Location (Path/Query) |
Mandatory/Optional |
Data Type |
Description |
---|---|---|---|---|
orgId |
Query |
Mandatory |
String |
Your organization ID. How to get the orgId>> |
channelId |
Path |
Mandatory |
String |
Channel ID. |
Response Parameters¶
Name |
Data Type |
Description |
---|---|---|
data |
List<Object> |
List of returned jobs. For more information, see Job Data Struct |
Job Data Struct¶
Name |
Data Type |
Description |
---|---|---|
runningJobs |
List<Object> |
List of running jobs. For more information, see Job Information Struct |
finishedJobs |
List<Object> |
List of finished jobs. For more information, see Job Information Struct |
Jon Information Struct¶
Name |
Data Type |
Description |
---|---|---|
jobId |
String |
Job ID. |
sqlQuery |
String |
SQL query for getting data from storage systems. |
state |
String |
Data querying state. State values can be Failed, Canceled, or Succeeded. |
requestTime |
String |
Time when the job is submitted. |
duration |
String |
Running duration of the job. |
startTime |
String |
Time when the job started. |
endTime |
String |
Time when the job finished. |
Sample¶
Request Sample¶
url: https://{apigw-address}/data-federation/v2.0/channels/read/{channelId}/jobs?orgId={}
method: GET
Return Sample¶
{
"msg": "OK",
"code": 0,
"data": {
"runningJobs": null,
"finishedJobs": [
{
"jobId": "2131ceb9-c00d-d42d-33db-c21002b97d16",
"sqlQuery": "show schemas",
"state": "Succeeded",
"requestTime": "05/27/2020 09:22:13",
"duration": "1.871 sec",
"startTime": 1590571333699,
"endTime": 1590571335570
}]
}
}
SDK Samples¶
You can access the SDK samples for data federation service on GitHub: