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(44.800000000000004, 53%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Hello Community
I have the following problem with a query in Azure Data Factory.
I can retrieve the data with the following URL (example ULR) in Postman without any problems. However, in ADF I get the following error message.
https://test.test.de/ttt/2/services/test-order/orders?limit(0,99999)
Error Message Web Activity.png
However, if I only use
https://test.test.de/ttt/2/services/test-order/orders the query works.
I suspect a problem with "?limit(0,99999)".
Any ideas?
Thanks.
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello Rene Fürstenberg,
Welcome to the Microsoft Q&A forum.
It seems like the issue you’re encountering with ADF could be related to the way the query parameter is being handled within ADF. The ?limit(0,99999) part of your URL is likely being interpreted differently by ADF compared to Postman.
for further troubleshooting, can you try removing the "?limit(0,99999)" parameter from the URL and see if the query works?
also can you try with a smaller range in your limit parameter to see if the issue is related to the size of the data being retrieved. If it works with a smaller range, you might need to paginate your requests or adjust the limit to fit within ADF’s constraints.
Hello,
Thank you very much for your answer.
Without "?limit(0,99999)" the query works perfectly.
I haven't reduced the range yet, but I will test it and let you know the result.
ADF probably interprets the URL differently.
Best regards
Hello Rene Fürstenberg,
I am checking to see if you had a chance to test with a smaller range.
Hello,
I have now tested this.
Unfortunately, it doesn't work even if I change the range.
Many Greets
Hello Rene Fürstenberg,
Thanks for the confirmation. As the next step, I suggest opening a support case so that a support engineer can live troubleshoot the issue. In case you don't have a support plan, please let me know, and I can provide a one-time free support request to work on this.
I'm looking forward to hearing from you