Forum Discussion
Connecting to the NBA stats API
Hi everyone, I am relatively new to connecting to public APIs and I have a problem. I'm trying to connect to the NBA API for draft history across all years and teams using the following GET: http...
Hi pops562,
To query the NBA stats API use the Web.Contents function in Power Query, you can do this through the UI by selecting "Get Data" -> "Web" and use either basic mode (1 page) or advanced mode if you want a paginated query.
There is a good example of this technique from Reza here: https://radacad.com/get-started-with-power-query-movies-data-mash-up
It looks like you will need to transform it from JSON.
I'll post a sample if I get a sec.
Cheers
Greg
Hi Greg,
I tried putting the URL for the API into the "Get Web" option, but the query timed out and I wasn't able to get it. Any advice?