Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Issue Connecting to API

Hjardine
8 - Asteroid

Hi,

 

I'm struggling to figure out why I'm not able to connect to this API: https://api.collegefootballdata.com/api/docs/?url=/api-docs.json#/recruiting/getRecruitingPlayers

 

The request URL is:

 

https://api.collegefootballdata.com/recruiting/players?year=2019&classification=HighSchool

 

I've added "?year=2019" to the end of the request URL, which I put into the download tool:

 

https://api.collegefootballdata.com/recruiting/players?classification=HighSchool?year=2019 

 

However, the DownloadData column is giving me this result:

 

{"error":"A year or team filter must be specified."}

 

I don't understand because I've included which year I would like, is this not the way to go about this? I'm a beginner with APIs so I might be doing this wrong. I've attached my workflow to this. Any help here would be greatly appreciated. Thanks!

2 REPLIES 2
BrianR
Alteryx
Alteryx

HI @Hjardine, I was able to get that query working - although it's not documented, I changed your [New URL] formula - swap out the ? for an &...

 

BrianR_0-1593204035224.png

After your download tool, place a json parse, and you should see your records returned.

 

Hjardine
8 - Asteroid

Thank you!

Labels