app.py

import requests
import json

def save_checkpoint(value):
    with open(".process", "w") as file:
        file.write(str(value))


def get_checkpoint():
    with open(".process", "r") as file:
        return int(file.read())


def get_applications():
    return requests.get("https://api.steampowered.com/ISteamApps/GetAppList/v0002/").json()


def filter_by_price(appids):
    priceDict = {}
    threshold = len(appids) - 1
    checkpoint = get_checkpoint()
    print("checkpoint==", checkpoint, "threshold==", threshold)
    if checkpoint >= threshold:
        save_checkpoint(0)
        checkpoint = -1
    appsParam = ""
    for index, app in enumerate(appids):
        if index > checkpoint and (index == threshold or index % 100 == 0) and len(appsParam) > 0 and index > 0:
            try:
                priceResponse = requests.get("https://store.steampowered.com/api/appdetails?filters=price_overview&appids={}".format(appsParam)).json()
            except:
                priceResponse = None
            appsParam = ""
            if priceResponse is not None:
                for appKey in priceResponse:
                    if 'data' in priceResponse[appKey] \
                            and 'price_overview' in priceResponse[appKey]['data'] \
                            and priceResponse[appKey]['data']['price_overview']['final'] <= 100:
                        priceDict[appKey] = priceResponse[appKey]['data']['price_overview']
            if index % 20000 == 0 or index == threshold:
                save_checkpoint(index)
                checkpoint=index
                break
        elif index > checkpoint:
            appsParam = appsParam + str(app) if len(appsParam) == 0 else appsParam + "," + str(app)
    print("checkpoint=", checkpoint)
    return priceDict

if __name__ == "__main__":
    apps = get_applications()

    appDict = {}
    for app in apps['applist']['apps']:
        appDict[app["appid"]] = app["name"]
    appids = appDict.keys()
    priceDict = filter_by_price(appids)

    for appKey in priceDict:
        priceDict[appKey]['name'] = appDict[int(appKey)]

    previous = {}
    with open("result.json", "r") as inputfile:
        json.load(inputfile)
    result = previous | priceDict

    with open("result.json", "w") as outfile:
        json.dump(result, outfile)
    
    with open("export.csv", "w") as outfile:
        outfile.write("Steam ID,Game,Price\n")

    for appKey in priceDict:
        with open("export.csv", "a") as outfile:
            gameLabel = priceDict[appKey]['name'] \
                if priceDict[appKey]['name'] is not None and len(priceDict[appKey]['name']) == 0 \
                else priceDict[appKey]['name'].replace(",","").replace("\"","")
            outfile.write(appKey + "," + gameLabel + "," + priceDict[appKey]['final_formatted'] + "\n")