# Get results of BigQuery "Write Query" module in a single array

**URL:** <https://community.make.com/t/get-results-of-bigquery-write-query-module-in-a-single-array/20169>\
**Category:** Questions\
**Tags:** collections, arrays\
**Created:** [November 23, 2023, 3:47pm UTC](https://community.make.com/t/get-results-of-bigquery-write-query-module-in-a-single-array/20169 "2023-11-23T15:47:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chambon\_Robin](https://avatars.discourse-cdn.com/v4/letter/c/3d9bf3/32.png) [@Chambon\_Robin](https://community.make.com/u/Chambon_Robin)\
**Post date:** [November 23, 2023, 3:47pm UTC](https://community.make.com/t/get-results-of-bigquery-write-query-module-in-a-single-array/20169/1 "2023-11-23T15:47:14Z")

</div>

I’m looking to obtain the results of a BigQuery “Write Query” module in a single array, with the key = value combination for each result, like this

 ![Capture d’écran 2023-11-24 à 12.05.15](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/9/1917c28dda7980c4898b40bddbcad605cdfb3b6c.png)

This is the output of the module “Write Query” on Make.

 ![Capture d’écran 2023-11-23 à 15.28.02](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/35f2186951e2bc06e03d7bef127d1b021d697857.png)

The final objectif is to add every result on a google sheet, like this  
 ![Capture d’écran 2023-11-24 à 12.03.45](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2be0ce68652e91a613cd201b23ee509a4dbeab99.png)

Here is the blueprint !

Thank you !! 🙏  
[Mapper l’output d’un module BigQuery.json](https://community.make.com/uploads/short-url/sYFU1flSuMY2UxNpRTtemTKZVOI.json) (5.4 KB)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [November 24, 2023, 1:40am UTC](https://community.make.com/t/get-results-of-bigquery-write-query-module-in-a-single-array/20169/2 "2023-11-24T01:40:27Z")

</div>

Welcome to the Make community!

Thanks for providing screenshots of your output bundle, but we need it in text format to assist you —

After running the scenario, click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a `bundle.json` file, and upload it here into this discussion thread.  
 ![Screenshot_2023-10-06_141025](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png)

Providing the output bundles will allow others to _replicate_ what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [February 22, 2024, 1:47am UTC](https://community.make.com/t/get-results-of-bigquery-write-query-module-in-a-single-array/20169/4 "2024-02-22T01:47:20Z")

</div>