# API GET records

**URL:** <https://community.thunkable.com/t/api-get-records/1543617>\
**Category:** Questions about Thunkable X\
**Created:** [October 4, 2021, 10:06pm UTC](https://community.thunkable.com/t/api-get-records/1543617 "2021-10-04T22:06:15Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 4, 2021, 10:06pm UTC](https://community.thunkable.com/t/api-get-records/1543617/1 "2021-10-04T22:06:15Z")

</div>

Hi can any one help me to fix this problem

i want to connect data with my app by API i did that and i get the JOSN response

 ![IMG_0149](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/d/cd8ff4cb41abe0243485a7732e5e11484710a2b0.jpeg)

but now i need to create row for each items but it not work

 ![Screen Shot 2021-10-05 at 1.01.21 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9bf33b17ff8ebaa71f9ebdeae27c55c235416e82.png)

Thank You

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 4, 2021, 10:29pm UTC](https://community.thunkable.com/t/api-get-records/1543617/2 "2021-10-04T22:29:52Z")

</div>

You need to use the `get object from JSON` block instead of the `generate JSON from object` block.

If you still have trouble, post the full text of the JSON response here (not as a screenshot, actual text).

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 4, 2021, 10:44pm UTC](https://community.thunkable.com/t/api-get-records/1543617/3 "2021-10-04T22:44:56Z")

</div>

hi @tatiang thanks for your replay

i try what you say but its not work its giving me

**[object Object]**

this is the the full text of the JSON response

“{“records”:[{“id”:1,“Name”:“bader”,“created\_at”:“2021-10-04T20:30:45.764Z”,“updated\_at”:“2021-10-04T21:41:13.903Z”},{“id”:2,“Name”:“yazan”,“created\_at”:“2021-10-04T21:39:29.511Z”,“updated\_at”:“2021-10-04T21:41:08.218Z”}]}”

i have 3 record for each row  
Name  
created\_at  
updated\_at

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 4, 2021, 11:34pm UTC](https://community.thunkable.com/t/api-get-records/1543617/4 "2021-10-04T23:34:02Z")

</div>

> [@bader\_mouti](#):
>
> “{“records”:[{“id”:1,“Name”:“bader”,“created\_at”:“2021-10-04T20:30:45.764Z”,“updated\_at”:“2021-10-04T21:41:13.903Z”},{“id”:2,“Name”:“yazan”,“created\_at”:“2021-10-04T21:39:29.511Z”,“updated\_at”:“2021-10-04T21:41:08.218Z”}]}”

That text is invalid JSON. Is there any way you can send me the Web API url you’re using? Or maybe try copying the text again and pasting it in [Best JSON Viewer and JSON Beautifier Online](https://codebeautify.org/jsonviewer)? If you click “Tree Viewer” on that site, you should get formatted JSON that you can then post here as a screenshot. I’m just trying to confirm that your JSON is valid and so far it is not.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 4, 2021, 11:52pm UTC](https://community.thunkable.com/t/api-get-records/1543617/5 "2021-10-04T23:52:34Z")

</div>

this the API URL

[https://api.adalo.com/v0/apps/bc2e0083-b9f2-489e-a6bd-b8a3e60dea8e/collections/t\_1iwgb957v1it20quwv5rylk9q](https://api.adalo.com/v0/apps/bc2e0083-b9f2-489e-a6bd-b8a3e60dea8e/collections/t_1iwgb957v1it20quwv5rylk9q)

**Authorization:** Bearer 63nte6l7hui9ac1ifjlgdzhxi

**Content-Type:** application/json

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 5, 2021, 12:32am UTC](https://community.thunkable.com/t/api-get-records/1543617/6 "2021-10-05T00:32:32Z")

</div>

Thanks. Here’s the raw JSON response (I used Postman to generate it):

{“records”:[{“id”:1,“Name”:“bader”,“created\_at”:“2021-10-04T20:30:45.764Z”,“updated\_at”:“2021-10-04T21:41:13.903Z”},{“id”:2,“Name”:“yazan”,“created\_at”:“2021-10-04T21:39:29.511Z”,“updated\_at”:“2021-10-04T21:41:08.218Z”}]}

And formatted at [codebeautify](https://codebeautify.org/jsonviewer):

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/c/7c8a13ec330c8cad008850be1e9e0acd6aab7aad.png)

~~Your blocks for the “Name” property should work~~ but not for the “Image” property because it doesn’t exist. What happens if you just assign the value of `get property "Name" of object j` to a label? Can you see the value then?

**Edit:** Actually, I think you’ll need to get the property name “records” first, then loop through that value as a list to get the “Name” property.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 3:32am UTC](https://community.thunkable.com/t/api-get-records/1543617/7 "2021-10-05T03:32:32Z")

</div>

It not work at all I had tried everything

About property image I deleted it because of that  
It’s not showing up in josn text

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 5, 2021, 3:33am UTC](https://community.thunkable.com/t/api-get-records/1543617/8 "2021-10-05T03:33:43Z")

</div>

Your JSON is a list. You need first to convert the JSON to object then you need to loop using `for each item in....` block using `get property....` object block and use the name “records”.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 5, 2021, 3:36am UTC](https://community.thunkable.com/t/api-get-records/1543617/9 "2021-10-05T03:36:51Z")

</div>

“It not work at all” is really not helpful information. Post a screenshot of your blocks. Otherwise, there’s no way I can know what you’ve done wrong and how to fix it.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 3:37am UTC](https://community.thunkable.com/t/api-get-records/1543617/10 "2021-10-05T03:37:37Z")

</div>

Thank you munir for your reply  
What you mean of ( use the name “records” )

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 5, 2021, 3:40am UTC](https://community.thunkable.com/t/api-get-records/1543617/11 "2021-10-05T03:40:04Z")

</div>

> [@bader\_mouti](#):
>
> use the name “records”

Use it in the `get property "records" of object....` block.

I can show you an example later in the day.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 3:42am UTC](https://community.thunkable.com/t/api-get-records/1543617/12 "2021-10-05T03:42:21Z")

</div>

i mean i tried what you say but its not working

 ![Screen Shot 2021-10-05 at 6.40.33 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d9b6581c749ebe93e89b379dbdb5d5854a30a543.png)

thank you

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 3:43am UTC](https://community.thunkable.com/t/api-get-records/1543617/13 "2021-10-05T03:43:38Z")

</div>

thank you munir that will be very helpful

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 5, 2021, 3:43am UTC](https://community.thunkable.com/t/api-get-records/1543617/14 "2021-10-05T03:43:52Z")

</div>

You are doing it wrong. It won’t work this way.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 3:48am UTC](https://community.thunkable.com/t/api-get-records/1543617/15 "2021-10-05T03:48:50Z")

</div>

okay so i will wait your example later today

@muneer & @tatiang thank you guys

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 5, 2021, 3:55am UTC](https://community.thunkable.com/t/api-get-records/1543617/16 "2021-10-05T03:55:11Z")

</div>

You’re close. Very helpful to see your screenshot!

Because the object has “records” at the top of the tree ([in this screenshot](https://community.thunkable.com/t/api-get-records/1543617/6)), you need to first get the property “records” of `app variable Get Value` and set that to something like `app variable Records List`. Then, loop through `for each item j in list` with the list value being `app variable Records List`. And then `get property "Name" of object j`. Assign that to a label to see if the values are what you expect.

I’ll see if I can make you an example screenshot.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 4:01am UTC](https://community.thunkable.com/t/api-get-records/1543617/17 "2021-10-05T04:01:20Z")

</div>

this difficult hhhhh 😅

It looks so complicated, I don’t understand how to do it. Yes please, some screenshots will be very useful so that I understand what you mean

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 5, 2021, 4:01am UTC](https://community.thunkable.com/t/api-get-records/1543617/18 "2021-10-05T04:01:48Z")

</div>

See this quick sample

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/6/56bc74a80c71c67e560f60221211fe1aa692f495.png)

Output  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/d/1d0565146bcec455a6430537105f571e6a8a9109.png)

I used the JSON string instead of the `Web API` just to make it simpler and faster to show.

Hope this can answer your question.

---

<div class="post-metadata">

**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\
**Post date:** [October 5, 2021, 4:09am UTC](https://community.thunkable.com/t/api-get-records/1543617/19 "2021-10-05T04:09:10Z")

</div>

**Muneer** thank you so much for yor help its working now

@muneer & @tatiang thank you guys

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 5, 2021, 4:09am UTC](https://community.thunkable.com/t/api-get-records/1543617/20 "2021-10-05T04:09:54Z")

</div>

Glad to hear that it’s working.

[Next page](https://community.thunkable.com/t/api-get-records/1543617.md?page=2)