JSON: Convert numeric array to object

Question

This is the JSON I get when encoding an array using jQuery:

{"1":{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
"2":{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
"3":{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
"4":{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
"5":{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"}}

But I need an object like this:

[{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"},
{"name":"11233","po":"121212","po_item_number":"000001","po_item_material_code":"material","po_item_description":"assemble","sales_order":"11000000","sales_order_item":"10","tracable":"sds"}]

How can I do that?

First in not an array. Second is not valid. You might need to wrap it in [] — Rajesh Dixit
– Rajesh Dixit, Commented Oct 19, 2016 at 11:25
Above value placed in my hidden text field <input type="hidden" name='xcl_json_val' class='xcl_json_val' value='<?=json_encode($result)?>' /> — abdul kadhar
– abdul kadhar, Commented Oct 19, 2016 at 11:28

gurvinder372 · Accepted Answer · 2016-10-19 11:42:01Z

1

If your input is a String, then first parse it into the object.

var obj = JSON.parse( inputStr );

try this (assuming obj is the input)

var output = Object.keys( obj ).map( function(key){
  return obj[ key ];
})

var obj = {
  "1": {
    "name": "11233",
    "po": "121212",
    "po_item_number": "000001",
    "po_item_material_code": "material",
    "po_item_description": "assemble",
    "sales_order": "11000000",
    "sales_order_item": "10",
    "tracable": "sds"
  },
  "2": {
    "name": "11233",
    "po": "121212",
    "po_item_number": "000001",
    "po_item_material_code": "material",
    "po_item_description": "assemble",
    "sales_order": "11000000",
    "sales_order_item": "10",
    "tracable": "sds"
  },
  "3": {
    "name": "11233",
    "po": "121212",
    "po_item_number": "000001",
    "po_item_material_code": "material",
    "po_item_description": "assemble",
    "sales_order": "11000000",
    "sales_order_item": "10",
    "tracable": "sds"
  },
  "4": {
    "name": "11233",
    "po": "121212",
    "po_item_number": "000001",
    "po_item_material_code": "material",
    "po_item_description": "assemble",
    "sales_order": "11000000",
    "sales_order_item": "10",
    "tracable": "sds"
  },
  "5": {
    "name": "11233",
    "po": "121212",
    "po_item_number": "000001",
    "po_item_material_code": "material",
    "po_item_description": "assemble",
    "sales_order": "11000000",
    "sales_order_item": "10",
    "tracable": "sds"
  }
};

var output = Object.keys(obj).map(function(key) {
  return obj[key];
})

console.log(output);

edited Oct 19, 2016 at 11:42

answered Oct 19, 2016 at 11:25

gurvinder372

68.6k11 gold badges78 silver badges98 bronze badges

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

4 Comments

abdul kadhar Over a year ago

Using your code, its separate all value to single character.

gurvinder372 Over a year ago

did you tried the snippet I have attached, what is missing from it?

Andreas Over a year ago

@abdulkadhar " its separate all value to single character" Then the input is still JSON and has to be parsed with JSON.parse(...) before transforming it with the above script

gurvinder372 Over a year ago

@abdulkadhar Oh, I thought your input is a JS object rather than the string. Check the updates.

Collectives™ on Stack Overflow

JSON: Convert numeric array to object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related