public/Sync-CrmVirtualEntity.ps1
|
<# .SYNOPSIS Syncs one or more CRM virtual entities. .DESCRIPTION The Sync-CrmVirtualEntity function refreshes one or more CRM virtual entities by invoking the CRM API. .PARAMETER CrmUrl The base URL of the CRM instance. .PARAMETER TenantId The Azure Active Directory tenant ID. .PARAMETER ClientId The Azure Active Directory application (client) ID. .PARAMETER ClientSecret The Azure Active Directory application (client) secret. .PARAMETER VirtualEntity A single virtual entity name to refresh. .PARAMETER VirtualEntities An array of virtual entity names to refresh. .EXAMPLE Sync-CrmVirtualEntity -CrmUrl "https://your-crm-url" -TenantId "your-tenant-id" -ClientId "your-client-id" -ClientSecret "your-client-secret" -VirtualEntity "VirtualEntity1" #> function Sync-CrmVirtualEntity { param ( [string]$CrmUrl, [string]$TenantId, [string]$ClientId, [string]$ClientSecret, [string]$VirtualEntity, [string[]]$VirtualEntities) if (-not $VirtualEntity -and (-not $VirtualEntities -or $VirtualEntities.Count -eq 0)) { throw "You must provide either 'VirtualEntity' or 'VirtualEntities' parameter." } if ($VirtualEntity) { $VirtualEntities = @($VirtualEntity) } $crmApiUrl = "$CrmUrl/api/data/v9.2" # Acquire an access token $tokenUrl = "https://login.windows.net/$TenantId/oauth2/token" $tokenRequestBody = @{ grant_type = "client_credentials" client_id = $ClientId client_secret = $ClientSecret resource = $CrmUrl } $tokenResponse = Invoke-RestMethod -Uri $tokenUrl -Method Post -ContentType "application/x-www-form-urlencoded" -Body $tokenRequestBody $accessToken = $tokenResponse.access_token # Iterate through the virtual entities and refresh each one foreach ($virtualEntity in $VirtualEntities) { try { Write-Host "Refreshing virtual entity '$virtualEntity'..." # Fetch the virtual entity $fetchApiUrl = "$crmApiUrl/mserp_financeandoperationsentities?`$filter=mserp_physicalname%20eq%20'$virtualEntity'" $headers = @{ Authorization = "Bearer $accessToken" } $entity = Invoke-RestMethod -Method Get -Uri $fetchApiUrl -Headers $Headers | Select-object -ExpandProperty value | Select-Object -First 1 # Refresh the virtual entity $refreshApiUrl = "$crmApiUrl/mserp_financeandoperationsentities($($entity.mserp_financeandoperationsentityid))/mserp_refresh" $headers = @{ "Authorization" = "Bearer $accessToken" "Content-Type" = "application/json" } $body = @{ value = $true } $bodyJson = $body | ConvertTo-Json Invoke-RestMethod -Method Put -Uri $refreshApiUrl -Headers $Headers -Body $bodyJson Write-Host "Virtual entity '$virtualEntity' refreshed successfully." } catch { Write-Error "Error refreshing virtual entity '$virtualEntity':" Write-Error $_.Exception.Response.StatusCode.Value__ Write-Error $_.Exception.Message } } } |