Need Help Connecting with a GET request from API that requires Authorization with a Key

[marca_at_cue]

I want to analyze College Football data and found an incredible website, (https://collegefootballdata.com/)  that serves up a ton of very rich college football data through an API (for FREE!).  I want to focus on the analytic possibilities within Alteryx, but I'm blocked because I can't figure out to connect to the API with Alteryx.  

To help me figure this out, you'll probably need to get a API key from the website (link to request an API key, it's free and painless). API documentation is here. 

My starting point is to just pull down 1 week of this years schedule. I think that if I can get a successful roundtrip with this simple query, I'll be able to hit any of the endpoints and have a ton of fun playing with the possibilities.  Can you help me?

The curl GET is (my API Key is abstracted for security reasons):

curl -X GET "https://api.collegefootballdata.com/games?year=2023&week=4&seasonType=regular" -H  "accept: application/json" -H  "Authorization: MyUniqueAuthKeyIsFakedHere"

The Request URL for that should be: 

https://api.collegefootballdata.com/games?year=2023&week=4&seasonType=regular

I've followed a couple of good Community articles and external Blog posts.  All informative, but none are getting me to a good data extraction from the API. 

I need help understanding how to configure the Download to for this GET request.  I'm running into 302 and 500 errors from the GET call.  Curious if somebody could get an API key, build a simplistic Workflow that I could download and get started crunching some NCAA football numbers for this season...and hopefully beat Vegas!

Cheers,

Marc

[patrick_digan · Accepted solution]

@marca_at_cue In your Authorization, you need to add Bearer like so:

Authorization: Bearer MyUniqueAuthKeyIsFakedHere

The attached brought some data back for me when I put my key in the formula tool.

[marca_at_cue]

Patrick - thank you so much!  Works perfectly.  I'm off to the races.

Never seen anybody use the Vertical alignment of the Tools.  Kind of makes my brain hurt.  Not sure I could make that switch.  

[marca_at_cue]

The image was supposed to have "I'm so Stoked"...don't want that to be misconstrued as throwing my hands up in disbelieve at the Vertical tool orientation.

[patrick_digan]

@marca_at_cue Glad it worked!