Odata Post Example

This blog post provides you with an sample round trip example (create – read – update – delete) using ByD OData services for product business objects. Is there a way to configure TD and/or TS to handle JSON?. i have a Sharepoint list with DelegationFrom(Person field), in flow instead of retrieving all the items i need to retrive the one item. Therefore it contains the Explaining the Client section which explains how to implement the CRUD operations based on sample code and a Client Quickstart Guide which give a step by step guide to create a sample and server to see both together in action. Before proceeding further we assume that you know how to build OData service in sap gateway. In this example, we are going to create our REST application in. During my normal project work I got introduced to this term in an ESS-MSS Project I was working on. In the REST services a type of data access operation is defined using the type of HTTP request that is sent using the following rules: HTTP GET request is used to read data; HTTP POST request is used to update existing entity. We will work on the same ZGW_PO_SRV service of the earlier post and add more complexity and features to dive deep into OData implementation and put forth the concept behind it. org sample webservice. It follows REST architecture. Note that the Service Operation is just an example there to show StackOverflow that they CAN have total control. But Atom says there can only be one content element per entry. The service reference - I changed it to match the Odata service field in the web services table, From the web service table I can press the icon and it brings up info about the service in Internet Explorer. 0 representation, for requests containing an OData-Version header with a value of 4. Add columns to "order by" and filter on and the REST URL + Querystring will be build for you. All about open data and systems with the OData protocol. In that post it was demonstrated how to call NAV OData web services from C/AL code and read data without using any custom dll. For example, POST request are considered more secure than GET request as creating a POST request is relatively harder than creating a GET request. I want to see whether odata api calls from salesforce working or not. Postman sample OData queries. NET, In my example, the MVC Music Store contains several hundred albums, so this is a large list. NET Web API allows you to write a service once and provide different output formats with little effort on the developer's side. Srujan Redmond, United States I am a tech savvy working on Microsoft Technologies with expertise in. It shows a tree-view over the message body (only applicable for POST and PUT requests). I have made some tests on these options. Repost of Mike McLean's Reporting Post. Details: After reading Brian Smith's blog post about using Planner to monitor/track changes to Office 365, I started investigating the Office 365 Service Communications API. 1) Types of Web Services. 5, all of jQuery's Ajax methods return a superset of the XMLHTTPRequest object. Continue to the next section for more in-depth documentation. But there are several occasions when POST is necessary when creating a ajax request. An OData request uses the REST model for all requests. Intercepting and post-processing OData queries on the server. Postman sample OData queries. Subscribe to: Post Comments (Atom) About Me. So, let’s build and run the Web Application. In VS it's ok, but with Eclipse, the extension for odata. In this post, we will deal with API changes and newly-added features. On Power BI side, to get the data use Odata feed data source, for example Dynamics CRM, you can take a look at this article: Prefilter data for Power BI with OData URLs. You can use filter and query expressions in OData URIs to limit the results that are returned. OData query cheat sheet. XOData® : OData Visualizer and Explorer. You can read the first part of this blog here. I had a request from a reader asking for a CRUD example using DataJS. There is also a curl parameter to include if you use http or https call (for authentication). NET Core's MVC/API implementation. All entities defined in Captia’s data dictionary are exposed through this API. Though I would love to go on about REST protocol, a practical, simple example of this in action will be beneficial. By continuing to browse this site, you agree to this use. So, let's build and run the Web Application. Microsoft OData team - [Tutorial & Sample] Use Enumeration types in OData. If you want to develop a simple RESTful API in ABAP, you might find a bit complicated dealing with OData limitations and NetWeaver Gateway configuration. When configuring an OData controller, there are other annotations that can be helpful. #2 Test the OData Service. OData services are REST services so data modification operations are also allowed. NET Web API 2 OData NuGet package. This blog post provides you with an sample round trip examples of price components (create - read - update - delete) using ByD OData services for service order business object. Though I would love to go on about REST protocol, a practical, simple example of this in action will be beneficial. July 22, experience a little bit. Create Azure Application Open Azure portal. All about open data and systems with the OData protocol. OData for developers. Using PowerShell's Invoke-RestMethod to Access VSTS OData Posted by Mark Michaelis August 23, 2016 August 29, 2016 Leave a comment on Using PowerShell's Invoke-RestMethod to Access VSTS OData Given that Microsoft has abandoned their TFS CmdLets, one alternative is to access VSTS data is through the OData interface using the Invoke-RestMethod. We will show some basic examples. NET applications. Advanced | Flow of the Week: Filtering Data with OData Kent Weare , Principal Program Manager, Microsoft Flow , Wednesday, February 28, 2018 OData (Open Data Protocol) is an OASIS standard that establishes best practices for designing RESTful APIs. This means that you can override the Get, Post, Put, Patch, Delete and other actions and add your own logic. Given SQL based user query, Teiid is capable of converting that request into a REST based OData call and fetch the results automatically and provide them in a. This is the first post of a mini series about creating an opinionated ASP. Introduction Post on OData. substringof. OData for Visual Studio Code. This is a collaborative document to share lessons learned contents for OData and Gateway in the community SAP Fiori. Step-By-Step OData 4 / TypeScript / AngularJs / CRUD Sample On February 22, 2016 in OData by Michael Washington OData 4 allows you to create back-end services for your web applications with minimal code because it allows the client code to query the entities. C# (CSharp) System. Odata V4 Client Generator for VSCode This extension targets to speed up access to an oData service to use it within typescript. The OData Endpoint allows you to retrieve all raw data out of Cognigy. Leveraging WCF HTTP capabilities, WCF Data Services implements OData for. These verbs are used to READ, CREATE, UPDATE, and DELETE records respectively. Sample code for creating Odata V4 Source API for D365 Virtual Entities Post a Comment. jsreport API can be split into the two main use cases: Rendering reports - use it when you need to invoke the report rendering process; Querying and CRUD - use it in more complex jsreport integration in which you want to update or synchronize entities using API. Add columns to "order by" and filter on and the REST URL + Querystring will be build for you. NET Web API feat. OData for Visual Studio Code. OData filtered query. post method. node-odata is written by ECMAScript 6 then compiled to ECMAScript 5 by babel. Building a simple OData Endpoint using ASP. Examples of both common and more obscure use cases for XMLHttpRequest are included. The OData standard defines a set of rules and guidelines that are derived from common web technologies that include HTTP, REST, XML, and JSON. Test the OData service in the gateway client, you should see a success response like below with HTTP response code as 200. I am now creating a structure in the data dictionary with the required input and output fields as none of the generated fields had both input and output fields in one structure. I had never used oData before, so the learning curve was large for me. Then you need to start coding. json file for VSCode settings applicable to this extension. Apache Olingo provides libraries which enable developers to implement OData producers and OData consumers. RESTful applications use HTTP requests to post data to create or update, read data and delete data. CRUD operation oData This step-by-step post describes how to UPDATE, DELETE & MODIFY record into table using GET_ENTITY method in oData service. Header Name Description Type Additional information; Accept Mime Type: The accept header used to specify the acceptable response mime type. – How to create an OData model using SEGW transaction July 22, 2014 December 17, 2014 Peter Marcely OData , OpenUI5 / SAPUI5 Tutorial , SAP Netweaver gateway In this first part of tutorial, I am going to show how to prepare a data model using SEGW transaction. Here you see the sample implementation that enables inserting of new customers in our ASP. The OData endpoint is a new REST-based service that allows for integrating with Dynamics 365 for Operations. id, therefore a lot more data is rendered). The DELETE operation uses the HTTP "DELETE" method. You need to prepare a database table that will be used for storing data. 5, all of jQuery's Ajax methods return a superset of the XMLHTTPRequest object. So modify the above code to add the message. In the service proxy, you can apply these options by using various LINQ expressions. Getting List of Entities. This solution relies on the Microsoft. Why should I use OData? As APIs continue to explode, each organization exposes its own unique REST/SOAP/Bulk APIs for consuming their data. Consumption. To use an OData feed, just "Get Data" and choose the OData option (the "Web" option also works with OData feeds). Is there a way to configure TD and/or TS to handle JSON?. Currently OData is widely used for exposing data. OData version: The OData version to be used by this activity. In the read mode, an OData query is sent to the library input, it is parsed using the Microsoft. The same version need to use across all the activities in a single orchestration. Record of Table SCARR: Step 1: Go to the TCode:…. Subscribe to: Post Comments (Atom) About Me. This integrated example of how to build an SAP Fiori application provides a step-by-step approach for how to transfer SAP materials management data onto a mobile device. I need to convert my custom class (c#) object into OData Json format and then convert it back to my object. In computing, Open Data Protocol (OData) is an open protocol which allows the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way. The OData MySQL example on this page shows how to use an HTTP-based data service to query a MySQL database. OData Reporting in PWA. NET Web API, HTTP, OData, REST. MapODataServiceRoute method with the conventional configuration. ajax({type: "POST", contentType: "application/json; charset=utf-8",. To perform an ODATA call, we need to add jquery1. The sample that I planned to write had to demonstrate capabilities of an OData library, and NuGet is definitely the most popular OData feed among developers. This topic contains a reference for construction filters and queries for OData URIs. Intercepting and post-processing OData queries on the server. knowing the OData primitive and structured types, knowing the basic OData URL conventions, knowing the basic OData features such as operations, queries and so on) and would like to explore how some advanced scenarios can be implemented using Web API for OData. Client ClientEdmModel - 30 examples found. OData (Open Data Protocol) is a web protocol for performing CRUD operations which is built upon web technologies like HTTP, Atom Publishing Protocol (AtomPub) and JSON to provide access to the data to various applications, services and stores. NET CORE Web Application. (I pick SEL as an example because LogService entries are meant to be expanded into the collection instead of linked via @odata. It shows a tree-view over the message body (only applicable for POST and PUT requests). To initiate the solving process, use the following API endpoints to POST the model to the Rason Server, solve the workflow and automatically create an OData endpoint, check the status of the solve and finally obtain the results. AI exposes a OData v4 analytics endpoint to retrieve analytics records and conversations. OData Reporting in PWA. Anubhav Oberoy 148,727 views. Newer Post Older Post Home. Since OData is a standard protocol, you can easily find more advanced examples on the web. Moreover this post aims to provide first insights about the way to…. You can go through this article to know available OData query string options. Once it's running, we can use any client tools (for example, Postman ) to issue the following request ( remember to change the port in the URI ):. An UPDATE is performed with an HTTP "PUT". Obviously we used the asset major type as an example but you can use any standard data entity or even your custom data entity as long as isPublic property is set to Yes. Here is the simple example on testing the Odata actions in D365, using a tool called 'Postman'. NET application. How to Configure the OData Service in Dynamics GP. The URIs for the related entities created aren’t returned. Note that the Service Operation is just an example there to show StackOverflow that they CAN have total control. Batch DefaultODataBatchHandler. OData provides both a standard for how to represent your data and a metadata method to describe the structure of your data, and the operations available in your API. C# (CSharp) Microsoft. Postman sample OData queries. This blog post introduces the new SSIS data source as well, but has an interesting caveat when using Office 365 authentication: Using the SSIS OData Source Connector With SharePoint Online. With an extremely intuitive interface, you can easily see which endpoints are available, and even interact with them in the web browser!. OData by Example The OData protocol supports GET, POST, PUT/MERGE, and DELETE HTTP verbs for its RESTful operations. You can go through this article to know available OData query string options. This post describes how to use INSERT record into table using oData service. OData 4 supports Actions and functions. Safe Harbor Safe harbor statement under the Private Securities Litigation Reform Act of 1995: This presentation may contain forward-looking statements that involve risks, uncertainties, and assumptions. I'm noting using the Microsoft Default WCF OData. Important Note : Version 1. From reading the RFC specification of the Patch verb it's clear that the `Patch` verb shouldn't get values to partially update the entity but operations to make: "With PATCH, however, the enclosed entity contains a set of instructions describing how a resource currently residing on the. In summary, I have explained how to configure and consume simple CRUD operations for the asset major type data entity using OData services and. However there are cases, when REST provides a simple (or even the only available) solution. This service implements the OData protocol, and it also uses the abstractions of the OData data model to translate data between its underlying form, which might be relational tables, SharePoint lists, or something else, into the format sent to the client. NET Web API site is to pull in the ASP. This is a collaborative document to share lessons learned contents for OData and Gateway in the community SAP Fiori. Basically anything that isn't a simple text field. The core specification for the protocol is in [OData-Protocol]; this document is an extension of the core protocol. Before proceeding further we assume that you know how to build OData service in sap gateway. Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL. NET Web API 22 January 2013 on Entity Framework, ASP. Pages fetched with POST are never cached, so the cache and ifModified options in jQuery. NET Web API feat. I decided to write a simple NuGet package finder with three pages: a page to specify package search criteria, a result page with a list of matching packages and a page with package details. This filter returns the field values containing specified string. That field must be sent in the header of the "Patch" call (with curl). You can use the APIkit OData Extension to expose a legacy API as an OData API, orchestrate data before exposing it in Salesforce, or create a bidirectional OData API for Oracle, DB2, or Azure DB, for example. By the way, with transaction code SE43 it is possible to create folders for the Easy Access Menu which pop-ups when the SAP NetWeaver opens. Home » Articles » Misc » Here. However I'm getting stuck because I don't know how to add the service reference in our eclipse environment. Now our next step to step is add the some success, warning message to this response. We recommend using the Grant type client credentials, and make sure you select the API in the scope. Sample code for creating Odata V4 Source API for D365 Virtual Entities Post a Comment. On Power BI side, to get the data use Odata feed data source, for example Dynamics CRM, you can take a look at this article: Prefilter data for Power BI with OData URLs. During my normal project work I got introduced to this term in an ESS-MSS Project I was working on. Hi @ericleigh007,. Apache Olingo provides libraries which enable developers to implement OData producers and OData consumers. For example, the following request body posted to the Account entity set will create a total of four new entities in the context of creating an account. SensorRequest. So my question is, Is it going to be possible to try odata api call in salesforce with taking some sample server and request url?. In the REST services a type of data access operation is defined using the type of HTTP request that is sent using the following rules: HTTP GET request is used to read data; HTTP POST request is used to update existing entity. Microsoft initiated OData in 2007. More Comprehensive Documentation about ODATA Example POST. Recently I worked with two customers who wanted to show their external data on SharePoint Online web sites, one from on-premise SQL Database and one from their secured internal data source. This topic provides instructions for working with OData and ALM Octane. Using OData to query data is pretty straight forward. Menu Getting started with OData services in ASP. The OData service is ready to run and can provide basic functionalities, for example to query the metadata (XML representation of the EDM). on April 4, 2015 • ( 14). The complete solution also includes source code for the API, the shared models library, and the authentication server. 2 for OData with strong CRL types. In the read mode, an OData query is sent to the library input, it is parsed using the Microsoft. Functions and actions both MAY bound to an entity type, primitive type, complex type, or a collection. OData query options. Menu Getting started with OData services in ASP. In that post it was demonstrated how to call NAV OData web services from C/AL code and read data without using any custom dll. For example, the meta_objectURI attribute of an object is the full URL to the instance of the object which is held by the OData service. Note that WCF Data Services (previously known as ADO. When we run Fiddler, and click the Complete button, we can see the call to the OData endpoint and the JSON payload that is returned. could you please help me how query persons field i. Batching makes it possible to send many HTTP requests as a single multiple mixed request. Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL. We will work on the same ZGW_PO_SRV service of the earlier post and add more complexity and features to dive deep into OData implementation and put forth the concept behind it. 01 services MUST support both the OData 4. post method. 2) Differences between types of web services. For example, POST request are considered more secure than GET request as creating a POST request is relatively harder than creating a GET request. Getting started with Web API and OData V4 Part 1. You can easily format an OData date-time value to any custom date, time, or date-time. OData Translator - Using this translator, you can bring in any OData sources as part of virtual database you create in Teiid and integrate this source's data with any other sources. The DELETE operation uses the HTTP "DELETE" method. This entry was posted in Azure AD, Office 365, PowerShell. You get complex service handling without any coding. I don't have endpoint url/server url. This Tutorial shows how to use the Apache Olingo Library for CRUD operations on an OData Service. Using OData to query data is pretty straight forward. First Look: Querying Project Server 2013 OData with LINQPad October 21, 2012 July 27, 2013 Andrew Lavinsky As I gradually immerse myself into the world of Project Server 2013, one of the major changes I’ve been forced to come to grips with is the new method of querying Project Server data through OData. If the format is it works perfectly. Use it to select the colums that you want to get using the new SharePoint REST API. Sample code for creating Odata V4 Source API for D365 Virtual Entities Post a Comment. It will make your collection portable to other projects. NET, In my example, the MVC Music Store contains several hundred albums, so this is a large list. You can go through this article to know available OData query string options. Test the OData service in the gateway client, you should see a success response like below with HTTP response code as 200. OData in general has difficulties with DateTime, choice, or people columns. This blog is intended to use detail examples to illustrate how to configure/route/invoke functions and actions, for both bound and un-bound, in Web API V2. NET Data Services) is the implementation of Open Data Protocol in. Therefore it contains the Explaining the Client section which explains how to implement the CRUD operations based on sample code and a Client Quickstart Guide which give a step by step guide to create a sample and server to see both together in action. ClientEdmModel extracted from open source projects. get Measures List. Other important functionally in any API is to perform CRUD (Create, Read, Update and Delete) operation. Here are some example requests to the controller defined above. This integrated example of how to build an SAP Fiori application provides a step-by-step approach for how to transfer SAP materials management data onto a mobile device. This Tutorial shows how to use the Apache Olingo Library for CRUD operations on an OData Service. OData for Visual Studio Code. When you create a new record by using an OData client, as shown in example 1, properties that aren't set are included in the body of the request, and default values are assigned to them. It assists in rapid prototype, verification, testing and documentation of OData APIs including OData services provided by SAP NW Gateway, Microsoft Azure Marketplace, Office-365, SuccessFactors, SAP HANA etc. It shows a tree-view over the message body (only applicable for POST and PUT requests). OData (Open Data Protocol) is an OASIS standard that defines the best practice for building and consuming RESTful APIs. OData is an application-level protocol that has been designed to provide data interaction operations via HTTP. In an earlier post I discussed what OData is all about and how you can consume OData services using plain HTTP requests. NET app must instantiate or implement. I don't have endpoint url/server url. For example, using a SalesTable entity to create an Odata action to confirm or invoice the sales order. Postman sample OData queries. Menu Why your [FromBody] parameter is always NULL 12 May 2015 on asp. Pages fetched with POST are never cached, so the cache and ifModified options in jQuery. ALM Octane supports OData (Open Data Protocol), the OASIS REST-based standard for accessing data. I have the java web service running properly. 0 was standardized at OASIS, with a release in March 2014. We will work on the same ZGW_PO_SRV service of the earlier post and add more complexity and features to dive deep into OData implementation and put forth the concept behind it. This is the first post of a mini series about creating an opinionated ASP. Exposing a database as an OData service eliminates the need to define queries, operation etc. Intercepting and post-processing OData queries on the server. Step-By-Step OData 4 / TypeScript / AngularJs / CRUD Sample On February 22, 2016 in OData by Michael Washington OData 4 allows you to create back-end services for your web applications with minimal code because it allows the client code to query the entities. Today we'll discuss some of the changes to server reporting in the next version of Project Web App (PWA), including an introduction to the new OData service. The result is a uniform way to expose full-featured data APIs. I would like to acces the broker via OData in our java application. Expanding on this class, I added caching, and an example Service Operation, as well as WCF Data Services support for JSONP. First of all, there is some documentation on the filtering syntax here. In my opinion, OData indeed still has a place where it's valuable: as an implementation detail, serving as a data access layer for internal forms-over-data applications dealing with dozens, hundreds, or thousands of CRUD screens. Hello everyone, in this Netweaver Gateway tutorial we will learn how to use Deep Insert in SAP netweaver gateway OData service. Creating Reports using OData Feed in Power BI. Header Name Description Type Additional information; Accept Mime Type: The accept header used to specify the acceptable response mime type. The REST URI ends with any OData query operators to specify selecting, sorting, or filtering. org sample webservice. Find the example workflow below with two disconnected SQL Transformation stages. This API contains a lot of information, but this scenario requires only Message Center Updates. on April 4, 2015 • ( 14). In the REST services a type of data access operation is defined using the type of HTTP request that is sent using the following rules: HTTP GET request is used to read data; HTTP POST request is used to update existing entity. Please note that the method-name is case sensitive & only lower case works. This article gives an overview of using Oracle REST Data Services to developing RESTful web services using the PL/SQL API provided by the ORDS package. This document fits best the readers who has a relative good knowledge of OData (e. There are still ways to do it, but its more difficult. OData (Open Data Protocol) is an OASIS standard that defines the best practice for building and consuming RESTful APIs. And how to create Azure Active Directory Application and use it for authentication in Dynamics 365 for Sales and Dynamics 365 for Finance and Operations. I am doing work on ODATA, do we have a simple app that runs local and runs in sandbox. This blog post provides you with an sample round trip examples of price components (create - read - update - delete) using ByD OData services for service order business object. Introduction. And at Directions EMEA 2016, a few weeks ago, I demonstrated that it is possible to call NAV OData web services from C/AL, without any custom dll, using. The tool also provides the ability to implement custom OData services with Java. Use LINQPad to Query an OData Service This is going to be a brief post just to get you going with using the free LINQPad tool to query an OData Service. For basic tutorial of function and action, you can refer to Actions and Functions in OData v4 using ASP. As an example for anyone who is interested, here is a snippet of the OData metadata describing my Documents entity set, with filter restrictions:. I don't have endpoint url/server url. C# (CSharp) System. Please create the data as shown below. Remarks Sensor and Loop Number mapping Device type and Response type mapping Request Information URI Parameters. Microsoft initiated OData in 2007. Format an OData Date-Time Value to other Custom Formats. Insert the URL and click Next. To use an OData feed, just "Get Data" and choose the OData option (the "Web" option also works with OData feeds). To use an OData feed, just “Get Data” and choose the OData option (the “Web” option also works with OData feeds). For example, using a SalesTable entity to create an Odata action to confirm or invoice the sales order. 0 This package contains everything you need to create OData v4. for example. OData Conceptual Schema Definition Language (CSDL) JSON and XML: Michael Pizzo (Microsoft), Ralf Handl (SAP SE), Martin Zurmuehl (SAP SE) OData JSON Format: Ralf Handl (SAP SE), Michael Pizzo (Microsoft), Mark Biamonte (Progress Software). Microsoft recently released the OData source adaptor for Integration Services (SSIS). This is a collaborative document to share lessons learned contents for OData and Gateway in the community SAP Fiori. So that i can give ademo on how & wt is the functionality of Odata. ODATA is a simple REST-based API that allows the return of JSON objects matching the query parameters, but despite the documentation provided, there exists no concise quick reference for building your ODATA queries. On July 2018, Microsoft OData Team is announced general availability (GA) of OData (Open OData Protocol) on ASP. Newer Post Older Post Home. OData is an open standard protocol allowing the creation and consumption of queryable and interoperable RESTful APIs. Note that the Service Operation is just an example there to show StackOverflow that they CAN have total control. The TM1 REST API meets the. Find the example workflow below with two disconnected SQL Transformation stages. If you follow my blog you might already know that I am not a big fan of the REST / OData interface. Therefore it contains the Explaining the Client section which explains how to implement the CRUD operations based on sample code and a Client Quickstart Guide which give a step by step guide to create a sample and server to see both together in action. org; What is odata4j? odata4j is a Java framework that implements the OData protocol for both consumers (client-side) and producers (server-side) Getting started: Consuming OData. The table has the following field date, named birthday: When we execute the method GET in JSON format, we receive it in this way:. It will make your collection portable to other projects. In OData meta data is published in EDM format and REST is struggling to define the meta data standard as WADL or Swagger and many more. AOT queries with View data sources are therefore not OData query candidates and will not be displayed in an OData metadata request. This entry was posted in Azure AD, Office 365, PowerShell. Add(customerGroup);. Tip 1 – Parameterise as much as you can. OData services are REST services so data modification operations are also allowed. This means that you can override the Get, Post, Put, Patch, Delete and other actions and add your own logic. Intercepting and post-processing OData queries on the server. Versions 1. For example, the meta_objectURI attribute of an object is the full URL to the instance of the object which is held by the OData service. OData for developers. Activation of OData service. Tableau sample. In this post, I will try to explain how to query CRM data in easy to follow terms. JSONPlaceholder is a free online REST API that you can use whenever you need some fake data. In this article we can explore OData examples for string method startswith. NET CORE Web Application. October 25, 2012. node-odata is written by ECMAScript 6 then compiled to ECMAScript 5 by babel. Open Data Protocol (OData) 1 is a data access protocol to create Web services with query and update capabilities in a simple and standard way, thus allowing developers to easily expose and access information from a variety of data sources such as relational databases, file systems and content management systems.