I have little experience working with API’s, so I was hoping for some confirmation/direction on my plan.
Excel will have my search criteria for documents in column A, B and C - for example, City, Image1 and Image2. There could be a few to hundreds of records (each record representing a pdf file).
Using a website’s API (Basic Authorization) a search would be performed for each record – ie city/Image1/Image2. If found, a file number should be returned from the site, which would then allow a download of the applicable pdf file to a local folder. I don’t really need to bring any data back into Excel per se, other than possibly a Success/Fail status for each record.
I’m thinking this could all be handled (by someone with actual knowledge) in excel VBA, possibly using WinHttp. Am I on the right path or is there a more logical approach?
Thanks.
Excel will have my search criteria for documents in column A, B and C - for example, City, Image1 and Image2. There could be a few to hundreds of records (each record representing a pdf file).
Using a website’s API (Basic Authorization) a search would be performed for each record – ie city/Image1/Image2. If found, a file number should be returned from the site, which would then allow a download of the applicable pdf file to a local folder. I don’t really need to bring any data back into Excel per se, other than possibly a Success/Fail status for each record.
I’m thinking this could all be handled (by someone with actual knowledge) in excel VBA, possibly using WinHttp. Am I on the right path or is there a more logical approach?
Thanks.
