List Data

Sometimes you want the ability to apply additional filters to output lists or easily adapt what is shown without building more Output Lists. 

To LIST data use a Custom API with:

data/list?

There are some additional parameters which can be appended here, parameters can either be used in the API details in the API setup if they should apply to all API calls, or can be appended to the end of the API url in the API call, when appending to the API url then append "?" first before the parameters.

&fields=
Choose which fields should be listed, multiple fields should be joined with "%2C", this is the URL encoded format of "&"

&sort=
How the data should be sorted

&filterbib=
Quickly filter the list by bib number

&filter=
Allows any standard filter to be applied to the list, remember to use percent encoding for any special characters in the string, multiple filters can be joined using AND

&listformat=
Define the format of the returned values. (e.g. Simple, CSV, XML, JSON)

&separator=
Define the text separator when using TEXT or CSV format

 

Example:

API Details: data/list?fields=RiderID%2CFirstName%2CLastName%2CMaleFemale%2CDateOfBirth%2CATF12%2CATF13
URL: https://api.raceresult.com/111952/6XENXE0KZY1NBFJDB57UQWS14R0L6R2H

Returns a list of all riders with the RiderID (ATF), FirstName, LastName, MaleFemale, DateOfBirth, ATF12 and ATF13, in the default TEXT format.

Appending some additional parameters will filter this by bib and change the format to XML

https://api.raceresult.com/111952/6XENXE0KZY1NBFJDB57UQWS14R0L6R2H?&filterbib=11&listformat=XML