# How to extract text from this JSON?

**URL:** https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415
**Category:** Questions about Thunkable X
**Tags:** webapi
**Created:** [August 21, 2018, 9:51am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415 "2018-08-21T09:51:54Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Team\_Jaden](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@Team\_Jaden](https://community.thunkable.com/u/Team_Jaden)
#### Post date: [August 21, 2018, 9:51am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/1 "2018-08-21T09:51:54Z")

</div>

I got this JSON response from an API GET request

> `{“time”:{“updated”:“Aug 21, 2018 09:12:00 UTC”,“updatedISO”:“2018-08-21T09:12:00+00:00”,“updateduk”:“Aug 21, 2018 at 10:12 BST”},“disclaimer”:“This data was produced from the CoinDesk Bitcoin Price Index (USD). Non-USD currency data converted using hourly conversion rate from [openexchangerates.org](http://openexchangerates.org)”,“chartName”:“Bitcoin”,“bpi”:{“USD”:{“code”:“USD”,“symbol”:“$”,“rate”:“6,455.0650”,“description”:“United States Dollar”,“rate\_float”:6455.065},“GBP”:{“code”:“GBP”,“symbol”:“£”,“rate”:“5,030.5354”,“description”:“British Pound Sterling”,“rate\_float”:5030.5354},“EUR”:{“code”:“EUR”,“symbol”:“€”,“rate”:“5,596.8964”,“description”:“Euro”,“rate\_float”:5596.8964}}}

How can i extract the value i want?  
For example i want to extract “Euro” “rate\_float” value

---

<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: [August 21, 2018, 10:39am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/2 "2018-08-21T10:39:52Z")

</div>

This was often discussed in the forum, for example

[Get data(street name) from geocoder google api](http://community.thunkable.com/t/get-data-street-name-from-geocoder-google-api/36352)

---

<div class="post-metadata">

### Author: ![Team\_Jaden](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@Team\_Jaden](https://community.thunkable.com/u/Team_Jaden)
#### Post date: [August 21, 2018, 11:07am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/3 "2018-08-21T11:07:03Z")

</div>

I think this is correct , but nothing happens. Label doesn’t change text

[[Album] Imgur ![](https://i.imgur.com/kl6AvDp.jpg?fb "Imgur") ](https://imgur.com/a/gJKyiFW)

---

<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: [August 21, 2018, 11:27am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/4 "2018-08-21T11:27:49Z")

</div>

No, the blocks are wrong. You need to figure out how to work with JSON. First, open the top object and look at its contents, then the next object, etc. Working with json is similar to cabbage: first to get about the stump, you must first tear off the topmost cabbage leave, then the cabbage leave under it, then the next cabbage leave, etc.

---

<div class="post-metadata">

### Author: ![Team\_Jaden](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@Team\_Jaden](https://community.thunkable.com/u/Team_Jaden)
#### Post date: [August 21, 2018, 11:51am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/5 "2018-08-21T11:51:11Z")

</div>

I formatted JSON text like this:

> {  
> “time”:{  
> “updated”:“Aug 21, 2018 11:41:00 UTC”,  
> “updatedISO”:“2018-08-21T11:41:00+00:00”,  
> “updateduk”:“Aug 21, 2018 at 12:41 BST”  
> },  
> “disclaimer”:“This data was produced from the CoinDesk Bitcoin Price Index (USD). Non-USD currency data converted using hourly conversion rate from [openexchangerates.org](http://openexchangerates.org)”,  
> “chartName”:“Bitcoin”,  
> “bpi”:{  
> “USD”:{  
> “code”:“USD”,  
> “symbol”:“$”,  
> “rate”:“6,432.7550”,  
> “description”:“United States Dollar”,  
> “rate\_float”:6432.755  
> },  
> “GBP”:{  
> “code”:“GBP”,  
> “symbol”:“£”,  
> “rate”:“5,012.5506”,  
> “description”:“British Pound Sterling”,  
> “rate\_float”:5012.5506  
> },  
> “EUR”:{  
> “code”:“EUR”,  
> “symbol”:“€”,  
> “rate”:“5,583.0138”,  
> “description”:“Euro”,  
> “rate\_float”:5583.0138  
> }  
> }  
> }

and I modified the blocks like this:  
[![Imgur](https://i.imgur.com/NREocsc.png "imgur.com") ](https://imgur.com/NREocsc)

but also this time nothing happens in the app, text doesn’t change

---

<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: [August 21, 2018, 12:38pm UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/6 "2018-08-21T12:38:10Z")

</div>

You are trying to solve the problem from the very end so nothing happens.

How do you want to solve a problem with a chain of 5-6 blocks, if you do not understand how the 1 block works?

First, make a block to get the contents of the node “time”. If this is obtained, then make a block to get the node “updated” - “Aug 21, 2018 11:41:00 UTC”. Then get the value of the block “USD”. If you do this, you will immediately understand how everything works.

---

<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: [August 21, 2018, 12:44pm UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/7 "2018-08-21T12:44:56Z")

</div>

![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/f/5ff536cadc24f92cd7f3fabca7698113643ab355.png)

---

<div class="post-metadata">

### Author: ![Alan](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@Alan](https://community.thunkable.com/u/Alan)
#### Post date: [September 30, 2018, 6:02pm UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/8 "2018-09-30T18:02:08Z")

</div>

Hi Actech, how do i get the photo reference when Im able to get the name of the place but not the photo reference using the method of the following blocks?? what json path am i missing?? please see my project link also in your messages.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/6/167cb8756c91562f148a066b1c44ea67233eead4.png)

---

<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, 11:55am UTC](https://community.thunkable.com/t/how-to-extract-text-from-this-json/42415/9 "2024-11-08T11:55:20Z")

</div>


