Help with code to scrape API when error occurs

[Josephrandall]

Hello

I have this code that was kindly written for me. I have used it quite often with much success. Yesterday it was running and came back with a Run-time error (see pic 1) I'm confident this error came from the API source (probably from the amount of calls 12,000 total) and not my code. I am however, able to re-start the code directly after, and pull more data until it crashes again.

Here's a briefing of what's happening:

The code goes to the API page in column A and saves the JSON file in the directory in column B with the file name in column C.
The code then loops through all the rows. (Column D isn't relevant for the code, but its where I list all the IDs needed for each page/call.)

What is wondering is two fold. First, can the code be manipulated to restart if this error occurs, and secondly can it pick up where it left off in the loop?

I will attach a couple of pictures and a sample file, along with the code.

Thanks for your time, and input,
Joe

Please Login or Register  to view this content.

[Marc L]

Hello,

a sample in this thread …