Looping through JSON using Node.js

Question

I am trying to loop through JSON using Node so that I can call a stored procedure in a sql database. the JSON is:

[ { boardid: '1', accesid: '2' },
  { boardid: '2', accesid: '3' },
  { boardid: '8', accesid: '4' } ]

the pseudo code i want to implement is: (I have the UserID)

var data = req.body.addJSON

for each JSON object {
    con.query(
        "CALL addUserToBoard('" + UserID + "', '" + BoardID + "','" + AccessTypeID + "');",
        function(err, result, fields) {
            if (err) throw err;
        }
    );
}

What is it you are asking? Please tell us what issues you are running into and what you have tried so far — Mazzy
– Mazzy, Commented Feb 8, 2018 at 15:33

Alvaro · Accepted Answer · 2020-01-19 06:14:51Z

1

You can always interate in an Object a follows

var jsonresponse = JSON.parse(data);
Object.keys(jsonresponse).forEach( function(param , index) {
    console.log(jsonresponse[param]);
    console.log(index);
});

answered Jan 19, 2020 at 6:14

Alvaro

6516 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Skyler · Accepted Answer · 2018-02-08 15:07:13Z

0

You could do this using a simple forEach,

var data = req.body.addJSON


data.forEach(value => {
    con.query("CALL addUserToBoard('" + UserID + "', '" + value.boardid + "','" + value.accesid + "');", function (err, result, fields) 
    {
        if (err) throw err;
    }); 
})

answered Feb 8, 2018 at 15:07

Skyler

6565 silver badges14 bronze badges

1 Comment

Skyler Over a year ago

No problem. Please accept the answer as correct if it works for you.

Collectives™ on Stack Overflow

Looping through JSON using Node.js

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related