Logic Apps: HTTP trigger and response time out

Question

I have pretty simple LA that contains just 3 actions. It has HTTP trigger, then it gets some data from SQL server and returns http response with SQL data.

Sometimes, it takes 30-50 seconds to get data from SQL but Logic App in the meantime responses with Timeout error to caller.

The execution of template action 'Response_2' is failed: the client application timed out waiting for a response from service. This means that workflow took longer to respond than the alloted timeout value. The connection maintained between the client application and service will be closed and client application will get an HTTP status code 504 Gateway Timeout.

Any idea how to increase allowed time for response?

Answer 1

You can turn on the Asynchronous Response in the Settings of the Response action:

When you run your logic app longer than its time limit, you will accept 202 HTTP Code first:

It will return a response contains location header:

You can request the location URL, if the status of your logic app still is running, it will return 202.

If the status of your logic app is Succeeded, then it will return the results you want.

You can refer this official document.