Store Not Parsing JSON Data

[wsharp@advresearch.com]

I have a Store that gets JSON data from a WCF service. The store is calling the web service and getting data back, but my chart still displays no data, so I'm assuming it's not parsing it correctly.


**Here is my code:**

    // Define Model
    Ext.regModel('chart1model', {
        fields: [
            {name: 'name', type: 'string'},
            {name: 'data', type: 'int'}
        ]
    });
    
    
    var store1 = new Ext.data.Store({
        model: 'chart1model', 
        proxy: {
            type: 'ajax',
            url: 'http://localhost:8523/WebService/GetChartData?chartType=1',
            reader: {
                type: 'json'
            }
        },
        autoLoad: true
    });

If I take the same data and create the Store myself, the chart displays correctly:

    var store1 = new Ext.data.JsonStore({
            fields: ['name', 'data'],
            data: [
            {'name':'Nov-09','data':0},{'name':'Nov-10','data':0},{'name':'Nov-11','data':0},{'name':'Nov-12','data':0},{'name':'Nov-13','data':0},{'name':'Nov-14','data':0},{'name':'Nov-15','data':0},{'name':'Nov-16','data':0},{'name':'Nov-17','data':0},{'name':'Nov-18','data':0},{'name':'Nov-19','data':0},{'name':'Nov-20','data':0},{'name':'Nov-21','data':0},{'name':'Nov-22','data':0},{'name':'Nov-23','data':0},{'name':'Nov-24','data':0},{'name':'Nov-25','data':0},{'name':'Nov-26','data':0},{'name':'Nov-27','data':0},{'name':'Nov-28','data':0},{'name':'Nov-29','data':0},{'name':'Nov-30','data':0}
            ]
        });

I'm not sure what I'm doing wrong. Any help would be greatly appreciated.

[mitchellsimoens]

Any errors? Are you on the same origin (localhost:8523)?

[wsharp@advresearch.com]

Not on the same origin, but a work around is in place.

To confirm the data I get back I am using jQuery to consume the service, and then viewing the output in the browser. I then take that output I receive from the web service and manually create an Ext.Data.Store. This works flawlessly.

However if I try to consume the web service in the Ext.Data.Store, such as in my first example above; I can see it in debug call the web service, and the web service returns data, but no data is stored.

[mitchellsimoens]

Does your server support CORS? Meaning is it sending the needed headers?

[wsharp@advresearch.com]

Yes, it's sending the headers.

I've just tried using jQuery to consume the wcf service and store the json data returned in a variable. Then assign that variable to the data field in an Ext.data.store, but I'm getting the error "Cannot read property 'length' of undefined "

[mitchellsimoens]

Ok, so it sounds like you don't have a config set properly. What is a sample of the data and your store config?

[wsharp@advresearch.com]

var store1 = new Ext.data.JsonStore ({
    fields: ["name","data"],
    data: retVal
});

Where retVal =

[{"name":"Nov-12","data":0},{"name":"Nov-13","data":0},{"name":"Nov-14","data":0},{"name":"Nov-15","data":0},{"name":"Nov-16","data":0},{"name":"Nov-17","data":0},{"name":"Nov-18","data":0},{"name":"Nov-19","data":0},{"name":"Nov-20","data":0},{"name":"Nov-21","data":0},{"name":"Nov-22","data":0},{"name":"Nov-23","data":0},{"name":"Nov-24","data":0},{"name":"Nov-25","data":0},{"name":"Nov-26","data":0},{"name":"Nov-27","data":0},{"name":"Nov-28","data":0},{"name":"Nov-29","data":0},{"name":"Nov-30","data":0},{"name":"Dec-01","data":0},{"name":"Dec-02","data":0},{"name":"Dec-03","data":0}]

[mitchellsimoens]

This works for me in ST 1.1.1:

var retVal = [
    {"name" : "Nov-12", "data" : 0},
    {"name" : "Nov-13", "data" : 0},
    {"name" : "Nov-14", "data" : 0},
    {"name" : "Nov-15", "data" : 0},
    {"name" : "Nov-16", "data" : 0},
    {"name" : "Nov-17", "data" : 0},
    {"name" : "Nov-18", "data" : 0},
    {"name" : "Nov-19", "data" : 0},
    {"name" : "Nov-20", "data" : 0},
    {"name" : "Nov-21", "data" : 0},
    {"name" : "Nov-22", "data" : 0},
    {"name" : "Nov-23", "data" : 0},
    {"name" : "Nov-24", "data" : 0},
    {"name" : "Nov-25", "data" : 0},
    {"name" : "Nov-26", "data" : 0},
    {"name" : "Nov-27", "data" : 0},
    {"name" : "Nov-28", "data" : 0},
    {"name" : "Nov-29", "data" : 0},
    {"name" : "Nov-30", "data" : 0},
    {"name" : "Dec-01", "data" : 0},
    {"name" : "Dec-02", "data" : 0},
    {"name" : "Dec-03", "data" : 0}
];

var store1 = new Ext.data.JsonStore({
    fields : ['name', 'data'],
    data   : retVal
});

[wsharp@advresearch.com]

Alright, figured it out. It was returning a string, but Ext.data.strore was expecting an JSON array. If I parse the string to JSON it works fine.

var retVal = $.parseJSON(retVal);

var store1 = new Ext.data.JsonStroe({
    fields : ['name','data'],
    data : retVal
});