Did you know that you can export any preset to publish it in another website or document (Excel, Google Docs, Google Sheets…)?
To export a preset using the API you have to know how the Copernico API call is formed so that you can apply it to any document or web.
There is one constant element that is always the same: https://public-api.copernico.cloud/api/races/
And a variable element: {race_id}/preset/{login email}:::{preset name}/{event name}
Joining these elements together: https://public-api.copernico.cloud/api/races/{race_id}/preset/{login email}:::{preset name}/{event name}
Where:
- race_id: is the race identifier that you can see in the URL displayed in Copernico. For example: carrera-de-la-mujer-valencia-2020.
- login email: is your email or the email of the Copernico account in which the preset is saved (your colleagues' presets appear in the list grouped by their email).
- preset name: is the name of the preset as shown in the List of presets in Participants. It has to be identical to the name of the preset you want to show. See how to create one in Creating presets.
- event name: is the name of the event from which you want to extract the information. It must be identical to the event name.
An example (for illustration only; replace each part with your own race and preset):
https://public-api.copernico.cloud/api/races/carrera-de-la-mujer-valencia-2020/preset/timer1@timingsense.com:::Mujer/6K
If you have a .json viewer installed, copying and pasting the URL into a browser would load information like the one you see:

ℹ️ Note: the times are shown in milliseconds, so you will have to transform this data to show times in the format you like, for example, HH:MM:SS.
💡 Tip: if you work with Excel or Google Sheets, you can use multiple APIs and append queries to display all events in a single document.
Comments
Please sign in to leave a comment.