Parsing and getting data from JSON

Question

I have a json from site https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=MSFT&outputsize=full&apikey=demo

It looks like

{
"Meta Data": {
    "1. Information": "Daily Prices (open, high, low, close) and Volumes",
    "2. Symbol": "MSFT",
    "3. Last Refreshed": "2018-07-03",
    "4. Output Size": "Full size",
    "5. Time Zone": "US/Eastern"
},
"Time Series (Daily)": {
    "2018-07-03": {
        "1. open": "100.4800",
        "2. high": "100.6300",
        "3. low": "98.9400",
        "4. close": "99.0500",
        "5. volume": "14670275"
    },
    "2018-07-02": {
        "1. open": "98.1000",
        "2. high": "100.0600",
        "3. low": "98.0000",
        "4. close": "100.0100",
        "5. volume": "19564521"
    }
}
}

You can see in "Time Series (Daily)" there are different date objects. I want to access all the keys in each date and want to put data in array. I am using javascript and have no idea how to iterate through these different dates.

        console.log(data['TimeSeries (Daily)']['2018-07-03']);

This is how i accessed date, but this is single date i want to iterate through each.

Possible duplicate of [Iterate through object properties](https://stackoverflow.com/questions/8312459/iterate-through-object-properties) — , Jul 04 '18 at 15:23

Nick Tomlin · Answer 1 · 2018-07-04T15:16:25.513

1

If you are using a modern JavaScript engine, or a transpiler like babel this is cleanly done with Object.values and Object.entries:

Object.values(myData["Time Series (Daily)"]).forEach(function (date) {
  Object.entries(date).forEach(function([period, value]) {
    console.log(period, ':', value);
  })
})

This would log the following in your console:

1. open : 100.4800
2. high : 100.6300
3. low : 98.9400
// ....

jsfiddle

edited Jul 04 '18 at 15:16

answered Jul 04 '18 at 15:10

Nick Tomlin

28,402
11
61
90

How I will populate array from this, like I want to basically draw chart, (candlestick) which accepts data like this. `[ ['Mon', 20, 28, 38, 45], ['Tue', 31, 38, 55, 66], ['Wed', 50, 55, 77, 80], ['Thu', 77, 77, 66, 50], ['Fri', 68, 66, 22, 15] ]` – curious_nustian Jul 04 '18 at 15:38

Mihir Dave · Accepted Answer · 2018-07-04T16:13:20.910

1

This will give you the output you want

var tSeries=data['Time Series (Daily)'];
for(var tempData in tSeries)
{   
    console.log(tSeries[tempData]);
    console.log(tSeries[tempData]['1. open']);
    console.log(tSeries[tempData]['2. high']);
}

Update

If you need to access dates and wants them in separate Array

var tempDataStore = [];
var tSeries=data['Time Series (Daily)'];
for(var tempData in tSeries)
{   
    // Here You get your Date
    console.log("Your Date - " + tempData);
    console.log(tSeries[tempData]);
    console.log(tSeries[tempData]['1. open']);
    console.log(tSeries[tempData]['2. high']);
    tempDataStore.push({"Date":tempData,"open":tSeries[tempData]['1. open']})
}

console.log(tempDataStore)

edited Jul 04 '18 at 16:13

answered Jul 04 '18 at 15:28

Mihir Dave

3,954
1
12
28

Awesome, Upvoted, one more thing can we access dates (e.g 2018-07-02) in body of loop? acctually I want to put all data (date, open,high,low,close) in array for each object. – curious_nustian Jul 04 '18 at 16:03
@curious_nustian please check updated answer is it something you want? – Mihir Dave Jul 04 '18 at 16:13

score 0 · Answer 3 · answered Jul 04 '18 at 15:04

0

Loop through the keys of the "TimeSeries (Daily)" object. For example,

for(date in obj) {
    console.log(obj[date]);
}

To access the data in each date, just add another loop.

answered Jul 04 '18 at 15:04

Hyrial

1,728
3
15
27

can you elaborate first line pls? d = data['TimeSeries (Daily)']; you mean this? – curious_nustian Jul 04 '18 at 15:14
Yup, `let date in data['TimeSeries (Daily)']` – Hyrial Jul 04 '18 at 15:15

score 0 · Answer 4 · edited Jul 04 '18 at 15:34

0

You could use a for in loop to get desired output

let myList = data['TimeSeries (Daily)'];
for (var index in myList) 
{
    console.log(myList[index]);
}

Regards

edited Jul 04 '18 at 15:34

Mihir Dave

3,954
1
12
28

answered Jul 04 '18 at 15:04

Alexandre Keller

61
6

Wrong.! code.. correct this line console.log(myList[index]); – Mihir Dave Jul 04 '18 at 15:07

score 0 · Answer 5 · answered Jul 04 '18 at 15:18

IMHO, this is what you are looking for:

data = {
"Meta Data": {
    "1. Information": "Daily Prices (open, high, low, close) and Volumes",
    "2. Symbol": "MSFT",
    "3. Last Refreshed": "2018-07-03",
    "4. Output Size": "Full size",
    "5. Time Zone": "US/Eastern"
},
"Time Series (Daily)": {
    "2018-07-03": {
        "1. open": "100.4800",
        "2. high": "100.6300",
        "3. low": "98.9400",
        "4. close": "99.0500",
        "5. volume": "14670275"
    },
    "2018-07-02": {
        "1. open": "98.1000",
        "2. high": "100.0600",
        "3. low": "98.0000",
        "4. close": "100.0100",
        "5. volume": "19564521"
    }
}
}


Object.keys(data["Time Series (Daily)"]).forEach(date => console.log(date))

karthik · Answer 6 · 2018-07-04T16:05:46.263

0

Here is easiest way to do this...

const response = await fetch('https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=MSFT&outputsize=full&apikey=demo');
const responseData = await response.json();
let allTimeStamps = [];
let allTimeStampsData = [];
for(let key in responseData["Time Series (Daily)"]){
    allTimeStamps.push(key);
    allTimeStampsData.push(responseData["Time Series (Daily)"][key]);
}
console.log("seperatedData", {allTimeStamps, allTimeStampsData});

try in the same domain to prevent cross-origin issue

edited Jul 04 '18 at 16:05

answered Jul 04 '18 at 15:31

karthik

1,100
9
21

@curious_nustian My bad havent noticed that last line Please find the updated edit – karthik Jul 04 '18 at 16:06

Parsing and getting data from JSON

6 Answers6

Linked