Instructions on extracting particular elements from a JSON document and converting them into an array

Question

Instructions on extracting particular elements from a JSON document and converting them into an array

Here is a JSON array that I am working with:

{
  "data": [
    {
      "id": 6,
      "pnome": "dasda",
      "unome": "dad",
      "avatar": 1,
      "email": "d",
      "pass": "password",
      "ponto": 0
    },
    {
      "id": 3,
      "pnome": "Enguias",
      "unome": "Enguias outra vez",
      "avatar": 10,
      "email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="4c29222b39252d3f0c29222b39252d3f6229222b39252d3f">[email protected]</a>",
      "pass": "enguias",
      "ponto": 0
    },
    {
      "id": 2,
      "pnome": "André",
      "unome": "Marques",
      "avatar": 1,
      "email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="4627212a2b273437332306212b272f2a6825292b">[email protected]</a>",
      "pass": "yet1",
      "ponto": 0
    }
  ]
}

I then use Axios to put the JSON data into an array in my code:

axios.get(my_url_api)
.then((res)=>{
const txt = JSON.stringify(res.data.data);
const users = JSON.parse(txt)
})

My goal now is to extract specific attributes like email and pass from the users array. This is how I want it to be displayed:

{
  "data": [
    {
      "email": "d",
      "pass": "password"
    },
    {
      "email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="bfdad1d8cad6deccffdad1d8cad6decc91dad1d8cad6decc">[email protected]</a>",
      "pass": "enguias"
    },
    {
      "email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="f697919a9b9784878393b6919b979f9ad895999b">[email protected]</a>",
      "pass": "yet1"
    }
  ]
}

javascript arrays json javascript-objects

Answer 1

Answer №1

To simplify the data and remove unnecessary fields, you can utilize the Array.map() function as shown in the example below:

let data = {
"info": [
{
"id": 6,
"name": "John",
"lastname": "Doe",
"avatar": 1,
"email": "john.doe@example.com",
"password": "securepass",
"points": 0
},
{
"id": 3,
"name": "Jane",
"lastname": "Smith",
"avatar": 10,
"email": "jane.smith@example.com",
"password": "janepass",
"points": 0
},
{
"id": 2,
"name": "Alice",
"lastname": "Jones",
"avatar": 1,
"email": "alice.jones@example.com",
"password": "alicepass",
"points": 0
}
]
}

data.info = data.info.map(item => {
    return {
        email: item.email,
        password: item.password
    };
});

console.log(data);

Answer 2

To simplify the data and remove unnecessary fields, you can utilize the Array.map() function as shown in the example below:

let data = {
"info": [
{
"id": 6,
"name": "John",
"lastname": "Doe",
"avatar": 1,
"email": "john.doe@example.com",
"password": "securepass",
"points": 0
},
{
"id": 3,
"name": "Jane",
"lastname": "Smith",
"avatar": 10,
"email": "jane.smith@example.com",
"password": "janepass",
"points": 0
},
{
"id": 2,
"name": "Alice",
"lastname": "Jones",
"avatar": 1,
"email": "alice.jones@example.com",
"password": "alicepass",
"points": 0
}
]
}

data.info = data.info.map(item => {
    return {
        email: item.email,
        password: item.password
    };
});

console.log(data);

Instructions on extracting particular elements from a JSON document and converting them into an array

Answer №1

Similar questions

What is the best way to create a JSON object for sending it through a POST API in Swift 3?

The command "electron-rebuild" returns an error message stating, "No Electron application found."

JavaScript can switch the rendering mode from quirks mode to standard mode in Internet Explorer

How come the information isn't being transferred between components?

How can I extract information from an HTML element using its ID in JavaScript?

Passing variables in Node.js: passing a variable to a module versus passing a variable to each individual

What is the best way to add a listener for a modification of innerHTML within a <span>?

What is the best approach to resolving the MongoServerError: E11000 duplicate key error?

Managing two different responses in Retrofit can be done effectively by creating separate models for

The Google Chart Api utilizes datetime values to enhance data visualization

Performing AJAX requests to interact with another PHP file without navigating away from the current page

Unexpected additional character found in json_encode output

Is it a mongoDB issue or a backend server issue if the Express Server can only GET requests and not POST?

Tips for maintaining the original ng-click initialized value as the ng-init value after the page is refreshed

Using JSON to transmit image data stored locally

Fetching JSON data cross-domain with the help of JavaScript or JQuery

After generating the token, where is the appropriate place to define the authorization header?

Validation for an empty string in the value of an input element

Is there a way to verify if a user navigated to a specific route or URL using the back button?

Submit the form with an input value that is located outside of the form