Discussions

Dear community,

I’m trying to use PowerAutomate with the Get Employees API to retrieve employee data. The query basically works. However, something seems to be off with the offset (pagination):

For the HTTP request, I set the limit to 10. The offset is incremented starting from 0.

With offset = 0, the HTTP output returns 10 records (as expected, limit = 10) with Current_Page = 0. So far so good.

With offset = 1, I again get 10 records, but at least 1 record was already retrieved in the previous step. Current_Page still shows 0 at this point.

With offset = 2, I get another 10 records, Current_Page is now set to 1, but again I see duplicate records from the previous step.
And so it happily continues... The result is that I end up with lots of duplicate records.

Do you know this phenomenon or have a solution for the problem?

Best regards,
Clemens