Javascript(NodeJs) - Conversion of Arrays and Objects to bulk insert in mysql(Sequelize)

Question

This is my json:

{
    "senderName": "ifelse",
    "message": "Hi",
    "groups": [
    {
        "id": 14,
        "groupname": "Angular",
        "contactgroups": [
        {
            "id": 1,
            "contact": {
                "id": 1,
                "gsm": "123456789"
            }
        },
        {
            "id": 3,
            "contact": {
                "id": 2,
                "gsm": "111111111"
            }
        }],
        "select": true
    }],
    "draftData": {
        "contacts": [
        ]
    }
}

How to make the above json into:

[{phoneno: 123456789; sender: ifelse ; message: Hi},{phoneno: 11111111; sender: ifelse ; message: Hi}]

I want to take phoneno data from gsm object key

Which is best method to do this? for or forEach or anyother?

there is only one record like this or there are multiple records like this on your JSON? — Vipin Kumar
– Vipin Kumar, Commented Dec 18, 2017 at 9:23

Vipin Kumar · Accepted Answer · 2017-12-18 09:27:42Z

3

I guess, this is what you want. Use map to convert contactgroups to new array with phoneno.

var data = {
  "senderName": "ifelse",
  "message": "Hi",
  "groups": [{
    "id": 14,
    "groupname": "Angular",
    "contactgroups": [{
        "id": 1,
        "contact": {
          "id": 1,
          "gsm": "123456789"
        }
      },
      {
        "id": 3,
        "contact": {
          "id": 2,
          "gsm": "111111111"
        }
      }
    ],
    "select": true
  }],
  "draftData": {
    "contacts": []
  }
}

var result = data.groups[0].contactgroups.map(i => {
  return {
    phoneno: i.contact.gsm,
    sender: data.senderName,
    message: data.message
  }
})

console.log(result);

answered Dec 18, 2017 at 9:27

Vipin Kumar

6,5661 gold badge21 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Javascript(NodeJs) - Conversion of Arrays and Objects to bulk insert in mysql(Sequelize)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related