Blogbeitrag von:
Marije Brummel
Lesezeit:2 Minuten
22 March 2021
How to use the Dynamics 365 Business Central API with C# in Service-to-Service scenarios
Business Central
Dynamics 365
Tech
A question that was raised more frequently than others lately is, how to use the Business Central API from C# in Service-to-Service scenarios?
Within the Business Central community, C# is the most frequently used language to code Azure Functions and Windows Services using DotNET core.
There are a few choices to make when deciding how to design your code and we’ll discuss the most important ones being security and structure of your classes.
Security
When you connect to Business Central using the API you have two choices. OAuth with tokens or Basic with a Web Service Access Key.
Using OAuth is the preferred solution which is promoted by Microsoft. The problem is that OAuth is only supported when the software calling into Business Central has the ability to provide a user interface.
This user interface is required to show a window to login and return the access token.
Business Central currently does not support OAuth in service-to-service scenarios except for the API that is handling the service tier itself.
That leaves you with the choice of going back to Basic authentication with a Web Service Access Key or to use Azure as the middle man.
Most examples that you can find online of authentication use the latter option and therefor this blog is about the other option that is hard to find information on.
Simplicity is the core value of Business Central and even though customers using Business Central have an Office 365 tenant, not everyone has their Azure tenant configured.
Using Azure as the middle man for security may be the easy way out for a developer, it requires each user of your solution to set this up in their Azure tenant.
The advice is to use Basic Authentication for Service-to-Service connections until Microsoft is finished with a final solution for OAuth in these scenarios.
Classes
There are two options when you design your solution to structure your classes. You can have them generated based on the metadata of the API endpoint or you can design your own classes.
Both options have pros and cons and the most important reason why the example repository creates its own classes is again simplicity and to explain clearly how the API works rather than working through a pile of generated code that will leave 95% unused.
In real life implementations, many developers will choose to generate the classes based on the endpoint, especially if the API has strong versioning like the one provided by Microsoft.
A strong exception would be if you only need a few API methods implemented or if the API is a custom API for a project and subject to change.
If changes to the API happen on a frequent basis, which is not recommended but happens often in real-life scenarios, you can be more flexible in your error handling if you define your classes yourself.
Rest Client
To send data back and forth your code needs a Rest Client and, in the example, we use the one from RestSharp. This is a very popular NuGet package. Another frequently used Rest Client is the Simple Client (Simple.OData.Client) which is also available as NuGet package.
Json Handling
Json is not native to C#. It was created for JavaScript and in order to use it in C# you can use either NewtonSoft or the new System.Text.Json from Microsoft. Both are created by the same person who works for Microsoft now.
You will most likely find out that both libraries have scenarios where they work and fail.
NewtonSoft Linq supports the use of JArray and JObject in a similar way as AL has the native JsonArray and JsonObject although you will find the NuGet libraries much more flexible and powerful.
Value
Each result that you get from Business Central has a wrapper with a tag called [Value]. In almost all cases you won’t need this in your code. The function ConvertToDataSet converts the result of an API call into a Json Array without the [Value] wrapper.
The API Endpoint
When Business Central is hosted by Microsoft the API endpoint has up to 6 variables that determine things like the Sandbox you are using (if any), the Tenant ID (obsoleted by OAuth) and the details about the API version, and group.
Resources & Next Steps
- QBS Workshop: APIs in Dynamics 365 Business Central
- QBS GitHub: API Exemples
- Kaufmann.nl: Deprecation of basic auth for Saas has been postponed to 2022
- Kaufmann.nl: Service-to-service authentification for automation APIs in Business Central
- Youtube: How to create and use a Busienss Central API
Sie möchten mehr zum Thema "APIs in Buisiness Central" erfahren?
Die QBS Academy bietet einen 6-stündigen Online-Workshop, der spezifisch die Einsatzmöglichkeiten von APIs in Dynamics 365 Business Central behandelt.
Mehr Artikel
Das könnte Sie auch interessieren
-
Warum sind die Application Insights so wichtig für Dynamics 365 Business Central?
Wenn es um Business Central SaaS geht, schrecken manche […]
-
Sind Upgrades auf Dynamics 365 Business Central SaaS teurer als On-Premises-Upgrades?
-
Directions EMEA: Moving to Dynamics 365 Business Central SaaS: How to Deliver a Thriving Revenue Stream
The Microsoft Dynamics 365 Business Central SaaS customer base […]
-
Wie Sie im Dynamics 365-Lösungsdschungel die Übersicht behalten
-
Juli 2021: Neues rund um Dynamics 365 Business Central
Wie erwartet verhalten sich die Neuerungen für Dynamics 365 […]
-
Cosmos versus Azure SQL and how to integrate with Dynamics 365 Business Central #MSDYN365BC
One of the highest-scoring FAQs from partners and customers […]
-
HELP! My Application Insights EXPLODES!
At QBS Group we are promoting the use of […]
-
Wie Sie interne SaaS Readiness herstellen können
Ob neue Anforderungen von Kunden, neue Kompetenzen im Microsoft […]
-
Automatische Verlängerung der bestehenden Kompetenzen
Microsoft hat mit Januar 2021 die neue SMB Cloud […]
-
Die neue Cloud Business Applications Competence Option und unsere Unterstützung für Sie
Neben Office 365 hat Microsoft die neue Kompetenz-Option Cloud […]
-
Optionen für die Migration von Dynamics NAV bzw. Dynamics 365 Business Central in die Cloud
Viele Microsoft Dynamics Partner haben bereits die Tatsache akzeptiert, […]
-
Why is Application Insights so important with Dynamics 365 Business Central?
I can understand why some people would still refrain […]
-
Why is Azure SQL so important for Dynamics 365 Business Central?
Let us start with a common question: “When a […]
-
Look back at the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 Launch Event
Microsoft has arranged an absolutely splendid launch event for […]
-
MB-800 Microsoft Dynamics 365 Business Central Exam – Warum ist es für BC Partner so wichtig?
Microsoft hat ein brandneues Zertifizierungsexamen für Dynamics 365 Business […]
-
Get the latest insights at the Directions EMEA 2020 and get inspired by QBS Group.
Directions4Partners Virtual 2020 is focusing on bringing state-of-the-art keynotes […]
-
Neues rund um Dynamics 365 Business Central – September 2020
Im Oktober 2020 wird Microsoft Release Wave 2/2020 von […]
-
Neues rund um Dynamics 365 Business Central – August 2020
Im Oktober 2020 wird Microsoft Release Wave 2/2020 von […]
-
Top LinkedIn Hashtags für Dynamics 365 Partner
Business Netzwerke wie LinkedIn können Dynamics 365 Partner dabei […]
-
Engere Zusammenarbeit zwischen 1ClickFactory und QBS Group
Ab September 2020 wird Soren Fink Jensen, CEO von […]
-
Von NAV via Business Central on-premises in die Cloud
Wie Sie Kunden, die noch nicht für die Cloud bereit sind, für die Cloud vorbereiten.
-
Der größte Fehler, den Sie während der digitalen Transformation machen können
Die digitale Transformation bietet Unternehmen die Möglichkeit, die Organisationstruktur […]
-
Dynamics 365 CRM Update Webcast 11 May 2020
Get the latest insights from Microsoft Dynamics 365 CRM […]
-
Migrieren Sie Ihre Dynamics NAV-Kunden
-
QBS Azure Services – SOCITAS GmbH & Co. KG
SOCITAS netrachtet seine Lieferanten-Kunden-Beziehungen als enge Partnerschaften, in denen sich beide Seiten gleichermaßen um den Geschäftserfolg kümmern, ist es für SOCITAS äußerst wichtig, seinen Kunden nur qualitativ hochwertige Dienstleistungen anzubieten. Dies gilt auch auf das Hosting von Dynamics NAV bzw. Business Central.
-
Von lokal zu global: Pipol und QBS Group gehen Partnerschaft ein
Die aktive Partnerschaft besteht aus einer aktiven Zusammenarbeit, die gegenseitig großartige Möglichkeiten für Pipol- als auch für QBS-Partner bietet.
-
Business Central on premises: Essential- und Premium-Benutzer
Beim Umstieg von NAV auf Business Central on premises gibt es hinsichtlich des Funktionsumfanges (Essential vs. Permium) einiges zu beachten. Der Beitrag befasst sich mit den wichtigsten Aspekten des Up- oder Downgrades von Benutzerlizenzen.
-
service4work IT Solutions GmbH
"Wir fühlen uns durch QBS sehr wohl mit der Betreuung und gut in die Microsoft Welt aufgenommen. Bisher gab es keine Fragen, die unbeantwortet geblieben sind. So macht es Spaß zu arbeiten!"
-
ERP-Anpassungen – R.I.P.
Die Zeit, aufwändiger ERP-Anpassungen scheint vorüber zu sein. Im Markt für mittelständische ERP-Lösungen scheint die Zukunft den ISVs zu gehören.
-
gbedv GmbH & Co. KG
Geschäftsführer Georg Böhlen von gbedv GmbH & Co. KG berichtet von der erfolgreichen Dynamics NAV-Migration mittels den QBS Upgrade Service.
-
Microsoft raised the bar for competencies
Read this blog to learn about Microsoft's competency changes for the upcoming year.
-
New Pricing for Microsoft Dynamics 365 Customer Engagement & Unified Operations
Read this blog about the updated Microsoft Dynamics 365 licensing structure.
-
Aufzeichnung: Neues rund um Microsoft Dynamics 365 Business Central – Juli 2019
Sehen Sie hier die Aufzeichnung des Webinars (34 Minuten)
-
Ready to Start – Microsoft Dynamics 365 Business Central
-
Goodbye to NAV and Hello to 365 Business Central – with a German twist
Don't miss this article about the historic background of NAV.
-
The 7 secrets you must know to be successful with your Dynamics 365 App
Read this blog to hear from one of the experts in the field of successful Apps.
-
Aufzeichnung: Neues rund um Microsoft Dynamics 365 Business Central – Mai 2019
Sehen Sie hier die Aufzeichnung des Webinars (39 Minuten)
-
What does the latest Dynamics 365 Business Central Update (April ’19) mean for Europe, Middle East & Africa?
The April 2019 Business Central Licensing Guide has recently been released, but are there differences from the previous ones? In short, yes.
-
Pressemitteilung: QBS group wird Mehrheitseignerin von 1ClickFactory
QBS group und 1ClickFactory bündeln weiter Ihre Kräfte
-
Erfolg im Cloud Business – Interview mit Nico Straub
Lesen Sie hier, wie NAS Erfolg im Cloud Business erreichen konnte.
-
Daily reports from eXtreme 2019, Amsterdam
Daily news from Amsterdam.
-
Business Central is now available in Microsoft Graph – could this be the end of RapidStart?
Microsoft Dynamics 365 Business Central is now available in Microsoft Graph as an endpoint.
-
All you need to know about Microsoft Dynamics NAV coming to an end and becoming Microsoft Dynamics 365 Business Central
(this page will continuously be updated as information arrives) […]
-
White Paper – Microsoft Dynamics 365 the perfect platform for digital transformation in the mid-market
At QBS group we’re all about Dynamics partners – […]
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – Februar 2019
Sehen Sie hier die Aufzeichnung des Webinars (18 Minuten)
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – Januar 2019
Sehen Sie hier die Aufzeichnung des Webinars (28 Minuten)
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – Dezember 2018
Sehen Sie hier die Aufzeichnung des Webinars (18 Minuten)
-
Microsoft Dynamics 365 – the perfect platform for new business ventures
Microsoft has thousands of business partners. Is this market not the red ocean?
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – November 2018
Sehen Sie hier die Aufzeichnung des Webinars (32 Minuten)
-
How to integrate Power BI in Dynamics 365 Customer Engagement dashboards
Watch the recording of the webinar (39 Min.)
-
Recording: Introduction to D365 Marketing
Watch the recording: 49 min.
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – Oktober 2018
Sehen Sie hier die Aufzeichnung des Webinars (55 Minuten)
-
Recording: Build a Powerapp in 5 minutes
Watch the recording: 1 h 7 min.
-
It’s that time of year again, Directions EMEA
We will be covering the event for those partners that are not able to make it.
-
Business Report Directions EMEA 2018 – Reserve your copy now!
Reserve your copy now!
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – September 2018
Sehen Sie hier die Aufzeichnung des Webinars (34 Minuten)
-
eLWIS Has Left the Building – Goodbye to Customization of ERP Systems
Customisations are risky, expensive and becomes an anchor to the past.
-
Microsoft partner success with Dynamics 365 Business Central
Read about ideas to setup a high-volume sales engine.
-
The Strength of PowerApps – Accelerate your business with PowerApps
Read more about Power BI, Microsoft Flow and PowerApps.
-
QBS group ist Teil des Inner Circle for Microsoft Business Applications
QBS News, 1. August 2018
-
Aufzeichnung: Hot News from Inspire 2018
Watch the recording of this Webinar (59 minutes).
-
Aufzeichnung: Neues rund um Dynamics 365 Business Central – Juli 2018
Sehen Sie hier die Aufzeichnung des Webinars (39 Minuten).
-
This is how we got posted on AppSource!
Watch this video to learn how infostudi was able to publish an app for Microsoft Dynamics 365 Business Central
-
What every Microsoft Reseller should know about Microsoft Dynamics 365
Watch this video to know everything about the pricing and licensing of Microsoft Dynamics 365.
-
Aufzeichnung: Stop Selling D365 Licenses – Start Selling Successful D365 Projects!
Watch the 30 minutes recording here.
-
Aufzeichnung: Introduction to Microsoft Dynamics 365 for Project Service Automation (PSA).
Watch the 30 minutes recording here.
-
Aufzeichnung: Starke Vorlagen für Ihren Vertriebserfolg
Nachlese und Aufzeichnung
-
NAV posting procedures
Some background information for you
-
Ready to Start Microsoft Dynamics 365 Customer Engagement program – Reference MKB365
MKB365 has set up a separate business model for […]
-
Hot news from the eXtreme 365 EMEA event
The most important Microsoft Dynamics partner event in the […]
-
Update on Dynamics 365 Business Central
This series of webinars is intended to share […]
-
Highlights from eXtreme 365 EMEA 2018
Get all the highlights of eXtreme 365 EMEA 2018 and watch this 6 minutes video.
-
“Na endlich!”
Na endlich! Dynamics 365 Business Central wird veröffentlicht.
-
Dynamics 365 „Tenerife“ ist bald da doch Ihre Kunden arbeiten noch immer mit NAV 2009?
Never change a running system?
-
Ready to Go – Microsoft Dynamics 365 Business Central
-
Ready to Go – Dynamics 365 Business Central
-
4 Business reasons to start a CRM practice
Microsoft switches from single category products towards bundles or suites.
-
Why should I care about IoT as an Microsoft D365/NAV partner?
Adoption of Internet of Things solutions across industries continues […]
-
What can Dynamics CRM Partners expect from eXtreme365 EMEA 2018?
eXtreme 365 is the annual event for Microsoft Dynamics […]
-
The evolution of Dynamics 365 opens the door for new opportunities
Being a Dynamics CRM partner today is like dancing on a volcano – far from boring!
-
“Ever change a winning team”
“Ever change a winning team” Alex Ferguson, former football […]
-
Bringen Sie Ihren Dynamics 365 CRM Geschäftsbereich mit QBS group zum Erfolg
-
GDPR … and what now ?
Starting from 25 May 2018 there is going to be a […]
-
ABILITY GmbH
Die ABILITY GmbH ist einer der führenden Microsoft Partner […]
-
Wie steht es bei Ihnen um die ERP Integration?
Haben auch Sie mit redundanten Daten zu kämpfen? Der Versand Ihrer Weihnachtskarten sagt mehr darüber aus, als Sie vielleicht denken.
-
Position NAV as stepping stone for more Dynamics 365 ‘Tenerife’ deals
Since the introduction of the Dynamics 365 Business Edition in the US and Canada late 2016, the position of Dynamics NAV is under pressure! Competitors took the chance to position NAV as an old-fashioned solution and that’s a direct threat to your NAV business!
-
NAV als Sprungbrett für Ihren Erfolg mit Dynamics 365 „Tenerife“
In diesem QBS Talk in deutscher Sprache erfahren Sie, wie Ihnen schon heute über NAV der Einstieg in das Geschäft mit Dynamics 365 gelingen kann.
-
QBS Azure Services
-
Dynamics Upgrade Service
-
Ready to Start – Microsoft Dynamics 365 Sales & Power Platform
-
ISV-Programm
Als ISV liegt ihr erster Schwerpunkt auf der Entwicklung […]
-
Indirect CSP
Als Microsoft Reseller sollten Sie eine Zusammenarbeit mit einem […]
-
QBS Academy
-
Directions EMEA 2017 Madrid
Find here all the information you as Microsoft Reseller […]
-
The CSP Direct model is like an iceberg
We noticed that the market is changing, our clients are, more and more, requesting a subscription based approach. This allows them to not have their own services nor the hassle.
-
Dynamics 365 Business Edition: Opportunity or Threat
Microsoft will be launching Dynamics 365 Business Edition in […]
