I like to think I'm pretty versed in excel, but I'm trying something new and have no idea how to proceed. I have a webservice with API credentials that I want to pull into excel based on some filters.

I am essentially trying to do this in excel so that I can cross reference part of the data: https://documentation.vin65.com/Webs...Contact-Status

Any assistance would be helpful.