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

Question

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

Answer 1

Hello @Anonymous , 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!