TBA Data Download for FIRST Robotics 2020 Game

I have seen a lot on this topic last year but not so much this year so I thought I would post. This is the first time I have integrated to the TBA API to populate a Google Sheet with all the event specific data so I can integrate with Tableau or Data Studio.

I used the ImportJSON.gs script and loaded that into my Google Sheet under Tools -> Script Editor. Original Script can be found at https://github.com/bradjasper/ImportJSON

I then added a function at the end to pass the TBA Token appropriately.

function ImportJSONTBAToken (url, query, parseOptions,  token) {
  var header = {headers: {'X-TBA-Auth-Key':token}};  
  return ImportJSONAdvanced(url, header, query, parseOptions, includeXPath_, defaultTransform_);

You can copy my Google sheet via this link and enter your specific settings. Realize that some of the data will be null for future events. The copy should also copy the ImportJSON script as well. https://docs.google.com/spreadsheets/d/1AT2Ru4kFBQDMWIj-_cyrRUtTMNP5_uXlQVCsCqZ6ks8/copy

There are several tabs that represent a call to a specific API call I used in my dashboard. I also reformatted the data in the sheet using VLookups, HLookups, and all sorts of functions. I also have a teammatchspecific tab which splits the results by team which you can use for team specific metrics. Realize those formulas might have to be copied down if you have more matches or more teams than the norm.

The Settings tab has the configuration information which is team key, event key, and TBA Token.

Here is a pdf of my DataStudio Report. https://drive.google.com/file/d/18RBe9IR3XYU0VHaEnXnp2wdVcyYc08yi/view?usp=sharing

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