Record API - Categories with subcategories return wrong times

[chfo]

Hello. If you use the api_records some game categories deliver wrong times if they have a subcategrorie.

For example smo Any%:
https://www.speedrun.com/api_records.php?game=smo returns:

and this is how it looks on the website:

The 2P time is faster so it delivers this time.
Overall this leads to wrong results
A good Solution would be the following:
return also all subcategories: The command should not return Any% it should return Any%-1P and Any%-2P

regards

[CapitaineToinon]

The problem is also present using this API endpoint : https://www.speedrun.com/api/v1/games/smo/records

[CapitaineToinon]

So here's how to get around the problem. Although if you think about it this is the expected behavior. Sub categories are just variables that goes on top of a category so technically, the fastest run in Any% could be a 2P run. It's just not what we're intuitively expecting. Maybe a feature request like calling /games/smo/records to get records regardless of subcategories and /games/smo/records?defaults=true to get records with default sub categories values ?

Anyway here it is.

First call the games api for your game with variables and cateogires embed :
https://www.speedrun.com/api/v1/games/smo?embed=variables,categories

{
  data: {
    id: "76r55vd8",
    names: {},
    abbreviation: "smo",
    weblink: "https://www.speedrun.com/smo",
    released: 2017,
    release-date: "2017-10-27",
    ruleset: {},
    romhack: false,
    gametypes: [ ],
    platforms: [],
    regions: [],
    genres: [],
    engines: [ ],
    developers: [],
    publishers: [],
    moderators: {},
    created: "2017-09-27T00:35:19Z",
    assets: {},
    links: [],
    categories: {},
    variables: {}
  }
}

And from here, call the leaderboards endpoint for each category instead using each variable having is-subcategory to true and adding to the url variable.id and variable.values.default using the format var-id=value.

This for example will give the SMO Any% (Leagacy Versions, 1P) leaderboards:
https://www.speedrun.com/api/v1/leaderboards/76r55vd8/category/w20w1lzd?var-ylq9r4m8=gq7g4odq&var-68km3w4l=zqoyz021

This is pretty bad though since you go from 1 API call to, in the case of smo, 13 calls to get all the categories.

[Winning117]

It should be noted that subcategories return the wrong times only if the subcategory is not specified as a variable. If you specify the subcategory (variable with corresponding choice) for the API request, the data you receive will be correct.