Struggling to bind API JSON to chart axis

1

I have a simple API returning stock market values
I am tring to bind the date vale on the horizontal axis and the just the 1. open values, ideally I would like a multi-data set, but for some reason I am not getting the bar chart to visualise the values

https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=IBM&apikey=demo

"Monthly Time Series": {
    "2020-07-24": {
        "1. open": "120.2700",
        "2. high": "132.1700",
        "3. low": "115.2000",
        "4. close": "125.7900",
        "5. volume": "93962414"
    },
    "2020-06-30": {
        "1. open": "124.6400",
        "2. high": "135.8800",
        "3. low": "115.8800",
        "4. close": "120.7700",
        "5. volume": "120928981"
    },
    "2020-05-29": {
        "1. open": "123.1900",
        "2. high": "126.9700",
        "3. low": "111.8100",
        "4. close": "124.9000",
        "5. volume": "92864791"
    },

Could someone check that they can get a chart to render with this.

Thanks.

2

Any help would be appreciated.
Even if its to advise you can plot these values.

Thanks

3

If someone could spare a couple of minutes and try binding this to a chart and let me know if successful, that would really help

4

Had some problems with the dataset using the UI, but was able to get a chart with the following code.

<dmx-chart id="chart1" responsive="true" legend="right"
  labels="$value" dmx-bind:data="api1.data['Monthly Time Series'].keys()"
  dataset-1:label="open" dataset-1:value="api1.data['Monthly Time Series'][$value]['1. open']"
  dataset-2:label="high" dataset-2:value="api1.data['Monthly Time Series'][$value]['2. high']"
  dataset-3:label="low" dataset-3:value="api1.data['Monthly Time Series'][$value]['3. low']"
  dataset-4:label="close" dataset-4:value="api1.data['Monthly Time Series'][$value]['4. close']">
</dmx-chart>

chart looks like

image
image1104×842 129 KB

1 Like
5

Fantastic, thank you @patrick
Very much appreciated