Parse External JSON File with jQuery

Question

I have a 2 MB JSON object that I'm hoping to parse with jQuery. I dumped the whole object into a file named "timeline.js" and I'm hoping to parse through it as a dataset to grab records as needed.

My dataset started as an XML file, but I read that JSON would be more efficient as I'm using jQuery to pull the data and place it in the DOM.

Below is the first record of my object. How would I parse this object to grab the record with a 'profileid' of 1016?

{
timeline:{
    record:[
        {
            profileid:1016,
            title:'Adam',
            parentprofileid:0,
            type:'Person',
            minzoomlevel:29,
            maxzoomlevel:66,
            isapproxstart:1,
            isapproxend:1,
            startdate:-4181,
            enddate:-3251,
            shortdescription:'Name means "red" or "man" he is...',
            article:'<div><span>The first member of...',
            status:22,
            scriptures:{
                scripture:[
                    {
                        profileid:1016,
                        scripturetext:'Genesis 2:7',
                        referencetext:'Birth'
                    },
                    {
                        profileid:1016,
                        scripturetext:'Genesis 5:4',
                        referencetext:'Death'
                    }
                ]
            }
        },

daan_tallguys · Accepted Answer · 2012-06-01 19:11:52Z

5

jQuery parseJSON works fine, however is unnecessary when using jQuery AJAX and set the dataType to JSON (it is already parsed by jQuery after receiving the data).

However, I guess your actual question is how to find the record with the profileid of e.g. 1016. Since all items are in an array, the only way to find it, is to loop the array and check what profileId is set for the current item. For example:

for(var i in items){
    if(items[i].profileid == 1016){
       //execute whatever you want to do.
    }
}

answered Jun 1, 2012 at 19:11

daan_tallguys

3051 silver badge5 bronze badges

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

Comments

Pranay Rana · Accepted Answer · 2012-06-01 18:55:42Z

1

Make use of :jQuery.parseJSON( json ) - Takes a well-formed JSON string and returns the resulting JavaScript object. Example

var obj = jQuery.parseJSON('{"name":"John"}');
 alert( obj.name === "John" );

answered Jun 1, 2012 at 18:55

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

1 Comment

matthoiland Over a year ago

By doing this - codevar obj = jQuery.parseJSON('timeline.js');code - doesn't this store the entire JSON object in memory? Or does it simply parse the JSON each time you call obj?

Collectives™ on Stack Overflow

Parse External JSON File with 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