How to fetch JSON , JProperty and Jobject from JSON

Help Activities
1

Hello friend
I am reading a JSON for my learning purpose only

I am trying to Read Json Property, in this JOSN have three-property , I want to make a loop or input dialog box select any currency ,

Could you please suggest

{

"time": {

    "updated": "May 9, 2022 08:25:00 UTC",

    "updatedISO": "2022-05-09T08:25:00+00:00",

    "updateduk": "May 9, 2022 at 09:25 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",

"chartName": "Bitcoin",

"bpi": {

    "USD": {

        "code": "USD",

        "symbol": "$",

        "rate": "33,311.4113",

        "description": "United States Dollar",

        "rate_float": 33311.4113

    },

    "GBP": {

        "code": "GBP",

        "symbol": "£",

        "rate": "27,109.1263",

        "description": "British Pound Sterling",

        "rate_float": 27109.1263

    },

    "EUR": {

        "code": "EUR",

        "symbol": "€",

        "rate": "31,689.0790",

        "description": "Euro",

        "rate_float": 31689.079

    }

}

}

image
image1233×684 38.4 KB

1 Like
2

Hello @JSR_Techno_Talk_s ,

Here if you want to pass the currency dynamically, you can create an array with all the currency or you can add all the currency to Excel and then read it. The you can loop though it and pass the value to the JSONOUTPUT

3

Hey @JSR_Techno_Talk_s

Could you please explain a bit more ?

Thanks
#nK

4

More Details :

In this JSON, three currencies are there

  • USD
  • GBP
  • EUR
    Maybe in the future, they are more, so I want to track it dynamically.

I have seen that JPoperty contain the information, I want to handle it

image

5

for the dropdown we can get the currency string array within a oneliner:

grafik
grafik542×765 93.9 KB

3 Likes
6

Thanks Same I was looking