Connecting to MS Dynamics for OData tests

Symptoms

You want to be able to test API data connectivity with MS Dynamics.

Cause

n/a

Resolution

First, install the MSAL.PS module which ise used for authentication. This only needs to be done once on the computer.

Check PowerShellGet version

Get-Module -Name PowerShellGet -ListAvailable | Select-Object -Property Name, Version, Path

Update PowerShellGet if it's outdated

Install-Module -Name PowerShellGet -Repository PSGallery -Force

Install the module

Install-Module -Name MSAL.PS -Force The use the following script to test the API connectivity:

Import MSAL module

Import-Module MSAL.PS

#PowerShell script to test connection to Dynamics 365 Purchase Orders endpoint #Azure AD and Dynamics 365 details $TenantId = "" $authority = "https://login.microsoftonline.com/$tenantId" $Resource = "https://blah.dynamics.com" # Your Dynamics 365 URL

Acquire Token Interactively

$tokenRequest = Get-MsalToken -ClientId "04b07795-8ddb-461a-bbee-02f9e1bf7b46" -Authority $authority -RedirectUri "urn:ietf:wg:oauth:2.0:oob" -Scopes "$Resource/.default" -Interactive

#Headers with the access token $Headers = @{ Authorization = "Bearer $($tokenRequest.AccessToken)" }

#Purchase Orders endpoint in Dynamics 365 $PurchaseOrdersEndpoint = "$Resource/api/data/v9.1/purchaseorders"

#Test GET request try { $PurchaseOrdersResponse = Invoke-RestMethod -Uri $PurchaseOrdersEndpoint -Headers $Headers -Method Get Write-Output "Successfully connected to the Purchase Orders endpoint." Write-Output $PurchaseOrdersResponse } catch { Write-Error "Failed to connect to the Purchase Orders endpoint. Error: $_" }