JSON Assistance Needed
Hello - I have a vb process that reads, retrieves and parses data from an external URL to excel.
Everything is working until I have to loop the process. The external URL only allows 50 rows of data. So the first 50 rows works fine, when start the next set of 50 rows of data, it pulls the same info. I believe I need to clean / refresh or empty the JSON file. I am not sure how to do that. Any suggestions and/or input would be greatly appreciated. Thank you.
Hi @peteb1 That external URL might have a parameter to take page number. Pass the page number in the URL to pull the next 50 rows. It might be something like