Connect to and query Dataverse from PowerShell

Get-DataverseRecord.ps1

#requires -Version 5.1

# Install required module from PSGallery
Install-Module -Name Microsoft.Xrm.Tooling.CrmConnector.PowerShell

# Interactive Sign-in
$CRMConn = Get-CrmConnection -InteractiveMode

# Unattended Sign-in
$Cred = New-Object System.Management.Automation.PSCredential ($UserName, $(ConvertTo-SecureString -String $Password -AsPlainText -Force))
$CRMConn = Get-CrmConnection -Credential $Cred -DeploymentRegion NorthAmerica –OnlineType Office365 –OrganizationName $OrgName

# Build OAuth headers
$Headers = @{
    Authorization = "Bearer $($Conn.CurrentAccessToken)"
    Accept = 'application/json'
}

# Query Dataverse endpoint
$OrgUrl = 'https://<orgID>.crm.dynamics.com'
Invoke-RestMethod -Method GET -Uri "$OrgUrl/api/data/v9.2/accounts?`$select=name&`$top=3" -Headers $Headers