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.
Tag Archives: ODATA
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:
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 more, opening the door to many benefits. In this How-To blog post, we demonstrate how to use Business Central OData feeds with Excel.
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 am going to describe how I refactored an existing Xamarin mobile application that is currently directly getting and posting data to Business Central APIs.
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 a signed-in user. I am going to describe how I refactored an existing Xamarin mobile application that is currently directly getting and posting data to Business Central APIs.
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 default because they are returned as metadata.
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 publish a codeunit as web service and use the SOAP endpoint.