Would be nice if there was a way to get a list of users (by user id) that have favourited a post using the api. Currently you can get if one user have favourited a post and the amount of favourites a post has, but not a list of all users that have favourited a post. Since this information is public and can be viewed on any post then there should be a way to interact with it using the api, do you guys have any thougts about this?

Isn't there some file you can download that has that? Not messed with the database stuff, yet...

alphamule said:
Isn't there some file you can download that has that? Not messed with the database stuff, yet...

Quicky looked through one of the posts.csv file, didnt find anything relating to favourites, but i also dont really know anything about how the database works. If it was in the database that would be great because im not seeking to be super up to date.

kora_viridian said:
The posts.csv file has the favorite count for each post - see the fav_count column - but not the list of who favorited it. I don't think any of the other CSV files have anything relevant.

This forum post claims that the current API (spring 2020 and later) doesn't support it, although it may have been supported in the past.

There's always the ol' reliable...

for($i=1;$i<3880825;$i++)
  {
  wget -O $i.html 'https://e621.net/posts/$i/favorites';
  sleep 1;
  }

Should only take about a month and a half...plenty of time to develop another script to parse the data out of 3 million HTML files. :D

CAUTION: Use of the above code may cause Cloudflare and/or e621 to b& you. Or an e621 admin may track you down and beat you with large polymer castings...

yea that probably wont work lmao, ive tried scraping single pages with python but it just returned the 403 access denied page. Tried wget just now, also returns 403 forbidden. If there was any way to get around this then that would be great but obviously not sustainable, thank you anyways!

kora_viridian said:
Read what the fine manual says about User-Agent. They're not kidding about it. Both the Python HTTP library and command-line tools like wget will have a way to set it.

it works! Thanks so much!