VS Code deployment to Azure having issues

[vsyedabu]

Describe the Bug with repro steps

I am using VS code - Logic Apps standard extension to create a logic apps stateful workflow. I can able to create the logic apps locally and run it successfully. I am using the V2 connectors (Create Blob, Execute SQL query, Execute Stored Procedure). However, when I deploy the same to Azure through the VS code I am getting the following error.

"Operation details errorUnable to initialize operation details for swagger based operation - Execute_stored_procedure_(V2). Error details - The provided subscription identifier '@{appsetting('workflows_subscription_id')}' is malformed or invalid."

Any help will be appreciated.

What type of Logic App Is this happening in?

Standard (VSCode)

Which operating system are you using?

Windows

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "Execute_stored_procedure_(V2)": {
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "referenceName": "sql-2"
                        }
                    },
                    "method": "post",
                    "body": {
                        "MinerId": "@triggerBody()?['MinerId']"
                    },
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('default'))}/procedures/@{encodeURIComponent(encodeURIComponent('[dbo].[Get_Miner]'))}"
                },
                "runAfter": {}
            },
            "Response": {
                "type": "Response",
                "kind": "Http",
                "inputs": {
                    "statusCode": 200,
                    "body": "@body('Execute_stored_procedure_(V2)')"
                },
                "runAfter": {
                    "Execute_stored_procedure_(V2)": [
                        "SUCCEEDED"
                    ]
                }
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "triggers": {
            "When_a_HTTP_request_is_received": {
                "type": "Request",
                "kind": "Http",
                "inputs": {
                    "method": "POST",
                    "schema": {
                        "type": "object",
                        "properties": {
                            "MinerId": {
                                "type": "integer"
                            }
                        }
                    }
                }
            }
        }
    },
    "kind": "Stateful"
}

Screenshots or Videos

No response

Browser

I am using trying this in Chrome and Edge

Additional context

No response

[ccastrotrejo]

Hi @vsyedabu thanks for raising this issue. It seems that your logic app in azure portal is missing the app settings that were created while you authenticated the logic app locally in vscode.

• Were you able to upload the settings right after deploying the logic app? Did you saw a small window message on the bottom right corner?

• You can also do the following to upload the settings after you deployed the logic app

1. Press Ctrl+Shift+P to open the command palette
2. Type 'Upload local settings' and enter

[vsyedabu]

Hi Castro,

Thanks for the update. I was about to try your suggestion by creating a new project. Now I cannot create a new project from VS code for logic apps locally. Today I got an update on the extension. Is this a known issue or something I am missing. I am trying to check your suggestion with a new project.

The Extension version is 5.44.7; Last Release Date - 2025-03-19 09:26:34
VS Code version: 1.98.2

[ccastrotrejo]

Hi @vsyedabu Yes, yesterday we released a new version of the extension. Now the experience of creating will be through the "Create new logic app workspace" could you please try this experience?