ODATA – Pardaan.com

How-To loop through OData pages (@odata.nextLink) using AL

As most of you know, OData (and probably several other implementations) use server-driven pagination to load the data incrementally and improve the response times. This means if you have a big result set, the server will tell you how to aquire the next page of results.…

29 July 2022

Dynamics NAV & BC Tips & tricks

Be smart about Business Central OData, $filter like a Pro!

In this video, I show to do filtering on OData, at the source, check it out: Source : Hougaard.com Read more...

4 April 2022

Dynamics NAV & BC Tips & tricks

How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds

Connecting to Excel with OData fields can be very powerful, not only for Power BI, but also for Microsoft Dynamics 365 Business Central. By simply connecting to a Business Central page as an OData feed, you can pull data into Excel to create pivot tables and…

6 December 2021

Dynamics NAV & BC Tips & tricks

Implementing OData API authorisation in Business Central v17.x (Part 2 integration with Xamarin)

In this first article I presented a little overview of the secure and modern OAuth protocol with a “delegated permission” sample. In this article I describe an “Application permissions” implementation for an application that runs as a background service or daemon without a signed-in user. I…

15 January 2021

Dynamics NAV & BC Tips & tricks

My “step by step” guide for implementing OData API authorisation in Business Central v17.x (Part 1)

In this first article I am going to present a little overview of the secure and modern OAuth protocol with a “delegated permission” sample. In next article I will describe an “Application permissions” implementation for an application that runs as a background service or daemon without…

15 January 2021

Data & Analysis

Returning Annotations From OData Sources In Power BI/Power Query

The Power Query OData.Feed function has an option called IncludeAnnotations that allows you to return annotation values from an OData data source. It’s not obvious how to use it though – even if you use this option when connecting, you won’t see the annotation values by…

4 August 2020

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: using OData V4 Bound Actions

I’ve promised this post to some attendees of my last Dynamics 365 Business Central development workshop in Microsoft Italy (c/o Microsoft House) last week. Question was: How can I call Dynamics 365 Business Central logic from an external application? Simple answer given by all: you can…

21 June 2019