Using Javascript to Extract Data from a JSON Array

Question

Using Javascript to Extract Data from a JSON Array

I am working with a straightforward Json array and need to retrieve the following:

The total number of items in the array.
The list of entries ordered by id.

Below is an example of the array:

{"error":false,"error_msg":"","body":
{"records":[{"name":"Application","id":1},
            {"name":"Fees Paid","id":2},
            {"name":"Evidence Verification","id":3},
            {"name":"Details QA","id":4},
            {"name":"Grade Approval","id":5},
            {"name":"Welcome Pack","id":6}]
},
"validation_errors":[]}

javascript ajax arrays json

Answer 1

Answer №1

If you have already used JSON.parse to convert your string into a variable named jsonobj, the code below will help you extract the desired data:

var len = jsonobj.body.records.length;
jsonobj.body.records.sort(function(a,b) {return a.id-b.id;});
// loop through jsonobj.body.records to access them in ascending order based on ID

Answer 2

If you have already used JSON.parse to convert your string into a variable named jsonobj, the code below will help you extract the desired data:

var len = jsonobj.body.records.length;
jsonobj.body.records.sort(function(a,b) {return a.id-b.id;});
// loop through jsonobj.body.records to access them in ascending order based on ID

Answer 3

Answer №2

If you have an Item stored in the variable jItem, create copies of the List/Items to preserve the originals, use the arrange function as necessary, and then produce a new List containing only the title components.

jItem['body']['entries']
    .map(function (item) {return {'id': item['id'], 'title': item['title']};}) // make duplicates
    .sort(function (x, y) {return +x['id'] - +y['id'];})                        // arrange in ascending order
    .map(function (item) {return item['title'];});                               // retrieve titles
/* [
    "First Task", "Second Task",      "Important Note",
    "Key Point",  "Final Step",       "Welcome Message"
] */

Answer 4

If you have an Item stored in the variable jItem, create copies of the List/Items to preserve the originals, use the arrange function as necessary, and then produce a new List containing only the title components.

jItem['body']['entries']
    .map(function (item) {return {'id': item['id'], 'title': item['title']};}) // make duplicates
    .sort(function (x, y) {return +x['id'] - +y['id'];})                        // arrange in ascending order
    .map(function (item) {return item['title'];});                               // retrieve titles
/* [
    "First Task", "Second Task",      "Important Note",
    "Key Point",  "Final Step",       "Welcome Message"
] */

Using Javascript to Extract Data from a JSON Array

Answer №1

Answer №2

Similar questions

Determining control points within the getBBox() method for SVG paths on Safari and Chrome

Tips for implementing focusout on multiple elements while avoiding it when switching focus between them

An unanticipated error has occurred: FormatException:

Using Node.js to extract information from a web application that necessitates logging in

Combining an array of hashes into a single hash in Ruby

Issue with Jquery load() function: unable to retrieve body class

Harness the power of asynchronous programming by incorporating the async await method within

What is the proper way to invoke a child method after converting an object from a parent class to a child class?

Exporting a VueJS webpage to save as an HTML file on your computer

Printing only JSON data with the key "Available" in Python

In certain cases, codeigniter may not receive a response from the database

Unable to display elements from an array in the dropdown menu generated by v-for

Dynamic Bootstrap Modal for Enhanced User Experience

Error: The JSON response does not contain a value for employeeLst

Seeking guidance on implementing toggle buttons for navigation bar items on mobile screens, enabling them to toggle for a dropdown menu. The tools at my disposal are HTML, CSS

Ways to combine two arrays using dual requests in JavaScript with Mailchimp

To ensure that quotes are correctly handled in a string being passed to a JavaScript function within an `onclick`

Issue with event handling when using the `this` keyword in function

Swapping out images with a different image using angular.js

Is there a way for my discord bot to notify me when a certain user is playing a particular game?