This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Hello,
we do an API call where we use pagination rules:
In the endpoint we see indeed that it works:
But we have duplicate values random every time at row 2000 3000 and 7000. but this can change every call. but it is not on every step. If I do the calls in postman I don't get duplicate values. I have the idea that something is going wrong with merging. Hope someone can help me with this. Thanks in advanced. Ronald
Hi Ronald Mussche,
Thank you for posting query in Microsoft Q&A Platform. I checked from my end with some dummy API, its working fine. Looks strange why it is happening it.
I suspect something may be coming incorrectly from API itself, but you do mentioned that if you did API call separately in postman then thats not the case.
If possible, try to make API call in loop same as ADF by some third-party tool or writing some code and see how API is behaving. Please let me know how it goes.
Thank you for your response, I build a loop just as you mentioned, and it still retuned duplicates. I discovered that the order of the data changed within different calls. If I add a sort to the call it seems to work. Kind regards, Ronald Mussche
Hi Ronald Mussche,
Thank you for sharing your findings and resolution that, adding sort to the call helps. This helps community as well.
Please consider hitting Accept Answer button. Accepted answers help community as well.