Help with Json file please

🚧 Developers Coding Questions
1

Ok, so I have at least 4 apps already that read json files but I've never seen one like this! There are spaces in the names and special characters.

Could I get an example of how to read this file?

ie. How do I get ...
close = "Time Series (Daily)"."2020-07-31". "4. close"

so Close would equal '122.9400'

Thanks!

{
    "Meta Data": {
        "1. Information": "Daily Prices (open, high, low, close) and Volumes",
        "2. Symbol": "IBM",
        "3. Last Refreshed": "2020-07-31",
        "4. Output Size": "Compact",
        "5. Time Zone": "US/Eastern"
    },
    "Time Series (Daily)": {
        "2020-07-31": {
            "1. open": "122.7100",
            "2. high": "122.9900",
            "3. low": "121.0900",
            "4. close": "122.9400",
            "5. volume": "5277652"
        },
        "2020-07-30": {
            "1. open": "123.7100",
            "2. high": "123.9046",
            "3. low": "121.6400",
            "4. close": "122.9000",
            "5. volume": "3988062"
        },
ect...
1 Like
2

Does it work when you use brackets like described here? https://stackoverflow.com/a/50738382

There are several useful examples in that same thread.

2 Likes
3

Wow, great link! Thank you, time to learn something new :wink:

2 Likes
4

Is that the alphavantage API? They had the strangest formatted JSON I've ever worked with: structurally along with the keys used.

5

Sure is. API Documentation | Alpha Vantage

Making my head hurt. :roll_eyes: