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!
Solved! Go to 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.
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.