I am trying to create an azure logic app by connecting it with azure sql server db. But in tables dropdown, the tables are not auto populating and keep giving following error -
Could not retrieve values. The gateway did not receive a response from 'Microsoft.Web' within the specified time period.. Client request id: '83E7DA82-8A83-48EE-9B3C-0B8BD39390BC'
Does anybody has any answer to it?
Following up to see if my answer helps. Do let me know if you any queries.
I hope the answer helps. Please let me know if you any further queries.
@openmindedMashaa-4794 Looking into the backend logs for the shared client request ID I can see the error from SQL server end that the server not found or was not accessible. Can you please verify that you are passing the correct SQL server and database name. Please reconfigure the connection again and verify if you have followed these steps.
If the above doesn't help then, please verify below in your tables:
1. Table must have an IDENTITY column for the new row trigger
2. Table must have a ROWVERSION (a.k.a. TIMESTAMP) column for the modified row trigger
Try to create a new table with these added columns and recreate the API connection again in your logic app and verify if you are able to see the tables in the dropdown.
My Issue got resolved after adding the IDENTITY column.
And I guess the ' ROWVERSION (a.k.a. TIMESTAMP) column ' is needed if we have the 'When an item is modified (V2)' action in logic apps.
Thanks for the solution.
@AshishThorat-0924 Glad to know that the issue is resolved now.
Feel free to 'Accept as answer' so that it can help others in the community looking for help on similar topics.
Hi Mayank,
Do you know how the logic app connector uses this timestamp field internally to fetch only the modified date. Does it store this value somewher to compare or does it create a trigger in database itself.
Thanks
6 people are following this question.
