How to retrieve the latest value from a nested object using JavaScript in JSON

Question

How to retrieve the latest value from a nested object using JavaScript in JSON

I am attempting to access the most recent element in the Time Series (5 min) object without specifying the date/time after running this JavaScript code:

var getStock = new XMLHttpRequest();
getStock.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStock.send(null);

var current_stock = JSON.parse(getStock.responseText);
console.log(current_stock);
var current_stock_price = current_stock["Time Series (5min)"][0]["4. close"];

In this instance (refer to screenshot), I am looking at Time Series (5 min) > 2022-04-21 20:00:00 -> 4. close, but I am encountering an undefined error.

Even when trying it in the developer console with the complete JSON file, using

current_stock["Time Series (5 min)"]

displays all child values in the console. However, appending [0] or

["2022-04-21 20:00:00"]

at the end results in an undefined error.

https://i.sstatic.net/DRVVn.png

javascript json

Answer 1

Answer №1

To retrieve the information, simply follow these steps:

let fetchStock = new XMLHttpRequest();
fetchStock.open("GET", "https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
fetchStock.send(null);
let stockData = JSON.parse(fetchStock.responseText);

const timeSeries = stockData['Time Series (5min)'];
const key = Object.keys(timeSeries)[0];
console.log(timeSeries[key]['4. close']);

Answer 2

To retrieve the information, simply follow these steps:

let fetchStock = new XMLHttpRequest();
fetchStock.open("GET", "https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
fetchStock.send(null);
let stockData = JSON.parse(fetchStock.responseText);

const timeSeries = stockData['Time Series (5min)'];
const key = Object.keys(timeSeries)[0];
console.log(timeSeries[key]['4. close']);

Answer 3

Answer №2

The reason for the unavailability of the 0 index in current_stock["Time Series (5min)"] is because it is an object, not an array. If you wish to retrieve the first item from current_stock["Time Series (5min)"], you can follow these steps:

var getStockData = new XMLHttpRequest();
getStockData.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStockData.send(null);

var current_stock = JSON.parse(getStockData.responseText);
console.log(current_stock);
var keysList = Object.keys(current_stock["Time Series (5min)"]); // retrieve all keys in current_stock["Time Series (5min)"] object
console.log(keysList); // keysList is an array, so you can access the first item as keysList[0]
var current_stock_price = current_stock["Time Series (5min)"][keysList[0]]["4. close"];

Answer 4

The reason for the unavailability of the 0 index in current_stock["Time Series (5min)"] is because it is an object, not an array. If you wish to retrieve the first item from current_stock["Time Series (5min)"], you can follow these steps:

var getStockData = new XMLHttpRequest();
getStockData.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStockData.send(null);

var current_stock = JSON.parse(getStockData.responseText);
console.log(current_stock);
var keysList = Object.keys(current_stock["Time Series (5min)"]); // retrieve all keys in current_stock["Time Series (5min)"] object
console.log(keysList); // keysList is an array, so you can access the first item as keysList[0]
var current_stock_price = current_stock["Time Series (5min)"][keysList[0]]["4. close"];

Answer 5

Answer №3

Following your suggestion to change [0] to ["2022-04-21 20:00:00"], the code functions perfectly. The revised code snippet is as follows:

var getStock = new XMLHttpRequest();
getStock.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStock.send(null);

var current_stock = JSON.parse(getStock.responseText);
var current_stock_price = current_stock["Time Series (5min)"]["2022-04-21 20:00:00"]["4. close"];
console.log(current_stock_price)

If you prefer not to use keys, you can utilize Object.values() to retrieve the data:

var getStock = new XMLHttpRequest();
getStock.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStock.send(null);

var current_stock = JSON.parse(getStock.responseText);
var current_stock_price = Object.values(current_stock["Time Series (5min)"])[0]["4. close"];
console.log(current_stock_price)

This approach will fetch the most recent entry.

Answer 6

Following your suggestion to change [0] to ["2022-04-21 20:00:00"], the code functions perfectly. The revised code snippet is as follows:

var getStock = new XMLHttpRequest();
getStock.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStock.send(null);

var current_stock = JSON.parse(getStock.responseText);
var current_stock_price = current_stock["Time Series (5min)"]["2022-04-21 20:00:00"]["4. close"];
console.log(current_stock_price)

If you prefer not to use keys, you can utilize Object.values() to retrieve the data:

var getStock = new XMLHttpRequest();
getStock.open("GET","https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=IBM&interval=5min&apikey=demo", false);
getStock.send(null);

var current_stock = JSON.parse(getStock.responseText);
var current_stock_price = Object.values(current_stock["Time Series (5min)"])[0]["4. close"];
console.log(current_stock_price)

This approach will fetch the most recent entry.

Answer 7

Answer №4

The issue arises from attempting to treat an object like an array.

current_stock["Time Series (5min)"]["2022-04-21 20:00:00"]["4. close"]

is the proper way to access the desired value in your code example.

To address your question about looping through this structure, you will need to convert the object into an array.

An effective method is utilizing Object.entries(), as shown below:

stock_date_prices = Object.entries(current_stock['Time Series (5min)'])

for (const [datetime, prices] in stock_date_prices) {
  console.log("The closing price at %s was %s", datetime, prices['4. close'])
}

If you require a more comprehensive explanation on looping through JavaScript objects, please refer to this advise on Stack Overflow.

Answer 8

The issue arises from attempting to treat an object like an array.

current_stock["Time Series (5min)"]["2022-04-21 20:00:00"]["4. close"]

is the proper way to access the desired value in your code example.

To address your question about looping through this structure, you will need to convert the object into an array.

An effective method is utilizing Object.entries(), as shown below:

stock_date_prices = Object.entries(current_stock['Time Series (5min)'])

for (const [datetime, prices] in stock_date_prices) {
  console.log("The closing price at %s was %s", datetime, prices['4. close'])
}

If you require a more comprehensive explanation on looping through JavaScript objects, please refer to this advise on Stack Overflow.

How to retrieve the latest value from a nested object using JavaScript in JSON

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Is it possible to limit the values of parameters with react-router?

Unlimited scrolling feature on a pre-filled div container

Struggling to retrieve a class within an <a> element in jsTree when hovering?

Tips for executing an asynchronous fetch prior to the first rendering

What is the method for calculating the difference in days between two Jalali dates when selecting the second date picker input?

The $watch function is triggered even when the expression remains unchanged

The information does not display in the AngularJS-generated table

Encountered an issue while trying to retrieve a value from an object within a

Basic $http.get request including parameters

Integrating Gesture Handling in Leaflet JS for two-finger scrolling enforcement

Using the Protractor tool to close a window popup

In the callback function within Array.prototype.map, make sure to access the newly created array

Change the selection box to a checkbox

Retrieving data from controllers and passing it to directives in Angular applications

List out IP addresses in JavaScript

The initial render in a Kanban board seems to be causing issues with the functionality of react-beautiful-dnd

How to implement file uploading with Node.js and Angular using the formidable module

Determine if an Android application has been installed using JavaScript or jQuery

Warning: HTML input values are being cleared when added

What is the best way to incorporate multiple list views within a single list view?