Thread: OPR
View Single Post
  #18   Spotlight this post!  
Unread 05-03-2015, 10:54
plnyyanks's Avatar
plnyyanks plnyyanks is online now
Data wins arguments.
AKA: Phil Lopreiato
FRC #1124 (The ÜberBots), FRC #2900 (The Mighty Penguins)
Team Role: College Student
 
Join Date: Apr 2010
Rookie Year: 2010
Location: NYC/Washington, DC
Posts: 1,114
plnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond reputeplnyyanks has a reputation beyond repute
Re: OPR

Quote:
Originally Posted by Ed Law View Post
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
__________________
Phil Lopreiato - "It's a hardware problem"
Team 1124 (2010 - 2013), Team 1418 (2014), Team 2900 (2016)
FRC Notebook The Blue Alliance for Android

Last edited by plnyyanks : 05-03-2015 at 11:29. Reason: Can also use GET param
Reply With Quote