# Parse json from API

**URL:** <https://community.make.com/t/parse-json-from-api/18279>\
**Category:** Beginner Questions\
**Tags:** quickbooks, arrays, json, api\
**Created:** [October 26, 2023, 7:40am UTC](https://community.make.com/t/parse-json-from-api/18279 "2023-10-26T07:40:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kristaps\_Garkevics](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@Kristaps\_Garkevics](https://community.make.com/u/Kristaps_Garkevics)\
**Post date:** [October 26, 2023, 7:40am UTC](https://community.make.com/t/parse-json-from-api/18279/1 "2023-10-26T07:40:47Z")

</div>

Hello there, Make Community,

I very new to [make.com](http://make.com) data pipeline development, so, having some struggle to do a regular json data parse.  
I have first step, which pick data from Quickbooks API, which runs successfully.  
 ![Screenshot 2023-10-26 at 10.18.50](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/1/91d5e45ac081c5408a5d775e4b28fecc7523c7b5.png)  
Here is an example of **Make an API call** Output json.  
[quickbooks\_json.json](https://community.make.com/uploads/short-url/kVuIBfGeyawGK30wW5e0JIL63tM.json) (5.5 KB)  
And I would like to write data into BigQuery table, where I have parsed array.  
Path to the array I would like to have on BQ:

```auto
body.Row.Rows[].Rows.Row[].colData[]

```

Basically, I need colData[] array which is within Rows.Row[] array which is within body.Row.Rows[] array.

I have created an iterators to get to the array elements I need, but I don’t even know, if I go into right direction to get data I need.

 ![Screenshot 2023-10-26 at 10.39.04](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/d/6d09a034acf195f73fb257df5effbd9416a3c446.png)

Help would be appreciated.

Thank you for your attention.

Kristaps

---

<div class="post-metadata">

**Author:** ![IOA\_Harman](https://avatars.discourse-cdn.com/v4/letter/i/ce7236/32.png) [@IOA\_Harman](https://community.make.com/u/IOA_Harman)\
**Post date:** [October 26, 2023, 5:08pm UTC](https://community.make.com/t/parse-json-from-api/18279/2 "2023-10-26T17:08:50Z")

</div>

Hi Kristaps, please import this blueprint I am sending, you can review the ‘steps’ in the set variables module to understand what is happening. (You would now use one of these array’s to iterate over)  
[Example.json](https://community.make.com/uploads/short-url/qgR5dV6Dd1AjDX5zJj97JjDmWBG.json) (11.9 KB)

 ![Screenshot 2023-10-26 at 11.07.41 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/2/02d5168fc4de3a234ba1890c515d82e9e5dbbd2a.png)  
 ![Screenshot 2023-10-26 at 11.07.56 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/a/bac1bf6ecec34413c6f3143ebbe55e095a870884.png)

Import here:

 ![Screenshot 2023-10-26 at 11.08.27 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/f/4fda08217491874a523a07f21972ce788b49f807.png)

Here is the mappings for the set variable module:

 ![Screenshot 2023-10-26 at 11.09.37 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/b/fbf13649f99dae3ecaf7d92e90f40bfbcc891423.png)  
 ![Screenshot 2023-10-26 at 11.09.47 AM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/a/ea2f4b102a2b0b7079c1872331bab0666c7c9eb6.png)

---

<div class="post-metadata">

**Author:** ![Kristaps\_Garkevics](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@Kristaps\_Garkevics](https://community.make.com/u/Kristaps_Garkevics)\
**Post date:** [October 27, 2023, 10:45am UTC](https://community.make.com/t/parse-json-from-api/18279/3 "2023-10-27T10:45:41Z")

</div>

Dear @IOA_Harman

Thank you very much for the explanation, and time invested from Your side. Looks good, and approved.  
Was missing in logic the Import Blueprint step, as was experimenting with different kind of solutions.

Kristaps

---

<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:** [November 15, 2023, 11:07am UTC](https://community.make.com/t/parse-json-from-api/18279/4 "2023-11-15T11:07:16Z")

</div>