Ways to extract data from a JSON object

Question

Ways to extract data from a JSON object

When using my web application, the Web API responds with the following JSON object:

[ 
   { 
      "templateID":1,
      "template":"{\r\n  \"Body\": \"sample date hete hee. Name\"\r\n}"
   },
   { 
      "templateID":2,
      "template":"{ \"Body\": \"you soon.\" }"
   }
]

My task is to extract the Body value from each JSON node by providing the corresponding templateID. The challenge lies in the presence of \r\n characters within the JSON data. Regardless, I must retrieve the Body value for each node. For instance, if I input 1, I should receive sample date hete hee. Name, and for 2, I require you soon.. How can this be achieved?

I have attempted a solution, but it does not seem to work as expected.

var data2 = [ 
   { 
      "templateID":1,
      "template":"{\r\n  \"Body\": \"sample date hete hee. Name\"\r\n}"
   },
   { 
      "templateID":2,
      "template":"{ \"Body\": \"you soon.\" }"
   }
]

function usersBasedOnIDs(isShow,field){

    var filtered=data2.filter(function(item){
        return item[field] == isShow;         
    });
    console.log(filtered);
}

usersBasedOnIDs(1,'templateID');

javascript arrays json regex replace

Answer 1

Answer №1

item[field] == isShow;

You're lacking an object that meets this condition, it appears you wish to filter elements based on ID and then examine their body value.

var data2 = [{
    "templateID": 1,
    "template": "{\r\n  \"Body\": \"sample date hete hee. Name\"\r\n}"
  },
  {
    "templateID": 2,
    "template": "{ \"Body\": \"you soon.\" }"
  }
]

function fetchUsersBasedOnIDs(isShow, field) {

  var filteredData = data2.filter(function(item) {
    return item[field] == isShow;
  });
  console.log(filteredData && JSON.parse(filteredData[0].template).Body);
}

fetchUsersBasedOnIDs(1, 'templateID');

Answer 2

item[field] == isShow;

You're lacking an object that meets this condition, it appears you wish to filter elements based on ID and then examine their body value.

var data2 = [{
    "templateID": 1,
    "template": "{\r\n  \"Body\": \"sample date hete hee. Name\"\r\n}"
  },
  {
    "templateID": 2,
    "template": "{ \"Body\": \"you soon.\" }"
  }
]

function fetchUsersBasedOnIDs(isShow, field) {

  var filteredData = data2.filter(function(item) {
    return item[field] == isShow;
  });
  console.log(filteredData && JSON.parse(filteredData[0].template).Body);
}

fetchUsersBasedOnIDs(1, 'templateID');

Answer 3

Answer №2

To discover the solution, you can follow these instructions:

let array = [ 
   { 
      "number":1,
      "content":"{\r\n  \"Body\": \"Enter sample text here. Name\"\r\n}"
   },
   { 
      "number":2,
      "content":"{ \"Body\": \"Expect a response soon.\" }"
   }
]
for(let i=0;i<array.length;i++){
  let item = array[i].content;
  console.log(JSON.parse(item).Body);
}

Answer 4

To discover the solution, you can follow these instructions:

let array = [ 
   { 
      "number":1,
      "content":"{\r\n  \"Body\": \"Enter sample text here. Name\"\r\n}"
   },
   { 
      "number":2,
      "content":"{ \"Body\": \"Expect a response soon.\" }"
   }
]
for(let i=0;i<array.length;i++){
  let item = array[i].content;
  console.log(JSON.parse(item).Body);
}

Answer 5

Answer №3

function retrieveUsersByTemplateID(templateID) {
    let foundUser = data2.find(function(user) {
        return user.templateId === templateID;
    });
    if(foundUser === undefined) {
        return;
    } else {
        return JSON.parse(foundUser.template).Body;
    }
}

console.log(retrieveUsersByTemplateID(1));

Answer 6

function retrieveUsersByTemplateID(templateID) {
    let foundUser = data2.find(function(user) {
        return user.templateId === templateID;
    });
    if(foundUser === undefined) {
        return;
    } else {
        return JSON.parse(foundUser.template).Body;
    }
}

console.log(retrieveUsersByTemplateID(1));

Ways to extract data from a JSON object

Answer №1

Answer №2

Answer №3

Similar questions

Sending data through props to components that can only be accessed through specific routes

Understanding the scope within a .when .done function in jQuery

When executing a Javascript POST request to a PHP script, it succeeds when running on

Error encountered while parsing JSON data for a particular string

Webpack fails to resolve paths provided by a JavaScript variable

What is the best way to target the nth-child() of a slotted element within a web component that utilizes multiple uniquely named slots?

Expanding size on hover without affecting the alignment of surrounding elements

using a ternary operator within the map function

Tips for achieving equivalent value from two separate arrays with the help of Lodash

Using jQuery to animate a div within a PHP echo statement

JQuery WCF Service is returning a 400 Bad Request response

Retrieve main page elements from an additional page called PageSlide

Here's the step-by-step process: Access the specific item in the object by referencing `obj[i]["name of desired attribute"]

Is it possible to transfer data from a JavaScript file to the Express server without relying on a form submission?

The React context is currently yielding an undefined value

Ionic ion-view missing title issue

Mocking objects in unit test cases to simulate real-life scenarios and test the

Managing arrays effectively within ngrx store

How can I utilize JSON data to retrieve information using D3 library?

Automatically Assigning a Default Value to a Column Using SEQUELIZE ORM