Code for pulling Blue Alliance component OPRs into xls

Competition Scouting
1

Has anyone developed code to pull The Blue Alliance component OPR data into an Excel sheet or csv file?

Looking to have our team develop this but hoping to not reinvent the wheel if someone already has this available to share.

Thanks!

2

I am using google sheets and https://www.chiefdelphi.com/t/the-blue-alliance-api-google-sheets-addon/359332 code in app snippets from the great @WillNess . It has a function ( =tbaEventOPRs(eventcode) ) that pulls the tba opr for a event. if you need this in an xls or csv you can export it to one of those and then use it for tableau or whatever else.

3

Thanks! This works nicely.

Do you have updated code (2023 at least) that handles the insight data? That is what I am most interested in.

I don’t think the 2024 data has been published yet.

4

/event/{event_key}/insights

Should be pretty straightforward

5

Insights seems to give you the event highlights (high scores, RP %, etc)

I cam trying to get the component OPRs (COPRs) that are on the same page but I can’t find the hooks to grab them.

Anyone successfully done this?

I don’t see it documented.

6

I was searching for an endpoint for these last season and was unable to find one. You can get OPR (and DPR and CCWM) from the /event/{event_key}/oprs endpoint, but I don’t think there is an endpoint for COPRs.
Depending on your proficiency with programming, you could write a script to generate them yourself, the calculations needed are specified here: https://blog.thebluealliance.com/2017/10/05/the-math-behind-opr-an-introduction/, and there are python functions(and likely ones in other languages) that do most of the math for you.

7

As of 15 hours ago, there is now an API endpoint available.

This is not documented via the Swagger API page just yet but will be soon. You can get component OPRs with the /event/{event_key}/coprs endpoint.

3 Likes
8

Beautiful!

I will try this out. Will be a great compliment to human scouting.

Thanks to all this far for the assistance.

1 Like
9

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.