Quote:
Originally Posted by Ed Law
Can anyone show me how to use the thebluealliance.com API to get ranking, match and alliance selection data? I am not able to get it from the FIRST website. I am hoping I don't have to do manual copy and paste. I would like to call it from VBA in my Excel scouting database. Is that possible?
|
Not an Excel wizard, but I can help with the TBA API. You can find the documentation
here.
Keep in mind all requested need a 'X-TBA-App-Id' header (or GET URL parameter, see below), it'll look like: '<team/person id>:<app description>:<version> '
Here are the endpoints you'll need (you can play around with test requests on the apidocs page)
Rankings: /api/v2/event/<key>/rankings
Results: /api/v2/event/<key>/matches
Alliances: /api/v2/event/<key> [alliances will be a field in this response]
You can also get the calculated OPR/DPR/CCWM stats at /api/v2/event/<key>/stats
And here are a couple StackOverflow threads that may or may not be helpful fetching/parsing JSON data:
https://stackoverflow.com/questions/...-unknown-proxy
https://stackoverflow.com/questions/...rnal-libraries