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