Query Odata Feed

[vtmac]

Hi,

is it possible to query a odata feed using Ext.data.Store ?
I keep getting an parse error.
Anyone knows how to do it ?

thanks

[mitchellsimoens]

More than likely. What does the feed look like? Got a URL?

[vtmac]

Thanks for your fast reply.
For now its an internal odata feed.
But its prety much like this one :
http://services.odata.org/Northwind/Northwind.svc/
http://services.odata.org/Northwind/Northwind.svc/Customers?$format=json
if you can show me for example how to load the Customers (json format) to a data store to use it on a list would be awsome !

Thanks in advance!

[StaticVoidMain]

For querying you don't need much, the problem arises when you want to write to the store but, if it is just for reading you just need to configure store like this:
var store = new Ext.data.JsonStore({
root: 'd',
url: 'http://services.odata.org/Northwind/Northwind.svc/Customers?$format=json',
fields:[...],
...
});
This works as expected, i'm using it, i'm also working on an "OdataStore" (and corresponding OdataProxy) to support writing but is not finnished yet.

I hope that helps a bit to clarify things.

[JeremyCaney]

We did some work on querying an OData store back with ExtJS 3.0 and ADO.NET Data Services 1.5. I hope to update this to work with ExtJS 4.0 and WCF Data Services at some point, but haven't had a chance to work on this yet. One of my co-workers posted some information on the approach we took previously, which may be of value.

http://blogs.ignia.com/Levi.Fleischm...ices.rest.aspx

Jeremy

[deepmime]

I plan on implementing this in the next month or so.

If anyone else is working on this, please let me know. I would rather not reinvent the wheel but it will be good practice for me if anything.

Any suggestions would be greatly appreciated. I think the trick will be updating I believe.

If i'm successful, i'll post the link here.

[dotnetwise]

I'm also interestead into it for Ext 4.0.2 - any progress so far?

[jcranwellward]

Bump!

Im also interested in this topic, anything happend this year yet?

[facorreia]

I need to build front-end applications for WCF Data Services web services using the OData protocol.

Is there any progress on a compatible store for this with CRUD support?

[Oleg Dolzhansky]

Please see this very basic implementation of OData Protocol which WCF Data Services use.

This Proxy support CRUD operations and sorting.

/*

Open Data Protocol Implementation for Ext Js 4
Links:
    ExtJs 4 Server Proxy: http://docs.sencha.com/ext-js/4-0/source/Server.html#Ext-data-proxy-Server
    ExtJs 4 Ajax Proxy: http://docs.sencha.com/ext-js/4-0/#!/api/Ext.data.proxy.Ajax
    OData URI Conventions: http://www.odata.org/developers/protocols/uri-conventions
License: GNU General Public License v3 http://www.gnu.org/copyleft/gpl.html
Author: Oleg Dolzhansky dolzhansky@gmail.com

Example:

Ext.define('Customer', {
    extend: 'Ext.data.Model',
    fields: [
        {name: 'id', type: 'int', defaultValue: 0},
        {name: 'name', type: 'string'}
    ],
    idProperty: 'id'
});

var CustomersStore = Ext.create('Ext.data.Store', {
    model: 'Customer',
    proxy: {
        type: 'odata',
        url : '/Service.svc/Customers'
    },
    autoLoad: true
});

*/

Ext.define('Ext.ux.data.proxy.OData', {
    extend: 'Ext.data.proxy.Ajax',
    alternateClassName: 'Ext.ux.data.ProxyOData',
    alias: 'proxy.odata',

    /* Builds URL in the form Entity(Id), for example http://localhost/Service.svc/Customers(5) */
    buildUrl: function (request) {
        var me = this,
            operation = request.operation,
            records = operation.records || [],
            record = records[0],
            url = me.getUrl(request),
            id = record ? record.getId() : operation.id;

        if (id) {
            if (url.match(/\/$/)) {
                url = url.substring(0, url.length - 1);
            }
            url = url + '(' + id + ')';
        }

        request.url = url;

        return me.callParent(arguments);
    },

    /* Returns a string of comma-separated fields from sortes with optional 'desc' directive */
    encodeSorters: function (sorters) {
        var min = [],
            length = sorters.length,
            i = 0;

        for (; i < length; i++) {
            min[i] = sorters[i].property;
            if (sorters[i].direction.toLowerCase() == 'desc') {
                min[i] += ' desc';
            }
        }

        return min.join(',');
    }

}, function () {
    Ext.apply(this.prototype, {
        actionMethods: {
            create: 'POST',
            read: 'GET',
            update: 'PUT',
            destroy: 'DELETE'
        },
        reader: {
            type: 'json',
            root: 'd'
        },
        headers: {
            'Accept': 'application/json'
        },
        pageParam: undefined,
        startParam: '$skip',
        limitParam: '$top',
        sortParam: '$orderby',
        noCache: false
    });
});