How to build a json file and extract data values from it in jquery?

Question

I have excel sheet which i need to build the json file. i have build a sample file. but i am unable to proceed with that json file and extract the data from it.

[{
   "Material thickness": "10 Mil",        
   "Width": 8,
   "height": 8,
   "Price": "8.76",
   "Quantity":1
},
{
   "Material thickness": "7 Mil",        
   "Width": 8,
   "height": 12,
   "Price": "10.52",
   "Quantity":1
}
]

jQuery.getJSON( siteURL+"/prices.json", function( data ) {
  jQuery.each(data, function (index, value) {
    console.log(index);
    console.log(value);
    console.log(data[index].Material thickness);                             
  });                           
});

Hina Patel · Accepted Answer · 2018-03-30 12:23:06Z

1

You can use the following:

console.log(data[index]["Material thickness"]);

answered Mar 30, 2018 at 12:23

Hina Patel

1114 bronze badges

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

Comments

Zenoo · Accepted Answer · 2018-03-30 12:46:54Z

1

You can't use the dot notation when your key contains a space.

The property accessed with a dot notation must be a sequence of alphanumerical characters, also including the underscore ("_") and dollar sign ("$"), that cannot start with a number

Use the bracket notation instead :

data[index]['Material thickness']

var data = [{
    "Material thickness": "10 Mil",
    "Width": 8,
    "height": 8,
    "Price": "8.76",
    "Quantity": 1
  },
  {
    "Material thickness": "7 Mil",
    "Width": 8,
    "height": 12,
    "Price": "10.52",
    "Quantity": 1
  }
];

$.each(data, function(index, value) {

  //console.log(index);
  //console.log(value);
  console.log(data[index]['Material thickness']);

});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

edited Mar 30, 2018 at 12:46

answered Mar 30, 2018 at 11:44

Zenoo

12.9k4 gold badges48 silver badges71 bronze badges

1 Comment

gopi Over a year ago

getting error { "message": "Uncaught SyntaxError: Block-scoped declarations (let, const, function, class) not yet supported outside strict mode", "filename": "stacksnippets.net/js", "lineno": 13, "colno": 9 }

Collectives™ on Stack Overflow

How to build a json file and extract data values from it in jquery?

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