Connecting a grid to Open Access

[Simon]

Hello,

Is there any up to date tutorial that would explain, step by step, how to create an oData Service with Open Access, then how to consume that oData Service with the KendoUI grid?

Best Regards,

Simon

[Simon]

Maybe I should be more specific about what I'm looking for...

I did generate a SVC file using this tutorial.  However, when I try to consume the WCF Data Service using you Grid example, the grid is drawed correctly, then there's a "Loading Data..." message but then the grid can't retreive any row from my WCF Data Service.

There's no error message but if I change the read option from

read: "http://localhost:61111/MyDomainService.svc/Orders"

to

read: "http://demos.kendoui.com/service/Northwind.svc/Orders"

then everything work as expected.

Is there's any security enabled by default by the OprnAccess Daata Domain that could explain my problem?  If it isn't the case, what can be the causes of this behavior?

Best Regards,

Simon

[Joel]

Make sure you have JSONP support added on your sevice using this service behavior : http://archive.msdn.microsoft.com/DataServicesJSONP 

Once installed, the new behavior adds two OData keywords to the RESTful query vocabulary:

$format - which allows explicit control over the response format from the URL (i.e. $format=json)
$callback - which instructs the server to wrap JSON results in a JavaScript function to support JSONP


Joel

[Simon]

Thanks Joel, I'll try to implement it later on this week.

However, it’s a surprise for me to see that the JSONP behavior isn't generated out of the box by Open Access as KendoUI and Open Access are made by the same business…

Simon

[Simon]

Hi Joel,

I did implement the JSONP behavior support and it did fix my problem.

Thanks a lot for pointing out the problem (and the solution).

Simon

[Sebastian]

Hello folks,

You may also find this blog post helpful as it discusses similar subject.

Regards,
Sebastian
the Telerik team

[Simon]

Great blog post!  Everything is clearly explained.

I wish I had this article 2 weeks ago :)

[CG]

I've managed to get this sample up and running for the read transport.  How do I go about implementing CRUD operations?

[Iliana Dyankova]

Hi Chris,

I believe that  complete CRUD project with OpenAccess and Kendo UI sample will be of help.

All the best,
Iliana Nikolova
the Telerik team