Something went wrong. Try again later

hoechst

This user has not updated recently.

31 573 11 0
Forum Posts Wiki Points Following Followers

hoechst's forum posts

  • 26 results
  • 1
  • 2
  • 3
Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

restrictions:

- you can't search for a year, just individual dates.

- you can only display 100 results at a time.

just use this filter and iterate over the date:

http://www.giantbomb.com/api/games/?api_key=YOURKEY&format=json&field_list=name,original_release_date&filter=original_release_date:2004-01-01

add fields (genre or whatever) to the url as you need them (http://www.giantbomb.com/api/documentation#toc-0-15).

you need to do one query for each date in a year.

if field "number_of_total_results" in the response is >100, do the same query again with added filter "&offset=100". do subsequent queries for that date while "number_of_total_results"-100 is >0. you _probably_ can get by without this whole mechanic as i guess it's unlikely that there's more than 100 releases for any given date, but you be the judge of that.

now you should have queried everything.

as to converting the json data to csv: there's tones of snippets and libraries out there: https://www.google.de/#q=python%20json%20to%20csv

i'm bored, so here's all of this in pseudo code: http://pastebin.com/Y9TBVibz

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

#5  Edited By hoechst

:o

someone actually tried to use this?

it's 3 years old, i didn't even know the api was still a thing. i actually just tried to use it with 7 games and it seems to work with such a small amount. although even that took a few minutes. the tools isn't efficient in any way (no multithreading), but was far as i remeber, it worked (slowly) a few years back.

they might do api throttling now or something.

been looking for the source code for half an hour now. looks like it's gone.

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

#8  Edited By hoechst

I am shocked and speechless. Rest in peace, Ryan Davis. I will miss you.

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

#9  Edited By hoechst

Download speeds weren't great on the old site. Now they are totally ass. I can't evens stream HD videos. No other website is giving me trouble with this (youtube, twitch, etc) and I'm paying for this one... I realize that those other sites probably have dedicated content networks in Europe, but my connection should support this from US servers without any problem.

http://www.speedtest.net/result/2548366716.png
http://www.speedtest.net/result/2548369026.png

Doing a simple download tests of a big video file with wget, I noticed that the download speed (which is 4,5 MByte/s at max..) drops down to 150-300 KByte/s after downloading approx. 75MB of a 4,4GB file. This would explain why I mostly run into troubles in the middle of a video. I assume that this is for buffering / bandwidth saving reasons, and that's fine in concept, but it doesn't seem to be working correctly.

Avatar image for hoechst
hoechst

31

Forum Posts

573

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

  • 26 results
  • 1
  • 2
  • 3