Dataverse access via Web Service API

I am working on a project and we use D365 Field Service for our Support system, but part of our solution is a Mobile App built in Flutter that uses Azure C# Web Services APIs to connect to Azure SQL. I have been searching if there is a way to access Dataverse via a web API, and so far have had no luck. The samples I have found such as these:

https://learn.microsoft.com/en-us/training/modules/dataverse-web-api/

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/quick-start-blazor-server-app

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/get-started-dynamics-365-web-api-csharp

all require the User to authenticate via a Popup, which won't work in this case as they need the Authentication to happen in the C# Web Service, transparent to the User.

So the flow would be: User Clicks "View Cases" in the Mobile AppMobile App calls C# web service on Azure, which Authenticates the User, and retrieves all the cases assigned to that UserWeb Service returns the Cases to the Mobile App and they are displayed.

This is very easy to do with Azure SQL via secure SQL connections but I am hitting a wall trying to access the Cases in Dataverse.

Can anyone help?

Thanks!

John.

Categories:

Microsoft Dataverse

Tables

Hello!

To authenticate for that scenario of web api, I would recommend to use Non-Interactive users or Application users, for both cases you will be able to generate a token authentication using OAuth flow without need a pop-up and MFA.

Here is a tutorial how to create a Application User: Tutorial: Register an app with Microsoft Entra ID (Microsoft Dataverse) - Power Apps | Microsoft Learn

you can use that sample for that to calll webapi endpoint PowerApps-Samples/dataverse/webapi/CSharp-NETx/QuickStart/Program.cs at master · microsoft/PowerApps-Samples · GitHub

If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.

Quick Links

Subscribe to this forum!