Matillion API orchestration jobs

Matillion ETL
1

Hello,

I am currently using the Matillion API to find all orchestration jobs, to then find a way to group them to their parent jobs to eventually create a KPI for pipeline availability. I don’t seem to see the connection between the description of the orchestration job using ex: …/orchestration_job_name/export.

The IDs of the child components/jobs don’t seem to correspond with the IDs of said jobs when you use the link …/orchestration_job_name/id, which means it seems difficult to find the child jobs. Is there any other way to find said child jobs, either via the tags, their name or even with the job ID using the Matillion API?

Thank you.

Matillion ETL API - v1 - Matillion Docs

image
image953×575 38.1 KB

2

Hello @lucas.guevremont

Thank you for your post and welcome to the Matillion Community.

I spoke with our team about this and to achieve this you would need to create a mapping table that contained the names of the child jobs, this is because the run orchestration component only uses the full path plus name of the child, it does not reference it by the job identity.

I hope this helps, if you need anything else, please let me know.

Kind regards, Joe