TrackerNetwork / TRN.Developers

Information and Issue Tracker for the Tracker Network API.
https://tracker.gg/developers
24 stars 5 forks source link

Accessing Apex API via Excel? #84

Open vhbug opened 1 year ago

vhbug commented 1 year ago

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!