Question

I am trying to a refresh on a single table in Azure Analysis services using PowerShell and Automation Runbook. I am passing a bearer token to the header body but while testing it I am getting below error. Response status code does not indicate success: 415 (Unsupported Media Type)

<#param
(
    [Parameter (Mandatory = $false)]
    [object] $WebhookData,

    [Parameter (Mandatory = $false)]
    [String] $DatabaseName,
    [Parameter (Mandatory = $false)]
    [String] $AnalysisServer,
    [Parameter (Mandatory = $false)]
    [String] $RefreshType
)#>

$AnalysisServer = "centralus.asazure.windows.net/servers/shipbobanalysisserver01/models"


$DatabaseName = "POC Shipbob TabularModel/refreshes"


$userName = $Credential.UserName
$securePassword = $Credential.Password
$password = $Credential.GetNetworkCredential().Password

$tenantId = ".........................................."
$requestAccessTokenUri  = "https://login.microsoftonline.com/$tenantId/oauth2/token"
$resource =  https://centralus.asazure.windows.net/ 
$pass = "..................................."

$requestBody = "grant_type=client_credentials&client_id=$userName&client_secret=$pass&resource=$resource"

$token = Invoke-RestMethod -Method Post -Uri $requestAccessTokenUri -Body $requestBody -ContentType  application/x-www-form-urlencoded 

#Write-Output $token


$header=@{
"ContentType"="application/json"
"Authorization"="Bearer $($token.access_token)"
"Accept"="application/json"}


$baseUrl = "https://"+$AnalysisServer+"/"+$DatabaseName


$body =
 {
    "Type": "Full",
    "CommitMode": "transactional",
    "MaxParallelism": 2,
    "RetryCount": 2,
    "Objects": [
        {
            "table": "Hist_ShipbobLive_dbo_FulfillmentCenterType",
            "partition": "Partition"
        }
    ]
} 


Invoke-WebRequest -Uri $baseUrl -Body $body -Headers $header -Method Post -ContentType "aapplication/json"

有人能帮我调试一下这个代码吗?

我试图通过使用 - 错误的 respErr 和 - - SkipHTTPError check 来获取错误的细节, 但没有发现任何运气。

Answer 1

contentType = application/x-www-f或m-urlencoded ,您在散列中跳过,而不是字符串, content-Type = application/json ,只是通过字符串。

不妨如下:

$headers = @{
    "Content-Type" = "application/x-www-f或m-urlencoded"
}

$uri = "https://login.microsoftonline.com/$TenantId/oauth2/v2.0/token"

$body = @{
    grant_type    = "client_credentials"
    scope         = $Scope
    client_id     = $ClientId
    client_secret = $ClientSecret
}

$token = Invoke-RestMethod -Method Post -Uri $uri -Body $body -Headers $headers

或

$headers = @{
    "Content-Type" = "application/json"
}


$body = @{
    grant_type    = "client_credentials"
    scope         = $Scope
    client_id     = $ClientId
    client_secret = $ClientSecret
}

$bodyString = $body | ConvertTo-Json -Depth 10

$token = Invoke-RestMethod -Method Post -Uri $uri -Body $bodyString -Headers $headers

BTW, is you resource value is c或rect here?

友情链接