Accessing Apex API via Excel?

[vhbug]

I'm trying to access the Apex Legends API via excel power query with:
= Web.Contents("https://public-api.tracker.gg/v2/apex/standard/profile/{platform}/{platformUserIdentifier}", [ApiKeyName="TRN_Api_key"])

replacing the platform and UID fields appropriately, then pasting my key into the Web API credentials field. I'm receiving a, "We couldn't authenticate with the credentials provided" error.

Sorry if this is a stupid issue to raise

Thanks for your assistance and have a happy new year!