Call Web API from Access
<p>I need to call a Web API from an Access 2010 application. This is the first time I work with an API from within Access 2010, not sure how to do this. The API I need to call is this : <a href="https://currencylayer.com/" rel="nofollow noreferrer">https://currencylayer.com/</a></p>

<p>API gets the currency exchange between 2 or more currencies. My application will be used by company users in Europe and the USA, so I need the currency to be taken into account when a user generates reports. I tried several examples from the website, but they generate a JSON file which I am not sure how to read it as the format seems to change often.</p>