Odata Batch Post Example

I think I have enough information to put together a repro. Usage Examples. The client PUTS following method example that modifies the entity selected by using key send. The header value must be of the format ': '. OData Services. I would like to acces the broker via OData in our java application. Written in VS2011, C#,. net HttpClient class anilkumarup. How to Create Gateway Services Using the OData Channel API Odata channel - with netweaver gateway SAP UI5, SAPUI5, SAP Fiori, SAP HTML5, SAP OData, SAPUX, SAPX03, SAPX04, SAPX05, GW100. In my case, I had an existing SQL Server database and wanted to expose a couple tables as an OData service, so I used the Entity Data Model, which is what this post will walk you through: building a simple OData Service using WCF Data Services. EX: Ø Trigger a GET request to the odata service that was specified in the Ø Creates a single batch. Ask questions any time. All examples in this page are based on the. ID == key ||. NET MVC (called MVC 5) and ASP. ODataBatch extracted from open source projects. While data modification requests represent a primary use of batch operations, OData batch protocol supports data retrieval (GET) operations that can be mixed with POST/PUT/PATCH/DELETE requests in a single batch. No, we don't have such an example. The batch response contains a Content-Type header specifying a content type of multipart/mixed and a batch boundary specification, which may be different from the batch boundary that was used in the corresponding request. Actions are operations exposed by an OData service that MAY have side effects when invoked. You can use it to query or CRUD programmatically any entity that jsreport server contains. js which will resolve the same package. The following example includes a batch with a unique identifier of AAA123 and a change set with a unique identifier of BBB456. X-CSRF-Token: Required. Dynamics AX 2012 and AX 2009 have the ability to breakdown a batch job into small manageable fragments and process them independently in parallel. 5, all of jQuery's Ajax methods return a superset of the XMLHTTPRequest object. Objects are serialized as an unordered collection of name/value pairs. While this SharePoint REST API greatly reduces network chatter, building a batch request is not so straight forward. A batch request consists of multiple API calls combined into one HTTP request, which can be sent to the batchPath specified in the API discovery document. I have already gone though the link "Gateway batch calls from SAPUI5", but still not able to figure out where am i going wrong. Understanding the OData Batch Request Header. In that application we have perform multiple retrieval operation from CRM (around 10) either using FetchXML or OData of different entities. This could be for several reasons. If you have your own repro that you can share, that will be immensely useful. OData is a widely accepted open standard for data access over the Internet. 2017! The business scenario is to create a material document with more than one item line, see following example: Therefor I need to post m. In a blank workspace, add a Directory and File Pathnames reader, and set the dataset to the Directory (folder) containing all the MapInfo MIF files you wish to batch process, for this example it will be the Data folder. AbpWebApiOData(). 7), and therefore, the presence of an X-HTTP-Method header in a Batch request results in a response containing a 4xx response code. There are two types of function supported by OData. Hi Everyone, I sometimes require a batch processing when doing CRUD operations in Header/Item scenarios. In In the previous post, I discussed how to implement an ASP. You can use it to query or CRUD programmatically any entity that jsreport server contains. I have not heard back from the original crew (I joined the team during the OData v2 timeframe) so I will assert an opinion based on the protocol docs: since there is a change-tracking section in MS-ODATA and they are very rigorous about actually tracking changes (thank you, antitrust legislation) and since that change tracking. The CRUD operations (create, retrieve, update and delete) are explained separately along with the Request and Response messages. 0 to handle batch. All code belongs to the poster and no license is enforced. Clone via HTTPS Clone with Git or checkout with SVN using the repository's web address. There is good. The available OData Java library implements OData version 2. Within that main HTTP request, each of the parts contains a nested HTTP request. Welcome to the OData Test Service. This is the 2nd part of my Statement posting blog series. db ), which used for samples in the DSS product. A example about how to organize post body could be found from C4C OData development guideline, where ServiceRequest is used for demonstration. Please see the "Introducing batch support in Web API and Web API OData". NET Web API 2. The posting section in Retail parameters form is used to specify parameters that are used to post discounts, inventory updates, settlements, and other retail operations. CRUD stands for Create, Read, Update and Delete. Therefore, if you do not manually fire a single OData request then usually it is a batch request and you need to use the batch request completed event. Thank you post the issue to asp. An OData batch request is single HTTP POST request to the in the examples below. CRUD Data Operations. The server accepts the modifying request if and only if the provided CSRF token is still valid. Discover more freelance jobs online on PeoplePerHour!. This is an example of a simple asynchronous Python web server using Twisted. Topics elsewhere cover configuring for OData BreezeJS Clients and for OData Breeze Sharp clients. renaming the contact entity should not break anything, as contact is a system entity. Batching can be used to optimize network usage. According to your question is more related to OData, you could post a new thread in ASP. Odata POST multiple entries / JSON array? Showing 1-6 of 6 messages. These are the top rated real world C# (CSharp) examples of Microsoft. NET Web API Forum for suitable support. The cool thing about the Web API is the stuff we get for free. 0 - so I'm guessing this is intended to ship with Web API 2. Microsoft is radically simplifying cloud dev and ops in first-of-its-kind Azure Preview portal at portal. Introduction to OData. request({ method: "POST",. How to perform batch processing in Odata,, I am expecting how to fit this in code(c# or wcf 5. Example requests and responses The following is an example of a raw HTTP request that batches two GET operations that retrieve the titles of all the items in two different lists. EXE is part of the Microsoft Windows 2000 Resource Kit and can be downloaded here. A question that we frequently receive is how can I filter out data before it gets to Microsoft Flow? The answer to this question is: OData filter queries. The XAML SDK is an easy-to-use infrastructure with 1000+ developer focused examples for most of the Telerik WPF and Silverlight controls. For more complex transactions, you may need to decrease the size to avoid HTTP timeouts. Dynamics AX 2012 and AX 2009 have the ability to breakdown a batch job into small manageable fragments and process them independently in parallel. The example below shows three defined endpoints and the creation of three batch requests, representing a list item creation, update and retrieval of the list. Running Batch Job from X++ example code. Introduction to OData. This way, when the Promise gets resolved/rejected after the execute method, we can easily track the response. ajaxSetup() have no effect on these requests. As described in the prerequisite section, y ou should have a skillset of building basic CRUD OData services with SAP Gateway Workbench (tx code: SEGW) as explained here: #1 - OData CRUD Crash Course - Getting ready with offline store. If you're reading this article there's a good chance you already know about oData - what it is and why you want to use it. The get and post methods are syntactical sugar to call fetch but with the method parameter set to GET or POST. it has enough options available to be used as a GUI to ANY batch file. The example below contains a Batch Response for the Batch Request in Listing 1. js integration using the Web API. Running Batch Job from X++ example code. After creating a BatchRequest you will need to add it to the RestBatchExecutor using either the loadChangeRequest or loadRequest method. Then we pass in some data to send along with the request (name and city). Install-Package Microsoft. Metadata is optional for many scenarios, but it can be used to improve how server values are interpreted and annotated in their in-memory representations. The 2012 version is available as a standalone download, and the 2014 version is part of the SQL Server 2014 Feature Pack. Example requests and responses The following is an example of a raw HTTP request that batches two GET operations that retrieve the titles of all the items in two different lists. Hi Experts, When I am using batch am getting the success resposnse( 202) for all oprations( read , post , put)but iam not getting response body as well as no entries are created in table level by Post method. I am trying to post OData batch request in postman. request({ method: "POST",. ) and HTTP method name +Entity set name (example: GetTestData,PostTestData, etc. So we have to disable the auto run feature in application. Filter expressions. Enable your SAP Business Suite or SAP S/4HANA system to use OData with SAP Gateway. $\begingroup$ But whats the difference between using [batch size] numbers of examples and train the network on each example and proceed with the next [batch size] numbers examples. 0 Reproduce steps Create an AS. silent push notifications, GCM collapse key, etc). txt), PDF File (. Hi, I am trying to send multiple xml inputs through odata batch in POSTMAN rest client. This connection type is available under New Connection… option in SSIS’s Connection Managers tab as shown in Figure 3. An example is payroll and billing systems. The current OData V2 Adapter in SAP Cloud Platform Integration supports POST, PUT, MERGE and DELETE HTTP operations in batch. The generated proxy classes let you instantiate the data entity objects, set properties, and call methods to interact with the OData endpoint. @Josey yes, falling back to the 2010 version does work on our On-premise farm. pl to a batch. The batch response contains a Content-Type header specifying a content type of multipart/mixed and a batch boundary specification, which may be different from the batch boundary that was used in the corresponding request. The Kendo UI grid is a snazzy little thing:. xml file with all the required dependencies for our spring batch example project. This section shows an example Batch request that contains the following operations in the order described: A query operation. By using "function" method of EntityTypeConfiguration class, we can define the function and using "Returns" method we can define the return type of the function. The target audiences must know OData (Open Data Protocol is an OASIS standard that defines the best practice for building and consuming RESTful. For basic tutorial of function and action, you can refer to Actions and Functions in OData v4 using ASP. The posting section in Retail parameters form is used to specify parameters that are used to post discounts, inventory updates, settlements, and other retail operations. A batch request consists of multiple API calls combined into one HTTP request, which can be sent to the batchPath specified in the API discovery document. In other words, you use standard URL syntax to query data residing on the server. Simple Batched Requests. ), a relative url (the portion of the URL after graph. How to add Multiple Entities (Relationship Data) in one Operation in SAP Netweaver and OData Services? The context for today’s article: I was working on a Fiori PoC (Proof of Concept) for my client where I had to do an update on one of the entity sets with multiple records in one call (one header and multiple line items). Objects are serialized as an unordered collection of name/value pairs. This is a brief blog to explain how to implement batch in SAP system and how to make batch gateway service calls for READ,CREATE and UPDATE. The Advanced REST Client, which is available on the Google. In OData, batch payload content types must specify exactly one batch boundary in the ‘boundary’ parameter of the content type. 2/14/2019; 2 minutes to read; In this article. No, we don't have such an example. Dealing with Dates in ODATA Endpoints. You can use it to query or CRUD programmatically any entity that jsreport server contains. I think you are right that the ODataController doesn't support POST reads. org, is a comprehensive source for information about the OData standard. The POST request to create an entity returns an HTTP 204 (No content) status and a Uri to the entity created is returned in the OData-EntityId header property. While there are plenty of read/update/delete examples out there for using Angular JS + Odata + Kendo UI, I have not yet come across a CREATE/POST exampleand I am struggling with the right method to basically insert form entered data to an odata service via the kendo model and datasource. The grid works natively with OData, but the examples from the Kendo team are of OData services driven by WCF back ends. OData makes it easy to filter data coming from an API. There are good developer articles about OData here. without waiting the effective execution of any of those passages. The get and post methods are syntactical sugar to call fetch but with the method parameter set to GET or POST. The posting section in Retail parameters form is used to specify parameters that are used to post discounts, inventory updates, settlements, and other retail operations. The sample uses HTML, C#, and the managed code OData library in Microsoft. This helps us to avoid too many errors and makes us easy to debug. Functions are operations exposed by an OData service that MUST return data and MUST have no observable side effects. The content type ‘multipart/mixed’ specifies a batch payload; however, the payload either does not include a batch boundary or includes more than one boundary. com), optional headers array (corresponding to HTTP headers) and an optional body (for POST and PUT requests). Every batch number has an inventoryquantity associated with it. ID == key ||. net Web API with OData version 4. OData Adapter in SAP Cloud Platform Integration supports batch operation. Here's an example of adding two fields in a batch request to a list. Prevent the geodatabase from accepting new connections. If you need to, you can set the Configuration. A sample OData service is available for developers to use during development and testing. So get hold of your SAP systems and invest 20 minutes behind each Tutorial Part and learn the fundamentals along with us. 2) with odata support. About the sample This OData sample was generated to work with the default h2 database ( DATA_SERV_SAMP. Here are a few examples: Medias: Breaking news, interest based notifications, etc. This post continues on from Getting started with Web API and OData V4. This is the 2nd part of my Statement posting blog series. Running Batch Job from X++ example code. paket add Microsoft. 2 dotnet add package Microsoft. delta-link-validity-The maximum duration in seconds a delta link in an OData response remains valid. Filter expressions. POST request is used to submit a batch operation that contains multiple requests. Use it to select the colums that you want to get using the new SharePoint REST API. Last post Sep 01, 2014 06:03 PM by How to PATCH in Web API and OData. You can use Olingo V2 as an OData client (although a rather ugly one in my opinion). Our APIs are asynchronous and respond very fast. The batch request boundary is the name specified in the Content-Type Header. This topic contains references for: Query string parameters. OData also guides you. This is the second part of a using NAV OData web services directly from C/AL code. { "swagger": "2. asp" reads the parameters, processes them, and returns a result. Please advise on how to execute batch post (i. So when the class /IWBEP/CL_MGW_REMOTE_HANDLER or /IWBEP/CL_MGW_LOCAL_HANDLER calls PROCESS_BATCH method, if the above request header is set. This ODATA batch processing support has not (yet) been added to SharePoint 2013 on-premise though. 12 Batch Support. This is required for Spring Batch metadata tables. Spring Batch is a framework for batch processing – execution of a series of jobs. The minimal information of the credit card consists of an ID (key property), and the properties cardNumber, validThru, CardOwnerName. If anybody has some idea of how to post data in batch then please help me out. Therefore, if you do not manually fire a single OData request then usually it is a batch request and you need to use the batch request completed event. Here we will make SharePoint Batch Request easy with a single line of code using BatchUtils. It allows you to target a large audience or users. The OData Batch requests allow the grouping of multiple operations into a single HTTP request payload. Library take cares of serializing it into the correct format. While data modification requests represent a primary use of batch operations, OData batch protocol supports data retrieval (GET) operations that can be mixed with POST/PUT/PATCH/DELETE requests in a single batch. You can then use the Kendo. OData (Open Data Protocol) is an OASIS standard that defines the best practice for building and consuming RESTful APIs. Here are some example requests to the controller defined above. The Visual C# forum discuss and ask the C# programming language, IDE, libraries, samples and tools. Validation flavors in classical BOPF development: Action Check (triggered by action) Consistency Checks (triggered by modification) Cross-node validation through "Consistency Groups". Let's try to figure out what is OData? OData is Open Data Protocol. Below are some cURL examples for several basic use cases to get you sending email through SendGrid's v3 Mail Send endpoint right away. OData is a cross-platform standard (with several versions). On every request, only batch-size number of rows are returned. For example, an application can have two JSLs, one for payroll processing and another for report generation. Using the Directory and File Pathnames reader, read the Data folder containing all the MIF files. Part 1 Getting started with Web API and OData V4 Part 1. Skyvia allows you to easily expose your SQL Server data via OData — RESTful API for data access and manipulation. Regards, Atanas Korchev Telerik. Sending Batch Requests. In fact it is something that helped me to start exploring the behavior which was misleading at the outset, but the article made it very clear as to how the D365 OData v4 should be created. Running Batch Job from X++ example code. The OData request may be stored in the default CA API Gateway request, response, or in a custom context variable. Each JSL must be named uniquely and must be placed in the META-INF/batch-jobs directory. My requirment is i need to send one request to server from c# application , in a combination of (read all , create) , or (create, update) , multiple combinations possible for batch processing explained in a format of Open Data Protocol (OData) Batch Processing. Here we will make SharePoint Batch Request easy with a single line of code using BatchUtils. In In the previous post, I discussed how to implement an ASP. My question is ,how can I create post method for the lightswitch odata service , so that other team will call this post method to insert a record in to. SoapUI is the world's most widely-used automated testing tool for SOAP and REST APIs. Note: The batch system for the Google BigQuery API uses the same syntax as the OData batch processing system, but the semantics differ. It is the only module Microsoft will support in the future, so there’s no way going around that. After taking a week off from blogging, I wanted to start back with a focus around a topic I've been spending a lot of time focusing on. Sunday, 14 August 2016. Steps for an OData action. The OData service life cycle includes span of an OData service. The library also support batch operations, as defined by the OData protocol. One of the biggest issues with the Azure AD module however is it’s poor ‘usability’ or ‘friendliness’. Disconnect users. To accommodate the need for a more developer-friendly format, the new JSON format batching support is added to the latest version of OData protocol v4. OData supports so-called Batch Processing, which allows more than one OData operation to be sent with a single HTTP request. ) and HTTP method name +Entity set name (example: GetTestData,PostTestData, etc. Prevent the geodatabase from accepting new connections. XOData is a generic OData API/Service visualizer and explorer. A tutorial on how to use ASP. In the Part I post Introduction to SAP Netweaver Gateway and OData, we learned about the definition, terminologies and concept of SAP Netweaver Gateway, OData and HTTPs. How to Create Gateway Services Using the OData Channel API Odata channel - with netweaver gateway SAP UI5, SAPUI5, SAP Fiori, SAP HTML5, SAP OData, SAPUX, SAPX03, SAPX04, SAPX05, GW100. The OData service life cycle includes span of an OData service. the validation of the data is done against the EDM provided metadata ). Jon Galloway posted a nice how-to video here. I have already gone though the link "Gateway batch calls from SAPUI5", but still not able to figure out where am i going wrong. Library take cares of serializing it into the correct format. The 'request' API is used for add, update and delete operations. element or the formenctype attribute of the or elements:. 0 compliant library once the OData standard is published at OASIS. A query is defined with variables. This library "odatajs-4. Batch framework needs to check several conditions, dependencies and constraints each time a set of tasks is completed and a new set of tasks needs to be picked up for execution from ready state. 0 (the * "License");. Now that the OData V4 service is up and running, in the following posts, we want to explore some of the new features and also features which existed in V3 as well. 0 format in the request bodies. Batch operations run in the background on Mailchimp's servers. I am trying to implement POST operation in the Odata service. You can view the root service and metadata URLs, and generate sample sales orders and purchase orders for multiple entity sets. In this blog we will see, few more setups required in Retail parameters and batch configuration. The second part, the batch body, is the work that will be performed as part of the batch. The batch response contains a Content-Type header specifying a content type of multipart/mixed and a batch boundary specification, which may be different from the batch boundary that was used in the corresponding request. In this quick FAQ, learn about features of OData like FHIR, RFC, IETF, Security, JSON, batch requests and pagination. The Visual C# forum discuss and ask the C# programming language, IDE, libraries, samples and tools. Install-Package Microsoft. But there are several occasions when POST is necessary when creating a ajax request. Therefore, if you do not manually fire a single OData request then usually it is a batch request and you need to use the batch request completed event. This is why you will need to call the Transactional API once per OS. Dear supporter, I can not perform an OData V4 write or update with the Connect service. RequestOptions: It creates a request option object which we need to optionally pass in http. This post is part 3 of the Web API and OData V4 series. Hi Experts, When I am using batch am getting the success resposnse( 202) for all oprations( read , post , put)but iam not getting response body as well as no entries are created in table level by Post method. NET Core web application has any "base path", individual requests contained in a batch request could not be routed correctly. Client has a special class ODataBatch. ) and HTTP method name +Entity set name (example: GetTestData,PostTestData, etc. Response of this request would be similar to one give below. Here's an example of adding two fields in a batch request to a list. Easy to follow steps for DataSource component configuration, examples of supported methods and executed events. OData is a cross-platform standard (with several versions). I'm trying to implement an odata consumer, specifically right now related to doing batch operations and change sets, following the odata documentation essentially loads to this sample multipart batch that I've used as a basis. We have a page on our documentation site that introduces oData and gives some basic examples that help you get started. In the URL in your browser, the string after “field=” will be the field name you need to use in your REST query. The OData service life cycle includes span of an OData service. Dynamics AX 2012 and AX 2009 have the ability to breakdown a batch job into small manageable fragments and process them independently in parallel. Note that this is an introduction to. Dynamics 365 - Odata integration (Code snippet) Inserting the record in D365 table (Just a simple example, FYR): Post a Comment. After creating a BatchRequest you will need to add it to the RestBatchExecutor using either the loadChangeRequest or loadRequest method. Or you can populate a batch with multiple transactions The second option is what s being referred to as Batch Processing. Would you like to participate in a short survey about the SAP Help Portal? Yes, take me to the survey No. In future on goal is to provide an OData 4. Use it to select the colums that you want to get using the new SharePoint REST API. OData Development Tools contribution to Eclipse. Sep 01, 2014 01:16 PM Here's an example using an OData C# client for PATCH, Delta. Here is the code for creating a record using OData and Jquery in CRM 2011/2013/2015. JSON, as described in , defines a text format for serializing structured data. These operations have to be specified in an object literal. CRUD with Odata and Data entities in Dynamics 365 for operations - READ Operations Before starting anything, I assume that you are already aware of Data Entity concepts in D365O. Built-in OData actions and functions. A batch request groups multiple operations into a single HTTP POST request. Note: The batch system for the Classroom API uses the same syntax as the OData batch processing system, Example batch request POST https:. The basic building blocks of this model are Actions and Applications. Sometimes that is not wanted (e. SAP Netweaver Gateway is SAPs implementation of a OData Server/generic serivce provider. Set the request method in HttpURLConnection instance, default value is GET. The main goal is to build a standalone, lightweight and easy to understand Odata lib. As you can see, batch normalization really does help with training (not always, but it certainly did in this simple example). So get hold of your SAP systems and invest 20 minutes behind each Tutorial Part and learn the fundamentals along with us. These are the top rated real world C# (CSharp) examples of Microsoft. Executing large FetchXML with WebAPI Jan 15, 2017 Natraj Yegnaraman crm2016 , dynamics365 , javascript , tricks You can easily execute fetchxml in WebAPI using the "fetchXml" query parameter. NET Web API projects. The jqXHR Object. Dynamics 365 and Python integration using the Web API November 27, 2016 in Microsoft Dynamics CRM , Dynamics 365 , programming , integration , Python A few days back I wrote a post that showed an easy way to set up Dynamics 365 and Node. Now that the OData V4 service is up and running, in the following posts, we want to explore some of the new features and also features which existed in V3 as well. Batch job in AX7 / D365 x++ code In AX7 / D365 batch jobs are created pretty same as we did in AX2012. I have already gone though the link "Gateway batch calls from SAPUI5", but still not able to figure out where am i going wrong. There is a full tutorial dedicated to this usage on the official Olingo site: How to use Apache Olingo as client library. SAP Batch Management OverviewBatch Management can be defined as tagging an alphanumeric or a numeric code tothe material produced or material procured. For example, POST request are considered more secure than GET request as creating a POST request is relatively harder than creating a GET request. In this tutorial, i will show you how submit form using jquery ajax without page refresh in codeigniter 3. OData Batch requests allow the grouping of multiple operations into a single HTTP request payload. POST request is used to submit a batch operation that contains multiple requests. Teiid OData server, implements cursoring logic when the result rows exceed the configured batch size. When it comes to handling large amounts of data, there is really only one way to reliably do it: batch processing. My goal is to obtain a Transaction Services rotation (the Audit practice in my office is preventing me from transferring since they don't want to lose me) or FP&A position (not ideal since most of the positions seem to be glorified accounting, which is. CRUD Data Operations. Maybe it could help somebody stuck like me:. A query option is a sort of keyword that begins with $. Following are rules to define method signatures: Action should have parameter name as "key" if path. Microsoft proposes OData as the web data protocol while Google uses GData. These operations use different HTTP methods to accomplish this. This blog describes how to expose a stored procedure in the OData service: oData and Stored Procedures aka Service Operations. In Dynamics 365 WebAPI, we can retrieve data using OData queries, but if there is some complex requirement, it's better to query using fetchXML. Batch details A batch request consists of multiple API calls combined into one HTTP request, which can be sent to the batchPath specified in the API discovery document. SoapUI is the world's most widely-used automated testing tool for SOAP and REST APIs. This package contains everything you need to create OData v4. Figure 3 By clicking on the New Connection… option, the OData Connection Manager Editor will popup. Make batch requests with the REST APIs. 2 dotnet add package Microsoft. Right now, I was able to execute batch post through creation of association / expand from principal entity then implementing logic on CREATE_DEEP_ENTITY method. These operations have to be specified in an object literal. AX 2012: Create a Simple Batch Job muhammadanaskhan Batch Framework , Development (AX 2012) , Dynamics AX 2012 , Technical (AX 2012) April 14, 2015 April 22, 2015 1 Minute In this post we’ll learn how to create a very basic custom Batch job using SysOperation framework. @Josey yes, falling back to the 2010 version does work on our On-premise farm. OData (Open Data Protocol) is an OASIS standard that defines the best practice for building and consuming RESTful APIs. Instead of performing one large query and then parsing / formatting the data as a single process, you do it in batches, one small piece at a. NET Web API OData The ASP. The client PUTS following method example that modifies the entity selected by using key send. Actions are operations exposed by an OData service that MAY have side effects when invoked. Batch operations; Marshalling / Unmarshalling to your own Pojo model; A quick demo. Now your OData services became callable from HTTP client. The batches are used during the posting process, in order to post one or multiple lines at once. OData V2 and V4 automatically make batch requests. In future on goal is to provide an OData 4. Add columns to "order by" and filter on and the REST URL + Querystring will be build for you. If that works correctly, you should be getting some result from the GET. In contrast, real time data processing involves a continual input, process and output of data. 2 and ODATA V4.