Exercise - Access data through Dataverse API by using .NET Framework with ADAL - Training

15 minutes

Microsoft Authentication Library (MSAL) is recommended over Azure Active Directory Authentication Library (ADAL) because MSAL comes with more security and resiliency benefits. However, you’ll still need to use ADAL if your application needs to sign in users with earlier versions of Active Directory Federation Services (ADFS). This exercise is intended for legacy or existing apps that use ADAL and aren’t yet migrated to MSAL.

Step 1 - Locate the endpoint of your Dataverse environment

To locate the endpoint of your Dataverse environment, follow these steps:

Go to Power Apps.
Check the Environment badge in the upper right to ensure that you’re in the correct environment.
Select the Settings icon in the upper right and then select Developer resources.
Copy and save the Web API endpoint (you’ll need this information later in this exercise). Make sure that you only copy the URL from the scheme (https) to the host globaldisco.crm4.dynamics.com without the /api/data/v9.x path or query string.

Step 2 – Register the Microsoft Entra ID app

Next, you’ll create the app registration and underlying service principal that your app will use to run the Microsoft Entra ID delegate authentication.

Note

You’ll need to complete this step to get the user to authenticate with their credentials and use the resulting authentication token to access Dataverse.

Go to the Azure portal.
Go to Microsoft Entra ID.
Go to App registrations.
Select New registration.
1. Enter any name, such as my-mc4s-integrated-app.
2. Select Single tenant for the Supported account types.
3. Select Public client/native (mobile & desktop) and then enter http://localhost in the Redirect URI (optional) section.
4. Select Register.
Now, you've created your Microsoft Entra ID application and service principal. The app registration will be created and the Overview tab will open.
Note the Application (client) ID because you’ll need it later in this exercise.
To access resources in your subscription, assign a role to the application.
1. Go to API permissions.
2. Select Add a permission.
3. Select APIs my organization uses.
4. Enter Dataverse in the search box.
5. Select the Dataverse item from the result list.
Ensure that the user_impersonation permission is selected and then select Add permissions.

The user_impersonation permission will be shown in the Permissions list.

Your service principal is now set up. You can start using it to run your scripts or apps. These steps will allow your app to impersonate the signed-in user to access the Microsoft Cloud for Sustainability data in Dataverse.

Step 3 – Create a .NET Framework console app to query the Emission table

To create a Microsoft .NET Framework console app to query the Emission table, follow these steps:

Open Visual Studio 2019 (or newer) to create a new C# .NET Framework console app.

Note

Select at least .NET Framework 4.7.

Open the Program.cs file and replace the entire content with the following code:


using Microsoft.IdentityModel.Clients.ActiveDirectory;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.IO;
using System.Net.Http;
using System.Net.Http.Headers;

namespace MyMC4SApps
{
    class Program
    {
        static void Main()
        {
            // TODO Specify the Dataverse environment name to connect with.
            string resource = "Enter Dataverse environment endpoint here";
            // TODO Specify the Microsoft Entra ID app registration id.
            var clientId = "Enter App ID here";
            var redirectUri = new Uri("http://localhost");

            #region Authentication

            // The authentication context used to acquire the web service access token
            var authContext = new AuthenticationContext(
                "https://login.microsoftonline.com/common", false);

            // Get the web service access token. Its lifetime is about one hour after
            // which it must be refreshed. For this simple sample, no refresh is needed.
            // See https://learn.microsoft.com/powerapps/developer/data-platform/authenticate-oauth
            var token = authContext.AcquireTokenAsync(
                resource, clientId, redirectUri,
                new PlatformParameters(
                    PromptBehavior.SelectAccount   // Prompt the user for a logon account.
                ),
                UserIdentifier.AnyUser
            ).Result;
            #endregion Authentication

            #region Client configuration

            var client = new HttpClient
            {
                // See https://learn.microsoft.com/powerapps/developer/data-platform/webapi/compose-http-requests-handle-errors#web-api-url-and-versions
                BaseAddress = new Uri(resource + "/api/data/v9.2/"),
                Timeout = new TimeSpan(0, 2, 0)    // Standard two minute timeout on web service calls.
            };

            // Default headers for each Web API call.
            // See https://learn.microsoft.com/powerapps/developer/data-platform/webapi/compose-http-requests-handle-errors#http-headers
            HttpRequestHeaders headers = client.DefaultRequestHeaders;
            headers.Authorization = new AuthenticationHeaderValue("Bearer", token.AccessToken);
            headers.Add("OData-MaxVersion", "4.0");
            headers.Add("OData-Version", "4.0");
            headers.Accept.Add(
                new MediaTypeWithQualityHeaderValue("application/json"));
            #endregion Client configuration

            var response = client.GetAsync("msdyn_emissions?$top=10").Result;

            if (response.IsSuccessStatusCode)
            {
                using (var stream = response2.Content.ReadAsStreamAsync().Result)
                using (var streamReader = new StreamReader(stream))
                using (var jsonReader = new JsonTextReader(streamReader))
                { 
                    var jsonSerializer = new JsonSerializer();
                    var result = jsonSerializer.Deserialize<DataverseQueryResult<Emission>>(jsonReader);
                    foreach (var emission in result.value)
                        Console.WriteLine($"{emission.msdyn_activityname} activity on {emission.msdyn_transactiondate} emitted {emission.msdyn_co2e} CO2 Equivalent");
                }
            }
            else
            {
                Console.WriteLine("Web API call failed");
                Console.WriteLine("Reason: " + response.ReasonPhrase);
            }

            Console.ReadKey();
        }
    }
    public class DataverseQueryResult<T>
    {
        public IEnumerable<T> value { get; set; }
    }
    public class Emission
    {
        public string msdyn_activityname { get; set; }
        public DateTime msdyn_transactiondate { get; set; }
        public decimal msdyn_co2e { get; set; }
    }
}

Replace the Enter Dataverse environment endpoint placeholder with the URL that you previously retrieved in this exercise.
Replace the Enter App ID here placeholder with the app registration ID that you previously copied in this exercise.
Add the following NuGet packages:
- Microsoft.IdentityModel.Clients.ActiveDirectory
  
  Note
  
  This package is deprecated.
- Newtonsoft.Json
Run the console app.
Authenticate by using your credentials in the pop-up window. The console app should list the first 10 records of the Emission table.

Continue

Exercise - Access data through Dataverse API by using .NET Framework with ADAL

Step 1 - Locate the endpoint of your Dataverse environment

Step 2 – Register the Microsoft Entra ID app

Step 3 – Create a .NET Framework console app to query the Emission table

Обратная связь