You can download start lists and results (for one or all events) at any given time before, during, or after your competition. These can be downloaded in CSV format either manually or automatically and includes all of the data entered into the competition. Sample scripts to automate this process are attached at the end of this document (.bat for Windows, .sh for Linux/Mac).


This can be done under Details if you choose a manual downloading process.



You can also automate the downloading process, and while it does require a small manual "setup", it will thereafter be automatic.


This is how you set it up:

    1. Authenticate and store cookies (the important one is cookie named rac). 

  • data makes it a POST and sends the payload
  • c tells it to store cookies in a file named "cookiejar"


curl –data 'username=myaccount@gmail.com&password=super_secret_pass' -c cookiejar https://api.admin.rosterathletics.com/api/login


    2. Now using acquired cookies, you can fetch start lists or results in CSV

  • b tells curl to attach cookies from file "cookiejar", where we saved them in step 1.
  • c same as above; cookies can (and will) be refreshed, so it's essential to store them


101 is the competition id - you can see it referenced in the location bar when viewing our website. It would be here: https://admin.rosterathletics.com/meeting/101/details


Start lists:

curl -b cookiejar -c cookiejar https://api.admin.rosterathletics.com/api/admin/meeting/101/export-csv


Results:

curl -b cookiejar -c cookiejar https://api.admin.rosterathletics.com/api/admin/meeting/101/export-results-csv/v2


You can also download results for a single event. In the example below, 201 is the event id. You can see it referenced in the location bar when viewing our website. It would be here: https://admin.rosterathletics.com/admin/meeting/101/results?meIdPk=201


Results for single event:

curl -b cookiejar -c cookiejar https://api.admin.rosterathletics.com/api/admin/meeting/101/export-event/201



Cookies expire after 2h. So if no request is made for 2h (or you don't store refreshed cookies), you'll need to do step 1) again. 


A simple bash script for Linux/Mac could look like this (also attached as a .sh file):



Or for Windows like this (also attached as a .bat file):



For examples, please see the two attached sample CSV files. 



Protocol for Support Tickets Regarding API/Script Issues


Please ensure the following before submitting a support ticket:

  • You have a working internet connection.
  • The competition number is correct.
  • You have the correct permissions for the competition.
  • You are using the latest version of the script (make sure that no old scripts with different domains are in use).
  • The number of columns in the start list and result CSV files is not static. Depending on the competition, additional columns may be present.
  • If you encounter the error message "The revocation function was unable to check revocation for the certificate", your antivirus software may be blocking the operation. To resolve this, add api.admin.rosterathletics.com to the list of websites the program will exclude from threat scanning.