# Get JSON Objects

**URL:** <https://community.thunkable.com/t/get-json-objects/76019>\
**Category:** Questions about Thunkable X\
**Created:** [May 8, 2019, 3:26pm UTC](https://community.thunkable.com/t/get-json-objects/76019 "2019-05-08T15:26:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charles\_Casteel](https://avatars.discourse-cdn.com/v4/letter/c/a88e57/32.png) [@Charles\_Casteel](https://community.thunkable.com/u/Charles_Casteel)\
**Post date:** [May 8, 2019, 3:26pm UTC](https://community.thunkable.com/t/get-json-objects/76019/1 "2019-05-08T15:26:55Z")

</div>

Thanks for getting back to me so quick  
I am still not able to produce a list of restaurants with my blocks.

I am attaching the revised blocks so that you can see what I am doing wrong.

I am also attaching some of the JSON results so you can see what iI am trying to do.

Charles

 ![myblocks](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c1c73314f634cad11c14ff31d8c756f13053271c.png)

 ![myJson](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/51484beaaad44707d40d49371b1e2783bc599fde.png)

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [May 8, 2019, 3:40pm UTC](https://community.thunkable.com/t/get-json-objects/76019/2 "2019-05-08T15:40:16Z")

</div>

If you give me the whole JSON response in the form of a text file, then I will look at it.

Your main mistake is that you are trying to get the data in a loop. First try to get data without a loop. For this you need to get an object with index 1.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)\
**Post date:** [May 8, 2019, 4:58pm UTC](https://community.thunkable.com/t/get-json-objects/76019/3 "2019-05-08T16:58:35Z")

</div>

To build upon Александр’s reply, it looks like your JSON response is an object. not a list, so your `'for each item j in list "app TMresponse"'` blocks will fail. I believe that you want to get the the “results” property of your JSON response object (i.e. `'app TMResponse'`) and then iterate of that list using the `'for each item j in list'` block.

Hope this helps.

-Mark

---

<div class="post-metadata">

**Author:** ![Charles\_Casteel](https://avatars.discourse-cdn.com/v4/letter/c/a88e57/32.png) [@Charles\_Casteel](https://community.thunkable.com/u/Charles_Casteel)\
**Post date:** [May 17, 2019, 12:07am UTC](https://community.thunkable.com/t/get-json-objects/76019/4 "2019-05-17T00:07:26Z")

</div>

I am getting the proper response and I am storing the results in an Airtable spreadsheet.

When I am finished, I want to delete ALL records from the spreadsheet. It seems like it will delete row two and some others but not all rows.

Thanks

Charles

---

<div class="post-metadata">

**Author:** ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)\
**Post date:** [May 17, 2019, 4:19pm UTC](https://community.thunkable.com/t/get-json-objects/76019/5 "2019-05-17T16:19:42Z")

</div>

> [@Charles\_Casteel](#):
>
> When I am finished, I want to delete ALL records from the spreadsheet. It seems like it will delete row two and some others but not all rows.

Charles, It’s difficult to diagnose your problem without seeing the blocks that you are using to delete the records.

-Mark

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/get-json-objects/76019/6 "2024-11-08T12:13:41Z")

</div>


