Api to fetch Jedox Cloud Integrator Job completion status from oData Hub #885
PramodMohandas
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We are trying to load and run Jedox Cloud Integrator Job from .net core(latest version .net 6) console application.
Below is the code snippet that we are using to run the job
var runResult = await client
.For("Integrator")
.Key("globalprojects")
.NavigateTo("Projects")
.Key("ETLTasks")
.NavigateTo("Jobs")
.Key("CubeCopy")
.Function("Run")
.Set(new { Variables = "SourceConn="localhost",TargetConn="localhost"" })
.ExecuteAsSingleAsync();
After executing this code we are getting the result sample as follows
{
"id": 5913,
"errors": 0,
"warnings": 0,
"startDate": "2022-12-09T00:07:14.022+00:00",
"status": "Queued",
"executionType": "STANDARD",
"traceAvailable": false
}
Below given is the Api URL for above request
https://odata.{InstanceName}.cloud.jedox.com/Integrator('{GroupIdentifier}')/Projects('{ProjectName}')/Jobs('{JobName}')/Run(Variables='{Variables}')
The status is always says as "Queued".
Our requirement to show the latest job completion status such as 'Completed successfully' or 'Failed' or whatever it is.
Can we get a new api which accept 'Id' as parameter which returns the correct job completion status ?
**Sample job run success response format
{
"id": 5913,
"errors": 0,
"warnings": 0,
"startDate": "2022-12-09T00:07:14.022+00:00",
"status": "Completed successfully",
"executionType": "STANDARD",
"traceAvailable": false
}**
**Sample job run success response format
{
"id": 5913,
"errors": 0,
"warnings": 0,
"startDate": "2022-12-09T00:07:14.022+00:00",
"status": "Failed",
"executionType": "STANDARD",
"traceAvailable": false
}**
It would be great if we can get an api which gives us real time job run status from Jedox Cloud Integrator monitor.
Attached the OpenApi of all available rest api from Jedox Cloud
Jedox cloud open api.txt
oData hub
Beta Was this translation helpful? Give feedback.
All reactions