Hi,
I'm trying to run a power automate flow - get rows from SQL server view. It works fine for sometimes (for 7000 records) and some time I get the following error:
"The response is not a valid paginated response. The paginated response should not have the same non-empty 'nextLink' or 'odata.nextLink' property from the previous page when there are no items in the 'value' property."
The first step is "Recurrence" - once a day.
The second step is Get Rows. the pagination flag is turned on and the threshold is set to 100,000.
I don't have any access to the "dialog" between Get Rows and SQL Server. how can I affect nextLink? I'm not part of it.
Thanks,
Eran

Report
All responses (
Answers (