I just wrote an excel function for another person that makes a call to an API to update their products on a BigCommerce website.
So to achieve what you want should take no time at all.
What is the API you would be querying?
Anyway, like I say I can have this running for you in a matter of hours.
Thanks a lot,
John