Skip to content
Pardaan.com Pardaan.com

If your work becomes your passion…

  • Home
  • Profile
  • Tags
  • LinkedIn
  • Facebook
  • X

ODATA

  • Home
  • ODATA
Posted inDynamics NAV & BC Tips & tricks

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.…
Read More
29 July 2022
Posted inDynamics 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...
Read More
4 April 2022
Posted inDynamics 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…
Read More
6 December 2021
Posted inDynamics 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…
Read More
15 January 2021
Posted inDynamics 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…
Read More
15 January 2021
Posted inData & 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…
Read More
4 August 2020
Posted inDynamics 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…
Read More
21 June 2019

Posts pagination

1 2 3 4 Next page

Menu
  • Profile
  • Tags
Categories
  • Data & Analysis
  • Dynamics NAV & BC
    • Functional
    • General
    • Technical
    • Tips & tricks
  • ERP general
  • Information management
  • Off-topic
  • Projectmanagement
  • Quote of the week
  • Visual C# / ASP.net
Stay Hungry, Stay Foolish
RSS Mibuso
  • How to call a procedure in Business Central from Power Automate
  • How to transfer custom field from service order , service line (items) to Warehouse Entry Table
  • Advice needed: Switching to AL-GO Github?
  • "all of your selections were processed" BC message
  • How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
  • Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
  • How can I change my Mibuso E-mail address in my user profile?
  • Tenant Media
  • Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
  • GST calculation issue
  • To provide Vendor Payment Bank upload file
  • Deepinserts not working
  • Adding new field to Base App Drop down field group view
  • Adding a new lookup field with a TableRelation to CRM Integration Table
  • Appending to the end of a file - BC v14, C/AL
  • How to save an ANSI file from Business Central?
  • E-Mails gets send but not moved to table Sent E-Mail
  • A part of page 13 Email Editor is not shown for some users, but for others
  • How to get Hash Certificate as Base 64 String in MS BC SaaS
  • What are the best AI coding IDEs for AL code
RSS Dynamics NAV Team Blog
  • Seamless scheduling across time zones in Dynamics 365 Field Service
  • Explore migration options for Microsoft Dynamics GP and Microsoft Dynamics SL customers
  • Unlock the power of record routing with real-time analytics
  • Agentic CRM systems: Learnings from organizations making the switch
  • Under the Hood: Building an AI-Driven Storefront with Dynamics 365 Commerce 
  • AI-powered proactive engagement and conversational journeys with Microsoft Dynamics 365 in public preview
  • Improve contact center operations with shift-based routing
  • Intent-based routing transforms customer support with AI
  • Email editor template changes in Dynamics 365 Customer Service
  • The autonomous enterprise: How generative AI is reshaping business applications
RSS Power BI
  • Open and edit any semantic model with Power BI tools
  • Power BI June 2025 Feature Summary
  • What’s New in SQL Server 2025 Analysis Services
  • Now available: two new Copilot experiences
  • Your Road to Power BI Certification Starts Here
  • Power BI Report Server May 2025 Feature Summary
  • Power BI May 2025 Feature Summary
  • The next era of Copilot in Power BI: Chat with your Data (Preview)
  • Translytical task flows (Preview)
  • Deep dive into selection expressions for calculation groups
Scroll to Top