How to programmatically get free agents for a league?

Hi, OK, I understand, no API. =IMPORTDATA(“https://ottoneu.fangraphs.com/“&000&”/rosterexport?csv=1”) will give me rosters of league #000. Is there a similar call I can use to get league free agents?
Thank you, C

You can just download the player universe, which is pretty regularly updated, and if a player is not on an active roster in your league, they are a free agent.

Niv…You know I always appreciate your fast replies and how much you care about the platform and the game, thanks! And yet–a follow up question: how do I “download the player universe?” Instead of “rosterexport,” is there a different call? And I apologize if this is all documented somewhere; I just haven’t found it.

1 Like

It’s in the thread I linked to in my response. Just click on the link and check that thread out. I publish player universes pretty regularly there.

Sorry if this is something I should have found myself, but how can I identify upcoming drafts that I could use as a datapoint to check a spreadsheet tool I’m making?

Hi Niv,

To programmatically monitor an auction draft, is hitting https://ottoneu.fangraphs.com/“&366&”/rosterexport?csv=1 periodically and reflecting changes in the “team name” and “salary” fields the right solution? Players that are on your “universe” sheet but have no team name are tagged as free agents.

(In effect, I’m assuming that the pre-season auction is the same as other in-season transactions, only faster.)

Thank you, Chris

Hey man,

I am unfortunately not going to be able to step you through the answers for every dev question you have.

There is a tools channel on Slack as well as here

You can read through there and mostly try to figure things out on your own. I believe in you in terms of light experimentation, you’ll be able to get most things working. Just be careful to not make so many requests that I notice, because if the site suffers I’ll have to start blocking IPs, etc.

Good luck!