How to change values in JSON array

Question

I have a file that gets a json response like this:

{
   total": 86,
   "data": [
    {
        "Id": 2,
        "Name": "User One",
        "Shipping": 1,
        "Created": "25 March 2017"
    },
    {
        "Id": 3,
        "Name": "User Two",
        "Shipping": 2,
        "Created": "25 March 2017"
    },
    {
        "Id": 4,
        "Name": "User Three",
        "Shipping": 3,
        "Created": "26 March 2017"
    }
  ]
}

I want to run through this result and change all the Shipping values to:

1 Post Office

2 PostNet

3 Courier

In my code I do:

$.each(data.data, function () {
      $.each(this, function (key, value) {
         if(key == 'Shipping') {
             switch(value) {
               case 2:
                   ? = 'PostNet';
                   break;
               case 2:
                   ? = 'Courier';
                   break;
               default:
                   ? = 'Post Office';
                   break;
               }

         }
      });
});

I don't know how to get the right array key so I can change it, that's where I put the ?.

Can anyone please help?

donjuedo · Accepted Answer · 2017-03-27 14:50:11Z

1

You're close.

Loop through the JSON object. When key matches string, then make the switch. Once you match one of the values, change the parent loop value into the desired value.

Change your JS into this:

$.each(data.data, function (key, value) {    
    $.each(this, function(k, v) {
        if(k == 'Shipping') {
             switch(v) {
                    case 1:
                   value.Shipping = 'PostNet';
                   break;
                case 2:
                   value.Shipping = 'Courier';
                   break;
                default:
                   value.Shipping = 'Post Office';
                   break;
             }
        }
    });
});

https://jsfiddle.net/zeopL56n/2/ (See console log)

edited Mar 27, 2017 at 14:50

donjuedo

2,50520 silver badges28 bronze badges

answered Mar 27, 2017 at 14:37

Red

7,46310 gold badges53 silver badges98 bronze badges

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

1 Comment

Sigal Zahavi Over a year ago

God bless your soul... :) Thank you

trincot · Accepted Answer · 2017-04-02 18:02:20Z

0

You have to do it this way:

$.each(data.data, function () {
    switch(this.Shipping) {
    case 1: 
        this.Shipping='PostNet';
        break;
    case 2: 
        this.Shipping='Courier';
        break;
    default: 
        this.Shipping='Post Office';
    }
});

Look at the console to see the updated object.

Here is a fiddle

edited Apr 2, 2017 at 18:02

trincot

357k38 gold badges282 silver badges338 bronze badges

answered Mar 27, 2017 at 14:41

lhavCoder

9615 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to change values in JSON array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related