OData - 10K limit

[vannat]

We are using ODAta (Dynamics365 F&O) and in my Query URL, I already tried to limit as much as I can by placing a company ID and data parameters. Our data is so large though.  How can I get around this?  Thank you! 

[apathetichell · Accepted solution]

my usual solution is call 1 - limit 1- get the count. use generate rows to divide up the max/by count. create new calls with offset/top. feed in. I've discussed this on prior threads. If you want to see how this is done -I'd recommend looking in stack overflow or somewhere for examples since this is not an Alteryx specific situation - and no - I will not share a workflow with you.

[apathetichell · Accepted solution]

https://community.dynamics.com/forums/thread/details/?threadid=c002e938-92c8-4890-8963-ff2d29bcfd67 has some good info...

[vannat]

The article worked perfectly! thank you.  I had used this article as my starting point: https://community.dynamics.com/blogs/post/?postid=c22b0bcf-014d-402f-817e-5aed4f756be1 and with the additional notes from the link you shared, i was able to get the full data set.