PowerShell cmdlet in an API Management transformation policy

[Ayanmullick]

One is able to get Cosmosdb data directly from API Management using steps in this blog from the PM.

Example: https://ztech.azure-api.net/cosmos/getdata/41c40e37-f85e-6e34-0d2b-69cfe44e78a0

Could one execute a PowerShell cmdlet to convert the output to HTML in an API Management Transformation policy? Currently, one needs to implement AzFunctions with Cosmosdb binding just to ConvertTo-HTML.

AzFunctions Run.ps1

using namespace System.Net
param($Request,$CosmosDBinput, $TriggerMetadata)

$Body= [string]($CosmosDBinput|ConvertTo-Html)

Push-OutputBinding -Name Response -Value ([HttpResponseContext]@{
    StatusCode = [HttpStatusCode]::OK
    Body = $body
    ContentType = "text/html"
})

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 3d5c8bfc-df28-c601-ffe2-244bf261e869
• Version Independent ID: e2c3a983-4f42-3aa7-1432-6221365c74aa
• Content: Azure API Management transformation policies
• Content Source: articles/api-management/api-management-transformation-policies.md
• Service: api-management
• GitHub Login: @miaojiang
• Microsoft Alias: apimpm

[dingmeng-xue]

Azure services returns result in Json. It can be converted to XML or YAML because they are schema based language. Could you explain further why you need content in HTML? What's the conversion rule expected?

Could you just call ConvertTo-HTML in your script?

[dingmeng-xue]

feature request is created #14642

[Ayanmullick]

Thanks. The Azure PowerShell team has been planning to create a module for API management policies for a long time

https://feedback.azure.com/forums/248703-api-management/suggestions/34518523-api-mgmt-policy-management-powershell-module

The API management service generates the output.