How to set azure logic app parameters using powershell

Question

I'm trying to set the parameters of a logic app using powershell, this is the code I'm using:

$parameters = '{
    "$connections": {
            "syncSourceDatabaseConnection": {
                "connectionId": "/subscriptions/xxx/resourceGroups/xxx/providers/Microsoft.Web/connections/xxxx",
                "connectionName": "xxx",
                "id": "/subscriptions/xxx/providers/Microsoft.Web/locations/southeastasia/managedApis/sql"
            },
            "syncTargetDatabaseConnection": {
                "connectionId": "/subscriptions/xxx/resourceGroups/xxx/providers/Microsoft.Web/connections/xxx",
                "connectionName": "xxx",
                "id": "/subscriptions/xxx/providers/Microsoft.Web/locations/southeastasia/managedApis/sql"
        }
    }
}'

Set-AzLogicApp -ResourceGroupName "xxx" -ResourceName "xxx" -Parameters $parameters -Force

The code executes fine but the connections are not set, how do I fix this?

Answer 1

You can use this command:

Set-AzLogicApp -ResourceGroupName "<resourcegroup>" -ResourceName "<name>" -ParameterFilePath "?C:Usersxxxxxxest.json" -Force

If you use this command, you need to create a json file locally.