JSonReadr and complex Json?

[Sultanalifezar]

I'm new to EXT and had a question. As I disect the demos and samples to figure out the api, I tried to just creat a simple demo that used the yahoo websearch service and load it into a Panel using a template for formating.

This is the Json returned from the call

{"ResultSet":{"type":"web","totalResultsAvailable":254000000,"totalResultsReturned":10,"firstResultPosition":1,"moreSearch":"\/WebSearchService\/V1\/webSearch?query=Madonna&appid=YahooDemo&region=us","Result":[{"Title":"Madonna","Summary":"Official site of pop diva Madonna, with news, music, media, and fan club.","Url":"http:\/\/www.madonna.com\/","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA9DHdmMwF;_ylu=X3oDMTB2b2gzdDdtBGNvbG8DZQRsA1dTMQRwb3MDMQRzZWMDc3IEdnRpZAM-\/SIG=11bpd2vcm\/EXP=1200536989\/**http%3A\/\/www.madonna.com\/","DisplayUrl":"www.madonna.com\/","ModificationDate":1200297600,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA9THdmMwF;_ylu=X3oDMTBwZTdwbWtkBGNvbG8DZQRwb3MDMQRzZWMDc3IEdnRpZAM-\/SIG=15nsdmc0a\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=www.madonna.com\/%26w=madonna%26d=A_opCrXiQIQN%26icp=1%26.intl=us","Size":"18519"}},{"Title":"MySpace.com - Madonna - Pop \/ Rock - www.myspace.com\/madonna","Summary":"Madonna MySpace page with news, blog, music downloads, desktops, wallpapers, and more.","Url":"http:\/\/www.myspace.com\/madonna","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA9zHdmMwF;_ylu=X3oDMTB2dnY0Nm1iBGNvbG8DZQRsA1dTMQRwb3MDMgRzZWMDc3IEdnRpZAM-\/SIG=11ivvkpli\/EXP=1200536989\/**http%3A\/\/www.myspace.com\/madonna","DisplayUrl":"www.myspace.com\/madonna","ModificationDate":1200297600,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA.DHdmMwF;_ylu=X3oDMTBwbGppbHRwBGNvbG8DZQRwb3MDMgRzZWMDc3IEdnRpZAM-\/SIG=15uq5m8i5\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=www.myspace.com\/madonna%26w=madonna%26d=YjGIGbXiQIOp%26icp=1%26.intl=us","Size":"137708"}},{"Title":"madonnalicious","Summary":"Pictures, articles, downloads, concert info, news, and more about Madonna.","Url":"http:\/\/madonnalicious.typepad.com\/","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA.jHdmMwF;_ylu=X3oDMTB2c2Zzc202BGNvbG8DZQRsA1dTMQRwb3MDMwRzZWMDc3IEdnRpZAM-\/SIG=11mljhlfm\/EXP=1200536989\/**http%3A\/\/madonnalicious.typepad.com\/","DisplayUrl":"madonnalicious.typepad.com\/","ModificationDate":1200297600,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA.zHdmMwF;_ylu=X3oDMTBwbTJyZTk4BGNvbG8DZQRwb3MDMwRzZWMDc3IEdnRpZAM-\/SIG=15u99c771\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=www.madonnalicious.com\/%26w=madonna%26d=QO6U_bXiQIJz%26icp=1%26.intl=us","Size":"74698"}},{"Title":"Madonna (I)","Summary":"Facts and filmography for the singer and actress.","Url":"http:\/\/www.imdb.com\/name\/nm0000187","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA_THdmMwF;_ylu=X3oDMTB2bGViN2ZsBGNvbG8DZQRsA1dTMQRwb3MDNARzZWMDc3IEdnRpZAM-\/SIG=11m4j75im\/EXP=1200536989\/**http%3A\/\/www.imdb.com\/name\/nm0000187","DisplayUrl":"www.imdb.com\/name\/nm0000187","ModificationDate":1200297600,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAA_jHdmMwF;_ylu=X3oDMTBwZTk1MWZqBGNvbG8DZQRwb3MDNARzZWMDc3IEdnRpZAM-\/SIG=162k8ae4h\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=www.imdb.com\/name\/nm0000187%26w=madonna%26d=Z0zHLrXiQINt%26icp=1%26.intl=us","Size":"109292"}},{"Title":"Madonna Song Lyrics: Home Page","Summary":"Extensive collection of Madonna lyrics, organized by album. Includes lyrics to singles.","Url":"http:\/\/www.madonnalyrics.org\/","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAAADLdmMwF;_ylu=X3oDMTB2bzBpdmkxBGNvbG8DZQRsA1dTMQRwb3MDNQRzZWMDc3IEdnRpZAM-\/SIG=11htoo869\/EXP=1200536989\/**http%3A\/\/www.madonnalyrics.org\/","DisplayUrl":"www.madonnalyrics.org\/","ModificationDate":1181286000,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAAATLdmMwF;_ylu=X3oDMTBwMHMxbzJlBGNvbG8DZQRwb3MDNQRzZWMDc3IEdnRpZAM-\/SIG=15tkq6gq0\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=www.madonnalyrics.org\/%26w=madonna%26d=WGAopLXiQIK-%26icp=1%26.intl=us","Size":"18749"}},{"Title":"Madonna | MTV Official Site","Summary":"Stay current on the latest Madonna music videos, news, tour dates, ringtones and more on MTV - the leader in music news, Video premieres and entertainment online.","Url":"http:\/\/www.mtv.com\/music\/artist\/madonna\/artist.jhtml","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAAAzLdmMwF;_ylu=X3oDMTB2bWNrYzd0BGNvbG8DZQRsA1dTMQRwb3MDNgRzZWMDc3IEdnRpZAM-\/SIG=1b0cqogjp\/EXP=1200536989\/**http%3A\/\/rdre1.yahoo.com\/click%3Fu=http%3A\/\/www.mtv.com\/music\/artist\/madonna\/artist.jhtml%253Fextcmp%253DSEO_SSP_Y%26y=0420DDE29447534D05%26i=482%26c=50125%26mcid=06D10A4DE4787549%26q=02%255ESSHPM%255BL7R~%257Bpqq~6%26e=utf-8%26r=5%26d=wow~WBSV-en-us%26n=KB44G7MT6A6KE5EO%26s=0%26t=%26m=478D6C1D%26x=057EF553D9AA30AAB5A18E359ACF575500","DisplayUrl":"www.mtv.com\/music\/artist\/madonna\/artist.jhtml","ModificationDate":1199952000,"MimeType":"text\/html"},{"Title":"Madonna Resource Page","Summary":"Madonna links.","Url":"http:\/\/www.cbvcp.com\/c2\/madonna.html","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAABTLdmMwF;_ylu=X3oDMTB2anFtOTBnBGNvbG8DZQRsA1dTMQRwb3MDNwRzZWMDc3IEdnRpZAM-\/SIG=11oqq0q8j\/EXP=1200536989\/**http%3A\/\/www.cbvcp.com\/c2\/madonna.html","DisplayUrl":"www.cbvcp.com\/c2\/madonna.html","ModificationDate":1200384000,"MimeType":"text\/html"},{"Title":"Madonna on Yahoo! Music","Summary":"Offers Madonna music downloads, photos, album information, and videos.","Url":"http:\/\/music.yahoo.com\/ar-256352---Madonna","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAABzLdmMwF;_ylu=X3oDMTB2dWNjdTY4BGNvbG8DZQRsA1dTMQRwb3MDOARzZWMDc3IEdnRpZAM-\/SIG=11ueoon4e\/EXP=1200536989\/**http%3A\/\/music.yahoo.com\/ar-256352---Madonna","DisplayUrl":"music.yahoo.com\/ar-256352---Madonna","ModificationDate":1200384000,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAACDLdmMwF;_ylu=X3oDMTBwbnBydmMxBGNvbG8DZQRwb3MDOARzZWMDc3IEdnRpZAM-\/SIG=16ataf52f\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=music.yahoo.com\/ar-256352---Madonna%26w=madonna%26d=RMH9IrXiQITf%26icp=1%26.intl=us","Size":"74642"}},{"Title":"Madonna | VH1.com","Summary":"Latest news, her influences, multimedia, and more.","Url":"http:\/\/www.vh1.com\/artists\/az\/madonna\/artist.jhtml","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAACjLdmMwF;_ylu=X3oDMTB2Zmc2bnRtBGNvbG8DZQRsA1dTMQRwb3MDOQRzZWMDc3IEdnRpZAM-\/SIG=1au5blp2o\/EXP=1200536989\/**http%3A\/\/rdre1.yahoo.com\/click%3Fu=http%3A\/\/www.vh1.com\/artists\/az\/madonna\/artist.jhtml%253Fextcmp%253DSEO_SSP_Y%26y=04621F11EFE9D46B96%26i=482%26c=50409%26mcid=EB236445C6C284E8%26q=02%255ESSHPM%255BL7R~%257Bpqq~6%26e=utf-8%26r=8%26d=wow~WBSV-en-us%26n=KB44G7MT6A6KE5EO%26s=0%26t=%26m=478D6C1D%26x=05F8C6E00A7A4D56818543CC79C33F6881","DisplayUrl":"www.vh1.com\/artists\/az\/madonna\/artist.jhtml","ModificationDate":1200038400,"MimeType":"text\/html"},{"Title":"Madonna (entertainer) - Wikipedia, the free encyclopedia","Summary":"Madonna was raised in a Catholic family in the Detroit suburbs of Pontiac and ... Madonna's mother died of breast cancer at age 30 on December 1, 1963. ...","Url":"http:\/\/en.wikipedia.org\/wiki\/Madonna_(entertainer)","ClickUrl":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAADDLdmMwF;_ylu=X3oDMTEwM2lzbnRtBGNvbG8DZQRsA1dTMQRwb3MDMTAEc2VjA3NyBHZ0aWQD\/SIG=1262hrjq5\/EXP=1200536989\/**http%3A\/\/en.wikipedia.org\/wiki\/Madonna_(entertainer)","DisplayUrl":"en.wikipedia.org\/wiki\/Madonna_(entertainer)","ModificationDate":1200297600,"MimeType":"text\/html","Cache":{"Url":"http:\/\/uk.wrs.yahoo.com\/_ylt=A9iby44dbI1HwGAADTLdmMwF;_ylu=X3oDMTBxcGs5ZDY0BGNvbG8DZQRwb3MDMTAEc2VjA3NyBHZ0aWQD\/SIG=16u86et1s\/EXP=1200536989\/**http%3A\/\/216.109.125.130\/search\/cache%3Fei=UTF-8%26appid=YahooDemo%26query=Madonna%26output=json%26u=en.wikipedia.org\/wiki\/Madonna_%252528entertainer%252529%26w=madonna%26d=feY-TLXiQIG_%26icp=1%26.intl=us","Size":"224422"}}]}}

And this is my code

Ext.onReady(function(){
    var ds = new Ext.data.Store({
        proxy: new Ext.data.ScriptTagProxy({
            url: 'http://search.yahooapis.com/WebSearchService/V1/webSearch'
        }),
        reader: new Ext.data.JsonReader({
            root: 'Result',
            totalProperty: 'totalResultsReturned',
            id: 'Title'
        }, [            
            {name: 'title', mapping: 'Title'},
            {name: 'summary', mapping: 'Summary'}
        ]),

        baseParams: {appid:'YahooDemo', query:'Madonna', output:'json'}
    });

    // Custom rendering Template for the View
    var resultTpl = new Ext.XTemplate(
        '<tpl for=".">',
        '<div class="search-item">',
            '<h3><span>Test<br />by {title}</span>',
            '<a href="" target="_blank">{title}</a></h3>',
            '<p>{summary}</p>',
        '</div></tpl>'
    );

    var panel = new Ext.Panel({
        applyTo: 'search-panel',
        title:'Forum Search',
        height:300,
        autoScroll:true,

        items: new Ext.DataView({
            tpl: resultTpl,
            store: ds,
            itemSelector: 'div.search-item'
        }),
       
    });

    ds.load({params:{start: 0, appid: 'YahooDemo', query: 'Madonna', output: 'json'}});
});

Everything comes back but it isn't rendering, I'm pretty sure it has to do with teh Json thats returned "ResultSet" being the object but the rows being in "Results".

Anyhow I'm confused as to how to make the JsonReader actually read it.

Any help is appreciated. Thank you.

[Animal]

The JSON quite clearly contains a property totalResultsAvailable which must be the total dataset size, and yet you ave

            totalProperty: 'totalResultsReturned',

That does not inspire confidence. But that's only needed for the PagingToolbar, so that's not the issue.

The ID of a Record must be unique, so

            id: 'Title'

Is not reliable. Some pages mighy have the same title. If there is no unique identifier, omit this property, and a unique ID will be generated by Ext.

The root is ResultSet.Results isn't it?

[Sultanalifezar]

RecordSet.Result worked thank you very much, I must have been in a fog not to realize it myself, after you said it I hit myself in the head for being so silly.

And yes your point of the record set size is correct. I was messing around with the code for awhile so I probably changed it at some point.

Again thank you for your help.