how can I increase the default timeout for sql connector in logic apps in standard plan?

Sebastian Uribe 0 Reputation points
2024-09-26T21:52:59.03+00:00

I'm ussing ther connector "Execute a SQL query (V2)" in Logic Apps to retrive data from SQL Server.
The query longs 3-4 minutes.

But the connector throws timeout at ~2 mins

How can I increase the default timeout.

I have tried modifying the .host file

{
  "version": "2.0",
  "extensionBundle": {
    "id": "Microsoft.Azure.Functions.ExtensionBundle.Workflows",
    "version": "[1.*, 2.0.0)"
  },
   "extensions": {
    "sql": {
      "commandTimeout": "00:10:00" 
    }
   },
   "functionTimeout": "00:30:00"
}

and

{
  "version": "2.0",
  "extensionBundle": {
    "id": "Microsoft.Azure.Functions.ExtensionBundle.Workflows",
    "version": "[1.*, 2.0.0)"
  },
   "extensions": {
        "workflow": {
            "settings": {
                "Runtime.Backend.ApiConnectionOperation.RequestTimeout": "00:100:00"
            }
        }
    }
}

Thanks

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,113 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.