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

**URL:** <https://matillioncommunity.discourse.group/t/how-to-extract-grid-values-from-every-orchestration-in-a-project/2255>\
**Category:** Matillion ETL\
**Created:** [July 31, 2023, 4:56pm UTC](https://matillioncommunity.discourse.group/t/how-to-extract-grid-values-from-every-orchestration-in-a-project/2255 "2023-07-31T16:56:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Life\_Long\_Learner](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/life_long_learner/32/57_2.png) [@Life\_Long\_Learner](https://matillioncommunity.discourse.group/u/Life_Long_Learner)\
**Post date:** [July 31, 2023, 4:56pm UTC](https://matillioncommunity.discourse.group/t/how-to-extract-grid-values-from-every-orchestration-in-a-project/2255/1 "2023-07-31T16:56:05Z")

</div>

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).

&nbsp;

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

&nbsp;

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

&nbsp;

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

&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![ChikaMatillionCommunityMgr](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@ChikaMatillionCommunityMgr](https://matillioncommunity.discourse.group/u/ChikaMatillionCommunityMgr)\
**Post date:** [August 1, 2023, 7:14pm UTC](https://matillioncommunity.discourse.group/t/how-to-extract-grid-values-from-every-orchestration-in-a-project/2255/2 "2023-08-01T19:14:37Z")

</div>

Hi [@Life\_Long\_Learner](https://matillioncommunity.discourse.group/u/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
