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: