Passing SQL output parameter to execute stored procedure

Question

I'm trying to pass output parameter to execute stored procedure in Azure logic app and I dont see any result

"body": {
        "ResultSets": {
            "Table1": [
                {
                    "attachment_URL": "https://google.com/"
                }
            ]
        },
        "OutputParameters": {}
    }

Answer 1

It looks like you are trying to execute a stored procedure in an Azure Logic App and pass an output parameter, but you are not seeing any result.

Here are some steps you can follow to troubleshoot the issue:

Make sure that the stored procedure is returning the output parameter correctly. You can test this by executing the stored procedure in SQL Server Management Studio and checking the output parameter value.

Check the syntax of your Logic App code to ensure that you are passing the output parameter correctly. You can refer to the Azure Logic Apps documentation for guidance on how to pass output parameters.

Check the data type of the output parameter in the stored procedure and ensure that it matches the data type of the output parameter in your Logic App code.

Check the permissions on the stored procedure to ensure that the user executing the stored procedure has the necessary permissions to read and write to the database.

If none of these steps resolve the issue, you may need to provide more information about the specific error message you are receiving to help troubleshoot the issue further.