I'm currently making a data visualization of all the players in the TF2 community based on logs. I am finished with the actual data collection and visualization, so all I need now is the right names for the labels. The problem is that all I have is steamID3 and I haven't really been able to find a good solution. My dataset is about 6000 so it would be pretty painful to do by hand.
If anyone has any ideas or suggests, I am all ears.
My discord is arcadia#0001
Edit:
Look through this csv and let me know if you want me to change your name on the final graph
here
I'm currently making a data visualization of all the players in the TF2 community based on logs. I am finished with the actual data collection and visualization, so all I need now is the right names for the labels. The problem is that all I have is steamID3 and I haven't really been able to find a good solution. My dataset is about 6000 so it would be pretty painful to do by hand.
If anyone has any ideas or suggests, I am all ears.
My discord is arcadia#0001
Edit:
Look through this csv and let me know if you want me to change your name on the final graph
[url=https://fygisawesome.com/logMap/2021LabelsWithFirstLogName.csv]here[/url]
The Steam API uses 64-bit Steam ID's, so before you could fetch the name you'd have to convert your SteamID3 to a 64-bit Steam ID.
They can be mathematically converted to a 64-bit ID, the actual math behind it is briefly explained in the official Valve documentation but I'd recommend you grab a library for your language of choice since there will almost certainly be someone who already built a package to do the conversion for you.
Once you're at that point you can use the Steam GetPlayerSummaries API to get their current nickname (or better in this context probably: use the league's API to fetch their primary alias).
https://developer.valvesoftware.com/wiki/Steam_Web_API#GetPlayerSummaries_.28v0002.29
RGL used to have an undocumented API to fetch stuff by Steam ID but it seems like it's not available anymore, last time I asked them about it they seemed equally confused about having an API. Not sure if they've built a proper API by now (doubt it), you might be out of luck on that front unless you want to try scraping the data
https://i.imgur.com/qw2samM.png
Alternatively, since the logs should contain names as well you could build a script and see which alias gets used the most for every player
The Steam API uses 64-bit Steam ID's, so before you could fetch the name you'd have to convert your SteamID3 to a 64-bit Steam ID.
They can be mathematically converted to a 64-bit ID, the actual math behind it is briefly explained in the official Valve documentation but I'd recommend you grab a library for your language of choice since there will almost certainly be someone who already built a package to do the conversion for you.
Once you're at that point you can use the Steam GetPlayerSummaries API to get their current nickname (or better in this context probably: use the league's API to fetch their primary alias).
https://developer.valvesoftware.com/wiki/Steam_Web_API#GetPlayerSummaries_.28v0002.29
RGL used to have an undocumented API to fetch stuff by Steam ID but it seems like it's not available anymore, last time I asked them about it they seemed equally confused about having an API. Not sure if they've built a proper API by now (doubt it), you might be out of luck on that front unless you want to try scraping the data
[img]https://i.imgur.com/qw2samM.png[/img]
Alternatively, since the logs should contain names as well you could build a script and see which alias gets used the most for every player
steamid.uk has APIs for converting steam3 to 64 bit as well as getting profile info
https://steamid.uk/steamidapi/
might be the simplest solution
steamid.uk has APIs for converting steam3 to 64 bit as well as getting profile info
https://steamid.uk/steamidapi/
might be the simplest solution
Steam condenser has ruby, java and PHP implementation to do this.
https://github.com/koraktor/steam-condenser
Steam condenser has ruby, java and PHP implementation to do this.
https://github.com/koraktor/steam-condenser
Java/Type script users can use https://www.npmjs.com/package/steamid which is old but still works great.
AdjeRGL used to have an undocumented API to fetch stuff by Steam ID but it seems like it's not available anymore, last time I asked them about it they seemed equally confused about having an API. Not sure if they've built a proper API by now (doubt it), you might be out of luck on that front unless you want to try scraping the data
I had built an unofficial API (view here) but unfortunately sigafoo either doesn't care or doesn't want one and so there is no way for anyone to get data from RGL unless you go against their wishes and scrape around the cloudflare protection. In doing so you risk getting IP banned or worse.
aniccasteamid.uk has APIs for converting steam3 to 64 bit as well as getting profile info
https://steamid.uk/steamidapi/
might be the simplest solution
I wouldn't advise doing this since you could probably hit a rate limit. 6,000 ids is a lot, and there's certainly easier ways to do this much faster.
Here's the solution if you had to convert in code yourself without using packages:
https://developer.valvesoftware.com/wiki/SteamID
Java/Type script users can use https://www.npmjs.com/package/steamid which is old but still works great.
[quote=Adje]RGL used to have an undocumented API to fetch stuff by Steam ID but it seems like it's not available anymore, last time I asked them about it they seemed equally confused about having an API. Not sure if they've built a proper API by now (doubt it), you might be out of luck on that front unless you want to try scraping the data[/quote]
I had built an unofficial API ([url=https://github.com/c43721/rgl-api]view here[/url]) but unfortunately sigafoo either doesn't care or doesn't want one and so there is no way for anyone to get data from RGL unless you go against their wishes and scrape around the cloudflare protection. In doing so you risk getting IP banned or worse.
[quote=anicca]steamid.uk has APIs for converting steam3 to 64 bit as well as getting profile info
https://steamid.uk/steamidapi/
might be the simplest solution[/quote]
I wouldn't advise doing this since you could probably hit a rate limit. 6,000 ids is a lot, and there's certainly easier ways to do this much faster.
Here's the solution if you had to convert in code yourself without using packages:
https://developer.valvesoftware.com/wiki/SteamID
ETF2L's API accepts ID1, so you can convert ID3 to that using 24's link then get (some) player names from that
ETF2L's API accepts ID1, so you can convert ID3 to that using 24's link then get (some) player names from that
Hey quick bump,
Look through this csv and feel free to message me if you want me to change your name.
The csv
Hey quick bump,
Look through this csv and feel free to message me if you want me to change your name.
[url=https://fygisawesome.com/logMap/2021LabelsWithFirstLogName.csv]The csv[/url]
I have a csv of RGL names and 64bit steam ids I've scraped from their website. Planning on scraping through esea, etf2l, ugc, and maybe faceit soon. I'll send you what I have when I get to my PC if that interests you. _flac#5012 on discord
I have a csv of RGL names and 64bit steam ids I've scraped from their website. Planning on scraping through esea, etf2l, ugc, and maybe faceit soon. I'll send you what I have when I get to my PC if that interests you. _flac#5012 on discord