Blog
Below, find a collection of blog posts documenting the life of OData and its uses since 2010. For some of our most recent posts and tutorials about the .NET implementation of OData, we encourage you to check out the Microsoft blog.
We also welcome community contributions! Add your own post by creating a pull request on our GitHub page.
OData 4.01 Committee Spec Approved
01 Feb 2018 • Michael PizzoOData V4.01 was officially approved as a Committee Specification this week, marking the next step toward final standardization of the much anticipated extensions to OData V4.0. OData v4.01 is a fully compatible extension of the OData V4.0 protocol that adopts many popular conventions, syntax and payload simplifications, and incorporates new...
Whats New in REST APIs Seminar December 5 2017
22 Nov 2017 • Sumit SarkarJoin experts from Progress and Gartner on Tuesday, December 5th, 2017, in a webinar on using OData to modernize enterprise data. Deliver OData-based REST APIs to Modernize your Enterprise Data REST APIs have grown exponentially over the past decade thanks to the rise of SaaS applications and highly integrated microservices...
Visual Studio Code Knows OData
02 Aug 2017 • Michael PizzoVisual Studio Code Knows OData Through a new Visual Studio Code Extension for OData, developers can now get rich language support for the OData query language. Enabled features include syntax highlighting and query encoding/decoding. Syntax aware formatting, metadata-driven code completion, and diagnostics are available in a beta state, and can...
OData Published as an ISO Standard
23 Feb 2017 • Michael PizzoOData 4.0 Published as ISO/IEC 20802 For those that missed the announcement, I’m thrilled to report that OData 4.0 has been ratified and published as an ISO/IEC Standard. OData 4.0 was published as an OASIS Standard in February of 2014. OASIS submitted OData 4.0 (including Errata) to the ISO/IEC JTC...
Webinar on Salesforce Connect External Object Reporting
12 Dec 2016 • Sumit SarkarSalesforce External Object Reporting with OData Reporting against external objects has been highly anticipated based on numerous requests on the Idea on the success community. Back in Winter ‘16, Mark Kovacevich blogged on a popular workaround to use external objects for reporting with custom visual force pages and apex controllers....
OData Hackathon at API World
12 Sep 2016 • Michael PizzoProgress DataDirect held the first known OData Hackathon this week at APIWorld 2016. Participants built applications to integrate with voice assistant services like Microsoft Cortana and Amazon Alexa that used OData to pull and update data from Salesforce, Microsoft Dynamics CRM and Sugar CRM. The winners, Echo Jokes, used facial...
Recap on OData session for SAP Business Objects Universe
07 Jul 2016 • Sumit SarkarThe OData road show continues with a stop at SAP Analytics conference, IBIS 2016 in Carlsbad, CA. The previous stop was the Progress DataDirect Partner Summit in Redwood City, CA where Michael Pizzo from the OData Technical Committee co-presented with me to talk about OData specification updates and adoption across...
OData JavaScript library - o.js explained
22 Feb 2016 • Jan Hommeso.js is a small (minified 14.4 KB) client-side library for requesting data from an OData service. It is designed to run in a browser environment, however it also runs in node.js. In a browser environment it has no dependencies on other libraries and can be used standalone. The main goal...
Webinar: External data integration strategies
13 Jan 2016 • Mark StaffordThe following is a post by Mark Stafford of Microsoft’s OData team. Join us on January 19th at 1:00pm Eastern Time for a webinar discussing external data integration strategies. This webinar is free of charge and hosted by Progress Software, Oracle, and Microsoft. To register for the webinar, please follow...
Enabling Innovation: Making NSW Biodiversity Data Open
30 Nov 2015 • James BibbyThe following is a guest post by James Bibby of NSW Office of Environment & Heritage. The views expressed and statements made are those of Biodiversity Information Systems and not of OData.org or its administrators. The NSW Office of Environment and Heritage has recently opened up its massive store of...
Next major SaaS application will be demonstrating OData support at OOW15
15 Oct 2015 • Sumit SarkarI am very excited about co-presenting an “ecosystem-changing” session around OData at Oracle OpenWorld 2015 this year. This development represents the next major SaaS vendor to support accessing external data as an OData consumer. One of the early OData consumers in the SaaS space was Salesforce with the introduction of...
Enterprise Mobile Application Development using OData
06 Oct 2015 • Sumit SarkarIn my role as Chief Data Evangelist for Progress Software, it’s important to promote best practices for data connectivity and integration patterns. In thinking about an architecture for building enterprise mobile applications at Progress Software, I made the recommendation to leverage OData for the connectivity. Below is a tutorial on...
Olingo releases OData V4 Support for Java Developers
29 Sep 2015 • Mike PizzoThe Olingo team announced last week that they have released Apache Olingo 4.0 with support for building OData V4-compliant RESTful services and clients. With support for OData V4’s JSON format, Olingo makes building a modern RESTful service in Java easier than ever. Whether you are sharing data with Salesforce Lightning...
Lightning Connect and OData updates from Dreamforce '15
23 Sep 2015 • Sumit SarkarSalesforce introduced support for Lightning Connect External Objects at Dreamforce ‘14 powered by OData. Salesforce’s Lightning Connect was initially released as an OData 2.0 read-only consumer. And new OData functionality is being added in each release based on demand from data hungry Salesforce applications. At Dreamforce ‘15, I learned about...
combit Report Server adds support for OData V4.
04 Aug 2015 • combitcombit Report Server 2.0 adds support for OData V4 in service pack 2 You can use combit Report Server to generate powerful reports on an ad hoc basis. Browser-based, intuitive, and ready to use out-of-the-box, the combit Report Server is the perfect Business Intelligence solution for all kinds of data....
Access real-time NetSuite data from Salesforce through Lightning Connect and NetSuite OData feeds.
16 Jun 2015 • Mitch GrawLightning Connect to NetSuite External Objects Salesforce Lightning Connect enables Salesforce users to connect to data from OData sources from Salesforce in the same way that users interact with standard Salesforce objects. Through Lightning Connect, Salesforce customers can build real-time analysis from within their Salesforce dashboard and other Salesforce1 apps....
OData.org Update
25 May 2015 • Qian LiIntroduction OData.org is the community website for OData lovers. We have re-factored the site on 2015-5-15 for better user experience, better performance and easier contribution flow. Our previous architecture is WordPress + Windows Azure and the new architecture is Jekyll + GitHub + Windows Azure. Jekyll and GitHub are open-source...
Microsoft Power Query for Excel Releases Support for OData V4
15 May 2015 • Mike PizzoMicrosoft is pleased to announce enhanced support for OData V4 in the latest release of Power Query for Excel. Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. Microsoft Power Query for Excel has...
Apache Olingo OData Client for JavaScript release
11 May 2015 • Sven Kobler-MorrisThe Apache Olingo OData Client for JavaScript (ODataJS) is a library whose focus is to enable browser based front end applications to easily use the OData protocol for communication with application servers. However, its also possible to use the library on java script servers and a sample is provided for...
Acumatica Liberates ERP with OData
05 May 2015 • Qian LiThe blog post is Written by Tim Rodman – CPA turned ERP professional, now blogging at AcumaticaReports.com What is Acumatica ERP systems have long functioned like a data version of Fort Knox. They contain a wealth of useful information, but accessing it is almost impossible. The IT department has access,...
How to Use Web API OData to Build an OData V4 Service without Entity Framework
12 Mar 2015 • Qian LiThere are quite a lot of tutorials showing how to create OData services using Web API OData, but these requires Entity Framework and a database server behind. If you want a quick try or you have your own way of implementing data sources, these tutorials may not be the best...
Microsoft Open Technologies Releases OData Producer for SugarCRM to Boost The Efficiency of Corporate Data Exchange
09 Mar 2015 • Microsoft Open Technologies (China)Microsoft Open Technologies (China) today published the OData Producer for SugarCRM to GitHub, an open source plugin tool that aims to help organizations gain more value from their corporate assets by promoting the more efficient exchange of information between diverse data systems. Enterprises often need to use a variety...
OData.org Weekly News Letter (2015.3.4)
03 Mar 2015 • Qian LiODataLib 6.10.0 is released with new features and bug fix. Try now at nuget Full source and test of ODataLib has been published on Github. Check at Github and welcome contributions. OData server on node.js Read more about this new OData server on node.js at this blog post and try...
Gizur OData Server - turn your MySQL database into an odata producer
15 Feb 2015 • Jonas ColmsjöIntroduction I came across the odata standard while learning SAP:s new in-memory database technology called HANA. HANA makes it possible to create a backend API with CRUD operations without any coding. It is also possible to put logic in the backend using JavaScript (SAP HANA XS) and expose these functions with odata. And...
OData.org Weekly News Letter (6th week 2015)
09 Feb 2015 • Yi DingOData Query Designer by @rhettclinton is updated for CRM 2015 http://dynamicsxrmtools.codeplex.com/ SAP Gateway for Microsoft trail is now available in SAP Store https://scn.sap.com/community/interoperability-microsoft/blog/2015/01/19/sap-gateway-for-microsoft-trial-now-available-in-sap-store Microsoft ASP.NET Web API 2.2 for OData v4.0 ver. 5.4.0 is released http://blogs.msdn.com/b/odatateam/archive/2015/02/06/announcement-odata-web-api-5-4-release.aspx XOData Chrome App is now free for university students and researchers https://chrome.google.com/webstore/detail/xodata%C2%AE/hpooflanfopjepihkcjjfeonlnhfnmpp XOData is helping...
OData.org Weekly News Letter (5th week 2015)
01 Feb 2015 • Yi DingASP.NET Web API for OData V4.0 version 5.4 has RCed Find out from this blog post XOData added default axis ordering, scrollbar, and other usability improvements for data tables Try it out here Salesforce Lightning Connect can connect to OData services Salesforce Lighting connect lets you overcome this limitation by...
OData.org Weekly News Letter (4th week 2015)
25 Jan 2015 • Qian LiMS Open Tech (China) Releases OData Producer Codegen for JDBC to Tap the Gold Mine of Corporate Data OData Producer Codegen for JDBC is designed in response to the requirements of data providers, to avail batches of data to users from JDBC enabled data service providers. The tool, upon one-key...
MS Open Tech (China) Releases OData Producer Codegen for JDBC to Tap the Gold Mine of Corporate Data
22 Jan 2015 • Microsoft Open Technologies (China)According to a 2013 report issued by global consulting firm McKinsey & Company, The flow of “liquid”open data may contribute a total of three to five trillion dollars to the global economy. Committed to promote the free flow of data, Microsoft Open Tech (China) has become an active participant in the...
OData.org Weekly News Letter (3rd week 2015)
19 Jan 2015 • Qian LiJayData for OData V4 support available in JayData 1.4 alfa. I am super proud to announce the first version of the JayData library to support the OData V4 format – and a growing number of V4 features. You can check it out at http://odata-v4.azurewebsites.net/ to see it in action. Check...
Eclipse Ogee – Eclipse based developer tool for modelling OData services
14 Jan 2015 • Sounak BasuWhat is Eclipse Ogee? Ogee provides Eclipse based open source developer tools for the provisioning and consumption of OData services regardless of the service provisioning platform and service consuming technology. It comprises a graphical OData Model Editor for the creation of OData models that define the data structure required. The...
OData.org Weekly News Letter (2nd week 2015)
11 Jan 2015 • Yi DingNow OData services can be built using the MEAN stack (MongoDB, Express, Angular.JS, Node.js) If your a .NET developer specifically with ASP.NET (MVC, Web API/REST, Entity Framework, OData, etc.) and have heard or had interest in the MEAN stack, especially Node.JS, server side development in JavaScript – made possible with...
RESTier - A turn-key framework to build RESTful service
24 Dec 2014 • Qian LiWe are so excited to announce the preview release of RESTier – a new middle-ware approach RESTful API development framework for building standardized, OData V4 based REST services. What is RESTier RESTier is a RESTful API development framework for building standardized, OData V4 based REST services on .NET. It can...
Advanced OData Tutorial with Simple.OData.Client
14 Dec 2014 • Vagif AbilovThis article describes advanced OData scenario, both for the most recent OData protocol (V4) and earlier versions. The article was inspired by the Advanced OData Tutorial article published at the odata.org. The original article describes the HTTP communication level: it shows how to build URLs, which verbs to use and...
The Open Data Protocol (OData) Workshop By Woodruff Solutions
24 Nov 2014 • Chris WoodruffDoes your organization build web and mobile applications for your customers, clients and/or employees? Do you want to get those applications out into their hands quicker and with less maintainability from your already over-worked IT staff? Knowing and understanding what the Open Data Protocol (OData) can bring to your enterprise...
Salesforce External Object integration using Lightning Connect with OData
13 Nov 2014 • Sumit SarkarReflecting back on my third Dreamforce trip and fourth speaking session around standards based data connectivity; I remain most excited about the announcement at Dreamforce ’14 around Lightning Connect, the new external object support via OData released in Winter ’15. I consider myself a bit of a “data hippie” interested in the latest news on open...
MS Open Tech China Introduces Azure-Based Open Data Solution Using CKAN and OData Technologies
09 Nov 2014 • Microsoft Open Technologies (China)Today, MS Open Tech China released a new, open data solution for Microsoft Azure built around CKAN, an open source data portal, and an optimized OData plugin developed to specific requirements for the Chinese market. This solution leverages important technology components from the China software development market with a performant...
Apache Olingo OData Client for JavaScript beta release
16 Sep 2014 • Sven Kobler-MorrisThe Apache Olingo OData Client for JavaScript (ODataJS) is a library written in JavaScript that enables browser based front end applications to easily use the OData protocol for communication with application servers. It is currently available in version 4.0.0-beta-01 and supports the OData protocol in version 4. The ODataJS library is...
Instant OData for IBM DB2 on z/OS, iSeries, and LUW
02 Sep 2014 • Sumit SarkarFrom my experience working with DB2 shops on .NET application development projects, I have learned that most .NET developers are less familiar with the different flavors of DB2. This is why they choose standards based connectivity from either IBM or Progress DataDirect. The latest standard is OData, or “ODBC for...
TripPin - New OData V4 Sample Service
08 Jul 2014 • Qian LiIntroduction TripPin is a sample service based on OData V4. Generally speaking, TripPin provides a service that can manage people's trips. The service is designed for below purposes: Build a service that will cover as many features for OData V4 as possible. Build a more real world service, and will...
New OData Mailing List
29 Jun 2014 • Qian LiIn order to make OData.org a more collaborative site, we have maintained a Mailing List for people to ask or answer questions related to OData. And now we are moving to a new mailing list service OData Discussion Group. For users already subscribed to our old Mailing List, please note...
OData Icons Guidelines New Version Available
01 Jun 2014 • Qian LiWe are happy to announce that the updated version of OData Icon Usage Guidelines now on OData.org. Users now can have access to standard OData icons and identify conforming implementations of the OData specification in accordance with these guidelines. Please go directly to OData Icon Usage Guidelines to read the...
Contribution to OData.org is Available
21 Apr 2014 • Qian LiIn order to make OData.org a more collaborative site, we are excited to announce that you can now easily contribute to OData.org at the Contribution page. Currently there are two ways for you to contribute Contribute to the OData Ecosystem You can publish your OData consumers, OData providers, OData live...
Status updates of OData libraries that support OData Version 4.0
19 Mar 2014 • Yi DingOData Version 4.0 has officially been approved as a new OASIS standard recently. Compared to former versions, OData Version 4.0 offers exciting improvements to support OData consumers and producers. In order to help them adopt and benefit from OData Version 4.0, multiple efforts have been taken to build server and client libraries over...
Online Visualization/Exploration of OData Services : XOData
19 Mar 2014 • Ram Manohar TiwariHi..I am Ram. After working for 15 years in Enterprise IT, one fine day, I end up being a founder of a tiny software company – PragmatiQa Ltd, UK. In this post, I will write about a tool that I was working on for past few weeks. So I was...
Recent conference talks about OData
17 Mar 2014 • Yi DingIn April, there will be several conference sessions about OData delivered by Chris Woodruff at the Desert Code Camp 2014.1. The topics of the sessions are "Why Windows 8 Applications need OData and How You can be a Data Ninja" and "Gaining the Knowledge of the Open Data Protocol (OData)". Chris Woodruff is a...
OData V4.0 Approved as a New OASIS Standard
17 Mar 2014 • Mike PizzoI am thrilled to announce that OData V4.0 has officially been approved as a new OASIS standard. OData V4 is the result of a year and a half of hard work from the OASIS Technical Committee, addressing over 500 issues/requests through two committee specifications and three public reviews. Below are...
Recent updates planned for OData.org
24 Feb 2014 • Yi DingSince the new OData.org site was published, we have received a lot of feedback. Most of those who have provided feedback want to contribute to the OData ecosystem by publishing their OData tools, asking about libraries which were shown on the old site, reporting bugs in the sample services, asking...
Welcome to the new OData.org site
19 Feb 2014 • Mark StaffordWelcome to the new OData.org site. It's now more concise and is easier for you to find out the most important contents about OData. If you have any advice or suggestion about this site or about OData, please feel free to contact us using the contact form. We will be...
New version of OData Validator
28 Oct 2013 • Mark StaffordThe OData team has been working on updating the OData Validator tool to support the new JSON format validation. We are pleased to announce that the tool now supports validating your V3 service for all three formats – ATOM, old JSON format (aka JSON Verbose) and the new JSON format....
OData V4 Extensions for Aggregation
05 Sep 2013 • Mike PizzoI am pleased and excited to announce that the OASIS OData Technical Committee has produced a Committee Draft for a set of extensions to OData for Data Aggregation. This extension adds basic grouping and aggregation functionality (e.g. sum, min, and max) to OData without changing any of the base principles. The draft...
ODataQueryBuilder: a JavaScript library for building OData queries
27 Aug 2013 • OData.org ArchiveThe objective: standardizing on an abstraction We are a team from Microsoft that is responsible for internal data and operations. As you can imagine, there are a variety of services modeling various aspects of operation (Inventory, Support Teams, Supply Chain, Telemetry, Incident Handling, etc.) and each are implemented in different...
Consuming OData from JavaScript
15 Jul 2013 • OData.org ArchiveThis tutorial will introduce the OData capabilities of the JayData library and gives you all the necessary information to succeed with your OData service via JavaScript. After going through the concept, we will implement a Northwind product editor – full read/write capable - app with JayData and jQuery. We will develop a HTML5/JavaScript client...
OData Version 4.0 enters 30-Day Public Review
03 May 2013 • Mike PizzoLast Friday the OASIS OData Technical Committee voted unanimously to progress the OData Version 4.0 spec to public review. The official announcement was sent out yesterday, kicking off the 30 day review. The announcement includes links to the public review documents for the Core Protocol, Atom, and JSON specifications, and instructions...
How to use SQL Spatial Data with WCF ODATA Spatial
10 Mar 2013 • Qian LiNote: The below code is extracted from a working Windows Azure project on Visual Studio 2012. You may need to adapt it for your purpose. A quote with our contribution in your code will be highly appreciated. Abstract With the emerging demand of “Global Monitoring” and the introduction of new...
Introducing a Capabilities Vocabulary
11 Jan 2013 • OData.org ArchiveAs OData becomes richer, individual services may support a range of capabilities beyond a core basis of OData functionality. Even within V1 functionality different services may support different sets of functionality, for example updatability. Generic consumers that want to adapt based on service capabilities require a dynamic way of determining...
OASIS OData Technical Committee Call for Participation
11 Jun 2012 • OData.org ArchiveOASIS announced today the Call for Participation for the new OASIS OData Technical Committee tasked with the responsibility of producing the OData Standard. In addition to the core OData version 3.0 protocol found here, the Technical Committee will be defining some key extensions in the first version of the OASIS...
Using Schema.Org Vocabularies with OData
11 Jun 2012 • OData.org ArchiveWith the introduction of data and metadata annotations to OData version 3.0, developers can now define common vocabularies for things like Sales (with Customers, SalesOrder, Product, etc.), Movies (with Title, Actor, Director, ....), Calendars (with Event, Venue, …), etc. Of course, such vocabularies are only useful to the extent that...
OData submitted to OASIS for standardization
24 May 2012 • OData.org ArchiveI’m happy to announce that Citrix, IBM, Microsoft, Progress Software, SAP and WSO2 are jointly submitting a proposal for the standardization of OData to OASIS. While the OASIS OData Technical Committee will standardize OData, the great collaboration will continue in the odata.org community to grow the library of producers and...
OData V3 demo services
11 May 2012 • OData.org ArchiveIn April we shipped the OData version 3 along with the 5.0 release of WCF Data Services. To make it easier for you discover the new features and for us to show you some of them, we’re now making available the OData demo services which use the OData V3 protocol....
JSON Light Sample Payloads
17 Apr 2012 • OData.org ArchiveWe recently put together a document that contains some of our thinking about JSON light as well as a whole slew of sample payloads. We would love to hear any feedback you have on the format; you can comment in the accompanying OneNote. We will be accepting public feedback on...
OData meetup
26 Mar 2012 • OData.org ArchiveThis week we had our first OData meetup hosted by Microsoft. People representing 20+ companies came together to learn from other attendees’ experiences, chatted about everything OData, and enjoyed the food, beverages and awesome weather (no, really!) in Redmond. We had some great presentations Mike Pizzo had fun stories on...
OData Service Validation Tool Update: Ground work for V3 Support
28 Feb 2012 • OData.org ArchiveOData Service Validation Tool was updated with 5 new rules and the ground work for supporting OData v3 services: 4 new common rules 1 new entry rule Added version annotation to rules to differentiate rules by version Modified the rule selection engine to support rule version. Change rule engine API...
OData Service Validation Tool Update: 7 new rules
30 Jan 2012 • OData.org ArchiveOData Service Validation Tool was updated with 7 more new rules: 6 new common rules 1 new entry rule This rule update brings the total number of rules in the validation tool to 147. You can see the list of the active rules here and the list of rules that...
Format efficiency take 2: really clean JSON
19 Jan 2012 • OData.org ArchiveIt took me longer than expected to write again about this, but I have another round of measurements and another proposal that goes with it. Since folks want to close on the next version of OData soon, it would be great to iterate quickly on this one so if we...
OData Service Validation Tool Update: 4 new rules
13 Jan 2012 • OData.org ArchiveOData Service Validation Tool was updated with 4 more new rules and couple other changes: 2 new common rules 2 new entry rules Added new rule targets for Link, Property and Value payload type (targets that we used to call Other) Added Not Applicable test result category to all code...
OData Service Validation Tool Update: 10 new rules
24 Dec 2011 • OData.org ArchiveOData Service Validation Tool is updated with 10 more new rules to mark the end of a very productive year. Below is the breakdown of newly added rules: 2 new common rules 1 new metadata rule 2 new rules for Link 5 new rules for Property This rule update brings the...
iOS Client Library goes Open Source
20 Dec 2011 • OData.org ArchiveI’m pleased to announce that the OData client for iOS, OData4ObjC, is now a full, community-supported Open Source project. It can now incorporate all those contributions and bug fixes that you’ve been mentioning on the mailing list. The Open Sourcing of the OData client library for Objective C will enable...
OData Service Validation Tool Update: 18 new rules
09 Dec 2011 • OData.org ArchiveOData Service Validation Tool is updated with 18 new rules. Below is the breakdown of added rules: 1 new feed rule 8 new entry rules 9 new other rules (rules for $value payloads – will find a better name for these rules) This rule update brings the total number of...
OData Service Validation Tool Update: 12 new rules
22 Nov 2011 • OData.org ArchiveOData Service Validation Tool is updated once again with 12 new rules. Below is the breakdown of added rules: 2 new common rules 2 new metadata rules 3 new feed rules 5 new entry rules This rule update brings the total number of rules in the validation tool to 109....
OData Service Validation Tool Update: 19 new rules
08 Nov 2011 • OData.org ArchiveLately the main focus for the OData Service Validation tool has been on increasing the rules in the system. In the last two weeks total of 19 new rules have been added: 3 new common rules 8 new metadata rules 3 new feed rules 5 new entry rules This rule...
OData Service Validation Tool Update: New feature and rules
25 Oct 2011 • OData.org ArchiveWe pushed another update to http://validator.odata.org and the Codeplex project: Added the crawling feature with UI support Added 2 new rules for Metadata Minor bug fixes for 3 rules Changed XML rules version definition I’d like to highlight the new crawling feature. Since we launched one of the requests that...
Geospatial Properties
14 Oct 2011 • OData.org ArchiveOData supports geospatial data types as a new set of primitives. They can be used just like any other primitives—passed in URLs as literals, as types and values for properties, projected in $select, and so on. Like other primitives, there is a set of canonical functions that can be used...
Actions in OData
07 Oct 2011 • OData.org Archive“Actions will provide a way to inject behaviors into an otherwise data centric model without confusing the data aspects of the model, while still staying true to the resource oriented underpinnings of OData." Motivation: When a client GETs a resource over HTTP it learns about the content type (perhaps HTML)...
OData Service Validation Tool Available on Codeplex
26 Aug 2011 • OData.org ArchiveWe are happy to announce that the OData Service Validation Tool is now an Outercurve project and is available on Codeplex (http://bit.ly/nqEVlH). We released it in such a way that the tool is fully open source and we will be able to accept contributions. This is something we are very...
OData Service Validation Tool Update
10 Jun 2011 • OData.org ArchiveWe pushed a new update to the OData Service Validation Tool. As you know we are updating the service every 2 weeks. Below is what's new in this update: Added 5 new JSON rules. Including the new rules pushed 2 weeks ago we now have a total of 16 JSON...
OData Service Validation Tool Updated – JSON Payload Validation and new rules
19 May 2011 • OData.org ArchiveWe pushed another new update to the OData Service Validation Tool last Friday. This update has the following: Added support for JSON payload validation. Added 9 new JSON rules Added 2 new Atom/XML metadata rules Updated 4 Atom/XML rules (3 metadata and 1 feed) As always, please give it a...
Geospatial data support in OData
03 May 2011 • OData.org ArchiveGeospatial data support in OData This is a strawman proposal. Please challenge it in the OData mailing list. OData supports geospatial data types as a new set of primitives. They can be used just like any other primitives - passed in URLs as literals, as types and values for...
Update to OData Service Validation Tool
02 May 2011 • OData.org ArchiveWe pointed out when we announced the OData Service Validation Tool at Mix the other week, we are actively working on it and would add more rules to the service on a regular cadence. We just pushed an update to the service with the following: Added 3 new metadata rules...
Announcing datajs version 0.0.3
13 Apr 2011 • OData.org ArchiveThe datajs team recently announced an updated version of datajs (version 0.0.3). Highlights include the ability to use HTML5 storage capabilities to cache data from an OData source and read it back later. Here's code that does just that: var cache = datajs.createDataCache({ name: "movies", source: " http://odata.netflix.com/Catalog/Titles?$filter=Rating eq 'PG'"...
OData Service Validation Tool
13 Apr 2011 • OData.org ArchiveOData is released under the Microsoft Open Specification promise. This allows anyone to create OData services that implement the specification and to freely interoperate with OData implementations. Currently there are several OData service producers and server libraries including .Net Framework, Java, Rails and several client libraries across a range of...
Reference Data Caching Walkthrough
13 Apr 2011 • OData.org ArchiveTim Laverty from the DataFX team at Microsoft just posted a walk-through showing how to setup reference data caching using the recently released ' Reference Data Caching CTP' (aka the 'Microsoft WCF Data Services For .NET March 2011 Community Technical Preview with Reference Data Caching Extensions'). Take a look and...
Updated OData Client for Objective-C
12 Apr 2011 • OData.org ArchiveI am pleased to announce the second bug fix release of the OData Client for Objective-C library. This V1.2 release contains fixes for 36 bugs reported on codeplex.com since the last September release. This also adds support for basic authentication with Windows Azure MarketPlace DataMarket, formerly code named "Dallas", along...
An efficient format for OData
25 Mar 2011 • OData.org ArchiveThe need for a more efficient format for OData has been coming up often lately, with this thread being the latest on the topic. I thought I would look into the topic in more detail and take a shot at characterizing the problem and start to drill into possible alternatives....
Reference Data Caching
16 Mar 2011 • OData.org ArchiveWhat is reference data caching? One of the comments I hear from customers building apps that use OData is they aren't always connected to their data source and often want to cache data on a client. This allows their applications to function while "off-line", to perform better, and to allow...
Vocabularies
21 Feb 2011 • OData.org ArchiveWhat are vocabularies? Vocabularies are made up of a set of related 'terms' which when used can express some idea or concept. They allow producers to teach consumers richer ways to interpret and handle data. Vocabularies can range in complexity from simple to complex. A simple vocabulary might tell a...
Even more Any and All
15 Feb 2011 • OData.org ArchiveI was talking to a few people last week and one of them suggested another change in the any/all syntax. The more I looked at it the more I liked it. In fact when I asked a few of people over twitter it seemed everyone else liked it to. The...
New JavaScript library for OData and beyond
09 Feb 2011 • OData.org ArchiveMicrosoft just announced a new project called 'datajs'. datajs is a cross-browser JavaScript library that among other things brings comprehensive OData support to JavaScript. 'datajs' is an open source project, released under MIT. For example if allows you to query an OData service like this: OData.read("http://odata.netflix.com/v1/Catalog/Genres", function (data, response) {...
More Any and All
08 Feb 2011 • OData.org ArchiveThe Data Services team has starting thinking about adding Any/All support to Data Services and we noticed a couple of things that I think warrant minor changes to the proposal. So as always I wanted to share and get your thoughts. New separator The original any/all proposal suggested using a ','...
Support for Any and All
11 Nov 2010 • OData.org ArchiveOne thing that folks in this list and elsewhere have brought up is the need to express filters based on the contents of a collection, be that a set of related entities or a multi-valued property. This is because currently there is no easy way to: find all movies starring...
New OData Producers and Consumers
28 Oct 2010 • OData.org Archiveoday at PDC Microsoft announced a set of new and exciting OData producers and consumers: ebay now exposes its catalog via OData SAP is working to add OData support to its next generation of products Twitpic now exposes its Images, Users, Comments etc via OData Facebook Insights has updated its...
Enhancing OData support for streams
18 Oct 2010 • OData.org ArchiveOData has good support for streams via the ATOM concept of Media Link Entries (MLE) and Media Resources (MR). A Media Resource is a unstructured piece of data or stream, something like a Document, Image or Video. And the way that you access or learn about a Media Resource is...
Support for Http PATCH
18 Oct 2010 • OData.org ArchiveOData has supported two types of updates for a while now: Replace Semantics via a standard PUT: this updates the whole entry with what has been provided on the wire, so any properties missing from the wire will be reset to their default values. Merge Semantics via a MERGE tunneled...
Adding support for Bags
27 Sep 2010 • OData.org ArchiveProblem Statement Today entries in OData (Customer, Order, etc) may have properties whose value are primitive types, complex types or represent a reference to another entry or collection of entries. However there is no support for properties that *contain* a collection (or bag) of values. For example, a sample entry which...
Enhancing OData support for querying derived types - revisited
06 Aug 2010 • OData.org ArchiveAbout a week ago we outlined some options for enhancing OData support for querying derived types. From there the discussion moved to the OData Mailing list, where the community gave us very valuable feedback: Everyone seemed to like the idea in general - evidenced by the fact that all debate...
Enhancing OData Support for querying derived types
30 Jul 2010 • OData.org ArchiveProbably the most frequently requested addition to OData is better support for derived types in queries. What does that mean exactly? Background: Today if you have a model like this: Assuming you have a People set - as is usually but not always the case - and you try...
OData Client for Objective-C
22 Jul 2010 • OData.org ArchiveWe are happy to announce that today we released the OData Client for Objective-C library. With the library it is now possible to write iOS applications that connect to OData Services. The library includes a command line tool to generate proxy classes for the Entities expose by the OData Service...
Join the OData Mailing List
28 Jun 2010 • OData.org ArchiveToday we released an OData Mailing List. This is the list to use if you have OData questions, comments on OData or want to discuss how OData should evolve over time. To sign up to the list go here and follow the instructions provided. The list is fully open so...
OData Workshops in Raleigh, Charlotte, Atlanta, Chicago and NYC
01 Jun 2010 • OData.org ArchiveChris (aka Woody) Woodruff has organized a series of OData workshops to compliment the official OData Roadshow. This is highly recommended. So if for whatever reason you can't make it to one of the OData Roadshow events, or you just can't get enough OData, see if you can get along...
OData Roadshow
12 May 2010 • OData.org ArchiveIn case you haven't heard already we are putting on an OData Roadshow. Douglas Purdy and Jonathan Carter will be presenting and guiding attendees through a free day's worth of OData goodness. The Roadshow will visit each of these locations: Chicago, IL - May 14, 2010 Mountain View, CA - May 18,...
OData Roundup #3
07 May 2010 • OData.org ArchiveMany exciting things have happened in the OData world since our last post. We released the source code for our .NET client library on codeplex. We announced the OData Roadshow which will visit: New York, Chicago, Mountain View, Shanghai, Tokyo, Reading and Paris in the coming months. See if you...
OData and Messenger across the web
06 May 2010 • OData.org ArchiveThe Windows Live team recently started talking about the new version of Messenger, which will include a RESTful interface that supports OData. This is a very exciting development for the OData ecosystem. Read all about it here.
The Open Data Protocol .NET Framework Client Library – Source Code Available for Download
26 Apr 2010 • OData.org ArchiveWe are happy to announce that we have made the source code for the .NET Framework 3.5 SP1 and Silverlight 3.0 Open Data Protocol (OData) client libraries available for download on the Codeplex website. This release represents the OData team's continued commitment to the OData protocol and the ecosystem that...
Queryable OData Metadata
22 Apr 2010 • OData.org ArchiveToday if you browse an OData service there are two ways to learn about it: Service Documents and $metadata. The question is this: Would it be useful to add more metadata capabilities to the protocol? Service Documents You can look at the 'Atom Service Document', available from the root...
OData weekly roundup #2
13 Apr 2010 • OData.org ArchiveSince the last roundup, we've received a ton of new feedback and there have been some really exciting new developments too. Heres the last couple of weeks feedback: OData Wiki: As mentioned last time there is now a OData community wiki called ODataPrimer. We had originally planned to create a...
OData weekly roundup #1
26 Mar 2010 • OData.org ArchiveIt's been a little over a week since the new OData.org went live, and in that time we've had plenty of interesting feedback. Thank you! Here are some of the suggestions we've received: Open Source the .NET Server libraries too (we announced and will release the .NET client libraries under...
Got SQL Azure? Then you've got OData
18 Mar 2010 • OData.org ArchiveIn his MIX Keynote this week, Douglas Purdy demonstrated a new OData Service for SQL Azure. I am pleased to announce that a preview of this exciting technology, providing the quickest no-code solution for bringing your SQL Azure data into the growing OData ecosystem, is available to all SQL Azure...
Update on the open source .NET Data Services Client
17 Mar 2010 • OData.org ArchiveAt Mix10 we announced that we are open sourcing, under the Apache license, the WCF Data Services client code, which of course illustrates our commitment to fostering a vibrant OData Community. Right now we're getting the code ready, which should take about a week or two, so you can expect...