Logic Apps Azure's SQL Connector ReturnCode -3

Question

I have a logic app that calls a stored procedure to insert a record and update another record in an Azure SQL Managed Instance.

The Logic Apps runs successfully. The SQL Action returns an HTTP 200 (success) but with these outputs:

{
  "ResultSets": {},
  "ReturnCode": -3,
  "OutputParameters": {}
}

Screenshot of the outputs

I cannot find anything about negative ReturnCodes while the action succeeded.

Any ideas?

Answer 1

The ReturnCode is an integer returned if you specify a return value in the stored procedure. You can refer to this document:

You can also refer to this sample. In this sample, he specify a value ROWCOUNT return.