Using APIs in Excel (Toll Calculator API v2)

I’m not sure if I’m writing this in right place, please let me know where i should ask this.

I’m trying to use this API to create a table in excel that has all the different entrance & exits to motorways and total the tolls for each trip/combination of entry/exit

If this already exists somewhere great I can pull data from that but I want to be able to update each month so i can make sure its up to date

In excel:
I go to the “Data” tab
→ “Get Data” (under “Get & Transform Data”) section
→ “From Other Sources”
→ “From Web”
→ Enter “
→ “Web API”
→ Enter my key
→ “Connect”
It comes up with an error “a web API key can only be specified when a web API key name is provided.”

And I have tried many other combinations and tried all the other tabs
I’ve also tried with every shorter variation of the URL and had no luck

If anyone could help me that would be fantastic
Or if you could point me in the right direction to get help I’d very much appreciate it