Share
ReportI am trying to use the SQL data connection to execute a stored Function on my Azure host SQL SB in Flow. I have selected the Execute store procedure V2 action and supplied the connection details which then updates the block to include the 2 expected parameters. I filled those parameters in and tested my flow. However, the flow errors each time due to the following error
"Procedure or function GetNextProjectNumber has too many arguments specified." This is unexpected to me because the raw input shows only the 2 parameters that my function expects. Please help me understand if I am doing something wrong here. Below are the raw inputs and outputs. I have also attached some screenshots.
{
"host": {
"connectionReferenceName": "shared_sql",
"operationId": "ExecuteProcedure_V2"
},
"parameters": {
"server": "default",
"database": "default",
"procedure": "[dbo].[GetNextProjectNumber]",
"parameters/CustomerID": 9,
"parameters/ProjectType": "M"
}
}
{
"statusCode": 400,
"headers": {
"Pragma": "no-cache",
"x-ms-request-id": "07192daa-ca28-4b29-88e0-44d88c8fd2b1",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "no-store, no-cache",
"Date": "Sat, 12 Jun 2021 00:02:56 GMT",
"Content-Length": "342",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 400,
"message": "Procedure or function GetNextProjectNumber has too many arguments specified.\r\nclientRequestId: 07192daa-ca28-4b29-88e0-44d88c8fd2b1",
"error": {
"message": "Procedure or function GetNextProjectNumber has too many arguments specified."
},
"source": "sql-wus.azconn-wus.p.azurewebsites.net"
}
}
Categories:
All responses (
Answers (
69,661
