Odata

Introduction This is forth part of the blog series where we will learn the process of authenticating the User using JSON Web Tokens so that we can test all the end points using Swagger UI. Authentication Used In actual project I have used AzureAD Authentication but for simplicity I will use the local…

In Part II of the blog series we learnt how to integrate swagger with API. In this blog we will learn how to handle the scenarios when we have multiple version of the API endpoint. If we do not do anything all the versions will be available on the UI…

In Part I of the blog we learnt how to create an OData API. In this blog we will learn how can we integrate OpenAPI documentation The API documentation should be available to the user with full details. The expected values in the Request and the Response return to the…

Image source CRUD with OData in ASPNETCORE 5 Necessity is the mother on invention. Long back when I was assign to design a table control in asp.net that can handle sort, search and pagination I end up choosing the OData in the ASP Web API as it allowed me create query on the client side. In…

Connecting to and retrieving data with just a few clicks — As first published on LinkedIn Pulse Connecting to OData does not need to be difficult or overcomplicated. With KNIME software, it is very easy to connect to OData sources. You only need to use a handful of KNIME nodes, depending on the structure of your data. I’ve created two separate…

.NET 6.0 includes new structure of Program.cs . I would like to document how I added OData support via the command line. Here are the steps I followed: 1. Create ASP.NET Core Web API 6.0 application >> dotnet new webapi -o odata >> cd odata 2. Add Entity Framework Core and OData package references I used EF Core In-Memory Database Provider for simplicity. >> dotnet add package…

OData, short for Open Data Protocol, defines a protocol for the querying and updating of data utilizing existing Web protocols. OData is a REST-based protocol for querying and updating data and is built on standardized technologies such as HTTP, Atom/XML, and JSON. …

Recently I have come across a scenario where business requires to store all the work items (Stories, Areas, Iterations, Branches etc.) from Azure DevOps into Data lake for storing and creating analytical reports from it to track progress, and productivity. Initially I had my doubts on this approach, since one…

What is the best standard for modern APIs? — OData and GraphQL are widely used as standards for API development. At a glance, they appear to be very similar and serve the same purpose. However, choosing one is not easy since they both have some unique features. In this article, I will compare and contrast OData and GraphQL to…