How to Extract Grid Values from EVERY Orchestration in a Project?

Matillion ETL
1

I have a need to extract default Grid Variable values from Every orchestration in a project. I would like to do this in an automated way (such as API calls or Web Scraping).

 

So far I've only tried using API v1 but can't seem to narrow down to the grid variable default values.

 

Has anyone ever tried doing this before with API calls? Is it even possible with API?

 

Is there a simpler way to iterate through all Orchestrations and extract grid variable values?

 

 

 

2

Hi @Life_Long_Learner​ (love your name, btw!)

Grid variables are local to a job and Matillion do not have an API endpoint to export grid variable data from a job. One option is to export a job definition via the API and and parse its JSON to get the information they need. Let me know if that works.

Cheers,

Chika