JSON Assistance Needed



  • JSON assistance.
    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.


  • administrators

    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 url/?page=2 or url/?offset=50


Log in to reply
 

Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.