Novice user... Please type slowly and use small words.
I am running using Powershell ISE to pull results from my online database. For a particular response,there are approximately 6000 results, but I can only pull 50 at a time (limit set within database).
How do I get a count, tell it to print the first 50 responses to file and then loop back to get the next 50 until it runs out of objects to retrieve?
Beyond not scripting the request correctly, I am obviously using the incorrect language to FIND the assistance I need. In my head it's a Dynamic Off-set based on a Count... I have been digging through PW get-help and good-ol-google for weeks. I'm stuck. Please help?
It's often called chunking/paging in programming parlance.
So, just search for 'powershell read data in chunks'
Create a counter for the number/range you want
Ask for that number/range
Then ask for the next number/range.
Do a search for this, as well as parallel process, jobs, and runspaces.
Try to work something up, and then come back if you have issues.
THANK YOU. Did a bunch of reading and, while I still don't have it working, I am at least finally on the right track and can at least google the correct words for help.
No worries, we all are always learning, and anyone who is not trying to, well, you know. ;-}
Remember, data paging on the DB side of this is a thing. Read this.
Powered by IDERA