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
Hi @eranzana
Just to double check, what connectors are you using? I remember I've seen a similar issue however it was related with the D365 connector so perhaps it is not the same.:
https://powerusers.microsoft.com/t5/Building-Flows/List-rows-present-in-a-table-error-The-response-is-not-a-valid/td-p/404749
https://powerusers.microsoft.com/t5/Using-Flows/Pagination-Error-Dynamics-365-Connector-List-Records-Action/m-p/404740