# How to extract info from this JSON

**URL:** <https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, webapi, json\
**Created:** [March 5, 2020, 12:40pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882 "2020-03-05T12:40:20Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![f3c0931448c949](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@f3c0931448c949](https://community.thunkable.com/u/f3c0931448c949)\
**Post date:** [March 5, 2020, 12:40pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/1 "2020-03-05T12:40:20Z")

</div>

Hi guys, I have a problem with this type of JSON file.  
[Link](https://db.ygoprodeck.com/api/v6/cardinfo.php)  
How Can I extract all “name” from this JSON and add them to a List\_view?

Thanks for helping me \<3

---

<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:** [March 5, 2020, 6:54pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/2 "2020-03-05T18:54:48Z")

</div>

Hi,

 ![изображение](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/4/d4fc19cc6528cd230ca73dc2859661ab95503f26.png)

When working with this amount of data, filtering is used, rather than displaying all the names in the List Viewer. That is, the list is initially empty, and it is filled in after entering the search string. In this case, you need to set a limit on the output of no more than 100 records, otherwise the List Viewer will work very slowly how does this happen in my example.

See example on scrFinder in [Thunkable](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [March 5, 2020, 7:51pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/3 "2020-03-05T19:51:25Z")

</div>

Hey @f3c0931448c949, Thanks for reaching out to the community and asking this question! Admittedly, working with JSON and API’s can be very intimidating at first. Really, once you learn how to turn it into a list to work with, it get’s easier to read/filter these. I have only begun to understand how to retrieve my desired informations from these.

So, I was able to filter this differently a little differently. Instead of turning the response into objects, which is admittedly easier looking, I parse the entire list based upon where certain pieces of text show up after splitting the entire response into a list. The entire list populates in seconds on my iPhone 11.

you’ll notice that I used the function type variables almost exclusively. I did this because, as @actech has posted in the past, they work much faster than app/stored type variables. Populating individual card prices from a click in the list viewer is only slightly slow on my phone. I’d love to hear how it runs on your device!

[https://x.thunkable.com/copy/d2bcd4912bbe56431a9a0842aaf4adfb](https://x.thunkable.com/copy/d2bcd4912bbe56431a9a0842aaf4adfb)

 ![Screen Shot 2020-03-05 at 2.56.42 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c87593f750cb4ec24e88fdd1deb29713a12bc74f.png)

![giphy (13)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/9/29cd2f052cbf75a0522733649edf5e387369d996.gif)

I’d love to see this remixed with a search bar added in! Any takers??

For reference, it’s a 10,000 + item (easily 200,000 words in total) list in Json format that looks like this

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/f/2f80daeacd110164407f16dacf0e55e8e13141bb.png)

---

<div class="post-metadata">

**Author:** ![f3c0931448c949](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@f3c0931448c949](https://community.thunkable.com/u/f3c0931448c949)\
**Post date:** [March 7, 2020, 12:51pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/4 "2020-03-07T12:51:02Z")

</div>

Thank you so much for helping me. I will try more soon i can. And also thank you so much for explaing to me the problem when we have a lot of data to store.

\<3

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [September 3, 2020, 7:12am UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/5 "2020-09-03T07:12:04Z")

</div>

Jared,  
the links does not work anymore?

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [September 3, 2020, 10:30am UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/6 "2020-09-03T10:30:06Z")

</div>

This app doesn’t exist for me anymore. I deleted it a while back. You should be able to copy the blocks exactly.

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [September 3, 2020, 10:52am UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/7 "2020-09-03T10:52:51Z")

</div>

thanks Jared

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [September 4, 2020, 3:51pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/8 "2020-09-04T15:51:36Z")

</div>

Jared,

if you can advice about this. i try to click on list view and place it at text so i can edit or delete.  
this is API control also. i only got undefined and for sure my block is not right.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/15bda25a93e73c6404895463fcdf65edd4d95b76.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/f/6fd6790aa689e5d335cb3d5d2b0a92fb52149b0b.png)

---

<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:** [September 12, 2020, 3:49am UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/9 "2020-09-12T03:49:08Z")

</div>

Were you able to get this working?

One thing I’m confused by is that you’re creating a blank object called app register and then assigning it to be the row number of your Airtable spreadsheet. So you’re basically trying to get “row # nothing” from a spreadsheet. Try using an integer for rowNum.

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 11:40am UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/10 "2022-05-07T11:40:00Z")

</div>

Hello Everyone, I am having a problem extracting data from json. I have tested my api in a browser and got the json data.

[  
{  
“name”:“Kampala”,  
“local\_names”:{  
“ky”:“Кампала”,  
“uk”:“Кампала”,  
“en”:“Kampala”,  
“ko”:“캄팔라”,  
“fr”:“Kampala”,  
“cv”:“Кампала”,  
“ru”:“Кампала”,  
“tg”:“Кампала”,  
“bo”:“ཀམ་པ་ལ།”,  
“he”:“קמפלה”,  
“fa”:“کامپالا”,  
“mk”:“Кампала”,  
“pl”:“Kampala”,  
“ku”:“Kampala”,  
“ur”:“کمپالا”,  
“zh”:“坎帕拉”,  
“bg”:“Кампала”,  
“ka”:“კამპალა”,  
“ps”:“کامپالا”,  
“ar”:“كمبالا”,  
“am”:“ካምፓላ”,  
“hi”:“कंपाला”,  
“ug”:“كامپالا”,  
“ht”:“Kanpala”,  
“hu”:“Kampala”,  
“eo”:“Kampalo”,  
“sv”:“Kampala”,  
“ta”:“கம்பாலா”,  
“mr”:“कंपाला”,  
“kn”:“ಕಂಪಾಲಾ”,  
“pt”:“Kampala”,  
“oc”:“Kampala”,  
“so”:“Kambaala”,  
“sr”:“Кампала”,  
“be”:“Кампала”,  
“de”:“Kampala”,  
“el”:“Καμπάλα”,  
“ja”:“カンパラ”,  
“hy”:“Կամպալա”,  
“th”:“กัมปาลา”  
},  
“lat”:0.3177137,  
“lon”:32.5813539,  
“country”:“UG”,  
“state”:“Central Region”  
}  
]

I tried extracting the json data using this block.

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/e/9e4cee07cac44b581cbdf1ffecb229b75b45854e.jpeg)

I am trying to get the city name of kampala.  
can someone tell me what I am doing wrong?

---

<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:** [May 7, 2022, 12:33pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/11 "2022-05-07T12:33:03Z")

</div>

First of all, you are using a post that is 2 years old.

Create a post of your own instead of bumping up old topics.

Second, your JSON is a `List` so you need to use the list blocks to get the result.

Do this

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/4/f4e6b7ca82f025f0bb46c6fcdcb3662cd7d069e4.png)

You should get this  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/2/e2dece346501e0b78846767b25f5ba1064c6307d.png)

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 1:18pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/12 "2022-05-07T13:18:14Z")

</div>

Thanks

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 1:33pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/13 "2022-05-07T13:33:20Z")

</div>

I have tried what you have suggested.

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/d/ed329a3e83ad9f919e862e765381f15308330189.jpeg)

but I am getting null

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/6/263ff0d70fc7243bfd2f3663d6cec4abfc024f6b.jpeg)

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 1:36pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/14 "2022-05-07T13:36:56Z")

</div>

When I replace the blocks with the response block, I can see the json data.

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/f/9f7e4f05c843f802550ab05cf22651a4396e9ea3.jpeg)

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/99b775e3931aa1f7cae4f9606c12e728c667e118.jpeg)

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 2:23pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/15 "2022-05-07T14:23:25Z")

</div>

I am having problems extracting data from webapi. I can send get request with no problem. I get a what appears to be a json response.

This is the blocks I am using to parse for the name property.

 ![blocks](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6ad64637eee5d824b91d93bce6f6dff5d4fb016b.jpeg)

The result I get back is

 ![null](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/1/713803ac5997149b5e2a7190627eb0a1cc2964e3.jpeg)

I know the API is working because when I load the response directly into the label I get this.

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/99b775e3931aa1f7cae4f9606c12e728c667e118.jpeg)

The json data looks like this…

[{“name”:“Kampala”,“local\_names”:{“ky”:“Кампала”,“uk”:“Кампала”,“en”:“Kampala”,“ko”:“캄팔라”,“fr”:“Kampala”,“cv”:“Кампала”,“ru”:“Кампала”,“tg”:“Кампала”,“bo”:“ཀམ་པ་ལ།”,“he”:“קמפלה”,“fa”:“کامپالا”,“mk”:“Кампала”,“pl”:“Kampala”,“ku”:“Kampala”,“ur”:“کمپالا”,“zh”:“坎帕拉”,“bg”:“Кампала”,“ka”:“კამპალა”,“ps”:“کامپالا”,“ar”:“كمبالا”,“am”:“ካምፓላ”,“hi”:“कंपाला”,“ug”:“كامپالا”,“ht”:“Kanpala”,“hu”:“Kampala”,“eo”:“Kampalo”,“sv”:“Kampala”,“ta”:“கம்பாலா”,“mr”:“कंपाला”,“kn”:“ಕಂಪಾಲಾ”,“pt”:“Kampala”,“oc”:“Kampala”,“so”:“Kambaala”,“sr”:“Кампала”,“be”:“Кампала”,“de”:“Kampala”,“el”:“Καμπάλα”,“ja”:“カンパラ”,“hy”:“Կամպալա”,“th”:“กัมปาลา”},“lat”:0.3177137,“lon”:32.5813539,“country”:“UG”,“state”:“Central Region”}]

I simply want to get the name property so it will say Kampala.

---

<div class="post-metadata">

**Author:** ![paulovaz72](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/paulovaz72/32/119071_2.png) [@paulovaz72](https://community.thunkable.com/u/paulovaz72)\
**Post date:** [May 7, 2022, 2:33pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/16 "2022-05-07T14:33:58Z")

</div>

Hi,

Did you try to put the GET OBJECT FROM JSON block BEFORE the GET PROPERTY OF OBJECT?

Like this:

Set test label’s Text to → get object from JSON → get property of object “name” → response

---

<div class="post-metadata">

**Author:** ![agutthon777c](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@agutthon777c](https://community.thunkable.com/u/agutthon777c)\
**Post date:** [May 7, 2022, 3:01pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/18 "2022-05-07T15:01:27Z")

</div>

Tried that and still getting “null”

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [May 7, 2022, 3:36pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/20 "2022-05-07T15:36:08Z")

</div>

You are pulling an object from a list. So you need to get item one from the response and then get the object from item one then you can access that objects property called name

---

<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:** [May 7, 2022, 3:36pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/21 "2022-05-07T15:36:20Z")

</div>

Are you using the actual API JSON response this time or are you using the text that you posted above? Because the text above has smart quotes and won’t work properly. If you’re testing this with text in a variable as @muneer did, use this version without smart quotes:

```auto
[{"name":"Kampala","local_names":{"ky":"Кампала","uk":"Кампала","en":"Kampala","ko":"캄팔라","fr":"Kampala","cv":"Кампала","ru":"Кампала","tg":"Кампала","bo":"ཀམ་པ་ལ།","he":"קמפלה","fa":"کامپالا","mk":"Кампала","pl":"Kampala","ku":"Kampala","ur":"کمپالا","zh":"坎帕拉","bg":"Кампала","ka":"კამპალა","ps":"کامپالا","ar":"كمبالا","am":"ካምፓላ","hi":"कंपाला","ug":"كامپالا","ht":"Kanpala","hu":"Kampala","eo":"Kampalo","sv":"Kampala","ta":"கம்பாலா","mr":"कंपाला","kn":"ಕಂಪಾಲಾ","pt":"Kampala","oc":"Kampala","so":"Kambaala","sr":"Кампала","be":"Кампала","de":"Kampala","el":"Καμπάλα","ja":"カンパラ","hy":"Կամպալա","th":"กัมปาลา"},"lat":0.3177137,"lon":32.5813539,"country":"UG","state":"Central Region"}]

```

But more importantly, you’re not putting together the two suggestions that have been given in this topic: (1) use the `get object from JSON` block and (2) use the `in list get` block. Each of your most recent screenshots uses **one** of these suggestions but not both which is why this isn’t working for you and you’re getting a null response.

You need to follow @muneer’s example for setting the label’s text **exactly** and double-check that all of the blocks match:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/4/f4e6b7ca82f025f0bb46c6fcdcb3662cd7d069e4.png)

If you want to combine them another way, you can get the property “[1].name” of object and not use the `in list` block at all but you still need the `get object from JSON` block. Using [1] indicates the first list item.

If you’re still stuck, post a screenshot of your updated blocks

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [May 7, 2022, 3:39pm UTC](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882/22 "2022-05-07T15:39:55Z")

</div>

This 👆 👆 👆 👆

Spot on advice and excellent example! Thanks @tatiang

Sorry for such a short response if there I responded while I took a quick break from mowing my lawn 😂

[Next page](https://community.thunkable.com/t/how-to-extract-info-from-this-json/499882.md?page=2)