When I run the following query directly in Data Explorer in Azure Portal it takes about 2 seconds to finish. The same query when run using Logic Apps Connector v5 is paginated to 5 pages even though there are only 3 results. This seems absurd to have to paginate so many empty pages to get the results of such a small query.
SELECT * FROM c WHERE c["UNIQUE ID"] = "A0000014" AND IS_DEFINED(c["UNIQUE ID"])
The logic app connection settings I use:
Here is query done in Data Explorer:
From reading the docs I would guess the query execution's time was too long, or it was more efficient for the query engine to return results in additional executions , however I would like to remedy this behaviour. Thanks