The Google Sheets example below uses a calculated URL to return currency exchange rates value from an authenticated REST API.