Logic app SQL server connector pagination - single or multiple action execution

Mike Lee 41 Reputation points
2021-01-25T16:39:24.16+00:00

Hello, I have a question about the SQL connector and pagination. For example, let's say a Get Rows action has pagination enabled and it retrieves 5000 rows. With pagination enabled this would mean 3 requests since the default pagination size is 2048 rows.

Does Azure consider this Logic App run a single execution of the Get Rows action or three of them? I'm looking into the cost implications of using pagination.

Thanks,

Mike

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

Accepted answer
  1. ChaitanyaNaykodi-MSFT 23,341 Reputation points Microsoft Employee
    2021-01-29T22:27:34.227+00:00

    Hello @Mike Lee , apologies for the delay. I got a response from the product team. In logic apps the connector billing is based on action execution, so in your example above even though pagination is enabled, it is still considered a single action execution. You will be billed for single action execution and not three.
    Please let me know if there are any additional concerns. Thank you!

    0 comments No comments

0 additional answers

Sort by: Most helpful