Home / OData

OData

Everything about OData

For anyone who has embarked on an API journey, it is very likely that you have come across the term OData in the context of API and Integration. In mine line of work, I interact on daily basis with many stakeholders involved in the API strategy, from Developer to Architects, Product …

Read More »

Getting annotations driectly from server

Introduction The oData annotations that tell which of the OData properties contain e.g. a phone number, a part of a name or address, or something related to a calendar event or an analytic query. This is important for apps running on mobile devices that want to seamlessly integrate into contacts, …

Read More »

How to visualize the OData model

I was recently in the situation that I have a complex OData model I needed to discuss with customers. Going through the metadata document requires a lot of brain power. The previous solution from XOData does not seem to work anymore. So, I found a brilliant blog from Denise. I modified some steps and with …

Read More »

How to connect SAP Gateway OData source with Angular

TL;DR Learn how to build an basic Angular 4+ app from scratch and easily connect it with your most loved SAP Gateway OData Sources. While SAP UI5 is SAP’s recommended client side framework for developing business applications, Gateway OData Services can be consumed by any HTML5/JavaScript based framework. In this …

Read More »

Easy Way to Bind Northwind Data

This blog is for the beginners who find difficult to understand binding of odata. All you have to do is to trust Descriptor Editor in manifest.json and it will take care of your complex code to be written in manifest.json and neo-app.json. Make the below destination in hanatrial.   2. Create a …

Read More »

ODATA Binding– Aggregation Binding using Northwind Service

ODATA Binding– Aggregation Binding using Northwind Service I found several articles/blogs for data binding. After going through SAP open portal Courses, here’s one more attempt to create a blog for data binding for beginners, highlighting key concepts. Hope, it may help to entry level frontend developer. Assumption : User must …

Read More »

Triggering workflows for MDF using OData API

This blog explains how you can trigger workflows attached to a MDF object using OData APIs. I will demonstrate this with a simple custom MDF. The custom MDF has three fields externalCode as AutoNumber, User ID as USER and comments as String. The workflow Manager_approval is attached to the above …

Read More »

SAP Web IDE OData Model Viewer

Intro When using an OData service for SAPUI5 development, you need some information about the service like the contained entities, their navigation properties between each other and their properties. You need this information for data binding inside the SAPUI5 application so that you can display the correct/desired data. You can …

Read More »

OData Mock Data Editor in SAP Web IDE

Intro When you are developing a SAPUI5 application with an OData backend it is handy to have some mock data available. The most obvious reason to use mock data is when the backend is not available, but there are several other use cases. Image you’re giving a demo and realize …

Read More »

Implement custom ODATA service for Standard CDS View

For Use cases involving Standard ABAP CDS Views, which may require custom ODATA implementation for SAPUI5 consumption. In usual scenarios Std. ABAP CDS Views are consumed as KPI/Smart Business App. But you may come across situations wherein CDS View is consumed as Design Studio App through Fiori (Query Browser), and …

Read More »

Delta Queries (Part 3)

Hi,   The next piece of the Delta Queries puzzle is identifying deletes on the backend service collection. In order to do highly efficient change detection you need to be able to detect when a record has been removed from the collection on the server. Whilst it is possible to …

Read More »

A $batch and $filter tale of woe

Recently I had quite a complex query I needed to run over multiple dimensions so the most efficient way to do this was to create multiple OData Queries and put them into a batch.   The code looked like:        var oModel = sap.ui.getCore().getModel(“LEDGER”);      var batchFilter = []; …

Read More »

Delta Queries (Part 2)

In the first article we looked at what Delta Queries were and the use cases that it addresses. Now we will look at the mechanics of doing a delta query call and what the requests and responses will look like.   As we mentioned at the start a typical OData …

Read More »

Delta Queries (Part 1)

This is to my mind the greatest new features for OData and for Gateway 7.4 SP7 is the support for OData 4.0 Delta Queries.   Recently I was running one of the partner enablement bootcamps for SMP 3.0 and found out there was little documentation on the greatest feature of …

Read More »

XSOData and UI5

Recently I was building an internal project using Hana and UI5. The basic idea was to create some tables on the backend and expose them with XSOData patched with a custom exit for creating the record on the backend.   That aside, the XSOdata code worked fine and it will …

Read More »

OData Extension for Data Aggregation Version 4.0

We‘ve recently published the first version of the OData Extension for Data Aggregation. As its name suggests, it is an extension to OData 4.0 that allows requesting aggregated data without violating the basic OData interaction paradigms.   In a nutshell it adds a single system query option $apply that takes …

Read More »

Using $format and $expand

We now up the pace a bit and have a look at some of the more advanced OData System Query Options.   How do I change the format I get data in?   The format your data is returned in is dictated in one of two ways, either using the …

Read More »

Using OData’s $top, $skip and $count

This blog post is part of the ongoing series “OData FAQ’s”   Today we will look at the system query definitions for $top, $skip to do pagination and $count/$inlinecount to get a count of the number of records in the record set.     How do restrict the amount of …

Read More »