Unable to parameterize the connection.json from VS code - Logic App standard

Question

Hi all,

Single tenant Logic app ( VS code) - I have parameterized the connection.json like as below .

{
"managedApiConnections":{
"azureeventgrid":{
"api":{
"id":”/subscriptions/@appsetting('WORKFLOWS_SUBSCRIPTION_ID')/providers/Microsoft.Web/locations/northcentralus/managedApis/azureeventgrid”
},
"authentication":{
"type":"ManagedServiceIdentity"
},
"connection":{
“id":”/subscriptions/@appsetting('WORKFLOWS_SUBSCRIPTION_ID')/resourceGroups/@appsetting('WORKFLOWS_RESOURCE_GROUP_NAME')/providers/Microsoft.Web/connections/azureeventgrid”
}
}
}

while trying to deploy the Logic app from VS code, I am getting Error as below . But same is working fine from Azure portal( updated @appsetting in connections under workflows) .
Issue is getting only while deploying from Visual studio code. Is any access policy to be setup for this? Any pointers would be helpful.

Error in creating access policy for connection in reference - 'azureeventgrid'. Error: Error in getting connection - /subscriptions/@appsetting('WORKFLOWS_SUBSCRIPTION_ID')/resourceGroups/@appsetting('WORKFLOWS_RESOURCE_GROUP_NAME')/providers/Microsoft.Web/connections/azureeventgrid. Error: The provided subscription identifier '@appsetting('WORKFLOWS_SUBSCRIPTION_ID')' is malformed or invalid.

Thanks,
Dhana

Answer 1

Change connection string in below format, it should be work from VS Code

"outlook": {
"api": {
"id": "/subscriptions/7b71************b62b95****316a7/providers/Microsoft.Web/locations/centralus/managedApis/outlook"
},
"authentication": {
"type": "ManagedServiceIdentity"
},
"connection": {
"id": "/subscriptions/7b7*******************16a7/resourceGroups/RG-AIS-lapp/providers/Microsoft.Web/connections/outlook"
},
"connectionRuntimeUrl": "https://******e67.10.common.logic-centralus.azure-apihub.net/apim/outlook/ed41e635e******6729c8/",

}  

Answer 2

Did anyone got this working ?
I have a similar problem.

Answer 3

Still we have the same issue. we are unable to deploy from VS code.

Answer 4

The API id should be all string and it cannot accept params. I managed to have this running using this fix.
"api":{
"id":”/subscriptions/@appsetting('WORKFLOWS_SUBSCRIPTION_ID')/providers/Microsoft.Web/locations/northcentralus/managedApis/azureeventgrid”
},

Answer 5

So in our Logic App connection JSON we have the following content:

{
    "managedApiConnections": {
        "sftpwithssh_2": {
            "api": {
                "id": "@appsetting('SFTP_CONNECTION_API_ID')"
            },
            "authentication": {
                "type": "ManagedServiceIdentity"
            },
            "connection": {
                "id": "@appsetting('SFTP_CONNECTION_RESOURCE_ID')"
            },
            "connectionRuntimeUrl": "@appsetting('SFTP_CONNECTION_RUNTIME_URL')"
        }
    }
}

When I save a workflow with an SFTP action I get the following error:

WorkflowConnectionsInvalidConnectionValue","message":"The 'managedApiConnections' property in connection.json has a value that cannot be parsed."

The app settings values are perfectly fine. When I insert them into the connection JSON manually I can save.

Inside the action of the workflow designer I can navigate through the FTP server folders but maybe that's just because an older compilation with manually configured working connection.