Get latest run history for a data flow
/api/20210901/catalog/dataflows/{dataflowId}/history/latest
Request
-
dataflowId(required): string(byte)
The object ID of the data flow with Base64URL encoding. For example, if your data flow has the object ID 'User1'.'dataflow1', enter the Base64URL encoded value, J1VzZXIxJy4nZGF0YWZsb3cxJw==.
-
includeTasks: boolean(byte)
Specifies whether to return historical task and job information or only the job history. Possible values are true or false. Specify true, to return both task history and job history. Specify false, to return only job history. The default value is true.
There's no request body for this operation.
Back to TopResponse
- application/json
200 Response
object
-
jobEndTimestamp: string
Time job finished.
-
jobExecutionTimestamp: string
Time job started.
-
jobIdentifier: string
Identifier for the job.
-
jobName: string
Name of the job.
-
jobNumberOfTasks: number
Number of tasks in the job.
-
jobOriginOfRequest: string
Source of the job request. Either Manual or Schedule.
-
jobQueuedDuration: string
Length of time (in seconds) that the job spent in the queue.
-
jobRunDuration: string
Length of time taken (in seconds) for the job to run.
-
jobRunType: string
Type of job. For example: DATASET, DATAFLOW, SEQUENCE.
-
jobStartTimestamp: string
Time job requested.
-
jobStatus: string
Status of the job. For example: ACCEPTED, IN_PROGRESS, FAILED, SUCCEEDED, CANCELING, CANCELED.
-
jobTasks:
jobTasks
object
-
taskAverageReadThroughput: number
Average read throughput for the task.
-
taskDataSizeInBytes: number
Total data processed by the task in bytes.
-
taskEndTimestamp: string
Time the task finished.
-
taskName: string
Name of the task.
-
taskNumberOfSuccessfulRows: number
Number of rows successfully processed by this task.
-
taskRunDuration: string
Length of time taken (in seconds) for the task to run.
-
taskSourceName: string
Name of the source connection.
-
taskStartTimestamp: string
Time the task started.
-
taskStatus: string
Status of the task. For example: ACCEPTED, IN_PROGRESS, FAILED, SUCCEEDED, CANCELING, CANCELED.
-
taskTargetName: string
Name of the target connection.
403 Response
object
-
code(required): string
Short error code that defines the error, meant for programmatic parsing.
-
message(required): string
Human-readable error string.
404 Response
object
-
code(required): string
Short error code that defines the error, meant for programmatic parsing.
-
message(required): string
Human-readable error string.
500 Response
object
-
code(required): string
Short error code that defines the error, meant for programmatic parsing.
-
message(required): string
Human-readable error string.
Examples
In this example, you return the
detailed history of the most recent job run for a given dataflowID. The object ID of
the data flow is 'john.smith@mycompany.com'.'MySalesDataFlow: Enrich MySales Report'
which has the Base64URL-safe encoded dataflowID value:
J2pvaG4uc21pdGhAbXljb21wYW55LmNvbScuJ015U2FsZXNEYXRhRmxvdzogRW5yaWNoIE15U2FsZXMgUmVwb3J0Jw
.
cURL Example:
curl -i \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --request GET 'https://<hostname>/api/20210901/catalog/dataflows/J2pvaG4uc21pdGhAbXljb21wYW55LmNvbScuJ015U2FsZXNEYXRhRmxvdzogRW5yaWNoIE15U2FsZXMgUmVwb3J0Jw/history/latest' \
This example returns both job and task history for the latest run.
Example of Request Body
Not applicable.
Example of Response Body
[ { "jobName":"'john.smith@mycompany.com'.'MySalesDataFlow: Enrich MySales Report'", "jobIdentifier":"1234ABCD5678EFGH9012IJKL3456MNOP", "jobStartTimestamp":"2024-05-14T18:30:50.0+0000", "jobExecutionStartTimestamp":"2024-05-14T18:31:07.0+0000", "jobEndTimestamp":"2024-05-14T18:31:25.0+0000", "jobStatus":"SUCCEEDED", "jobRunType":"DATAFLOW", "jobQueuedDuration":"PT35S", "jobRunDuration":"PT18S", "jobOriginOfRequest":"Manual", "jobNumberOfTasks":"1", "jobTasks": [{"taskName":"DFLW : MySalesDataFlow: Enrich MySales Report", "taskStartTimestamp":"2024-05-14T18:31:10.0+0000", "taskEndTimestamp":"2024-05-14T18:31:25.0+0000", "taskStatus":"SUCCEEDED", "taskDuration":"PT15S"}] } ]
cURL Example with Parameters:
If you want to exclude task history, apply the query parameter
includeTasks=false
.
curl -i \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --request GET 'https://<hostname>/api/20210901/catalog/dataflows/J2pvaG4uc21pdGhAbXljb21wYW55LmNvbScuJ015U2FsZXNEYXRhRmxvdzogRW5yaWNoIE15U2FsZXMgUmVwb3J0Jw/history/latest?includeTasks=false'