[AJUDA] Ferramenta para scrape de metadados e mídia do STEAM

[Snayperskaya]

Povo, tou precisando de uma ajuda. Eu uso o Launchbox para emulação, mas queria ter uma instalação limpa do mesmo pra servir somente como catálogo digital de jogos que não estão instalados, pra decidir o que jogar. Possuo uma lista de jogos da minha coleção em .TXT.

Preciso que a ferramenta:

1. Leia linha a linha desse arquivo e busque na database da STEAM pra achar o APPID referente;
2. Mostre uma tabela com: Nome da lista .TXT, APPID que encontrou, Nome do jogo na STEAM referente a esse APPID. Essa lista deve ser modificável manualmente;
3. Use o valor do APPID da tabela acima para fazer scrape de metadados da STEAM dos seguintes valores: Nome do jogo, desenvolvedora, publisher, gênero, data de lançamento, play mode (single player, coop local, etc);
4. Popule o XML no padrão do Launchbox com os valores adquiridos acima;
5. Use o valor do APPID da tabela acima para fazer scrape de mídia da STEAM: Steam banner, vídeo principal e dois screenshots;

Links úteis:

Scraping the Steam game store with Scrapy - Zyte #1 Web Scraping Service

This is a guest post from the folks over at Intoli, one of the awesome companies providing Scrapy commercial support and longtime Scrapy fans. Introduction The Steam game store is home to more than ten thousand games and just shy of four million user-submitted reviews. While all kinds of Steam...

blog.scrapinghub.com

https://github.com/JosefNemec/Playnite/tree/master/source/Plugins/SteamLibrary (Playnite é outro frontend)

Steam Scraper

Steam Scraper View File Plugin that scrapes Steam Information, banner, screenshots and video to a selected game. Requirements: Launchbox 8.8+ Install: Extract the content of zip file to : Launchbox/plugins/SteamScraper Source code: Github (feel free to make a pull request ) Thanks to: @fawkesyeah...

forums.launchbox-app.com

Modelo do XML:

<Game>
    <ApplicationPath>..\SORRv5\SorR.exe</ApplicationPath>
    <CommandLine />
    <Completed>false</Completed>
    <ConfigurationCommandLine />
    <ConfigurationPath />
    <DateAdded>2019-12-19T19:15:29.0660423-03:00</DateAdded>
    <DateModified>2019-12-19T19:15:29.0660423-03:00</DateModified>
    <Developer>Bomber Games</Developer>
    <DosBoxConfigurationPath />
    <Emulator />
    <Favorite>false</Favorite>
    <ID>f97ae1cc-5348-4e34-95e7-5a29116fe261</ID>
    <ManualPath />
    <MusicPath />
    <Notes>Streets of Rage Remake is a project created from scratch, it does not use reverse engineering nor a single line of code from the original games. It’s all based on visual interpretation, comparing how things work in the original games and trying to mimic it for Streets of Rage Remake. Animation timing, animation positioning, control response, X/Y/Z positions and physical movement for all characters are accurate to the original games. Autosave savestates that allow you to continue the game from the same point. Over 30 configurable options in the menu. 6-button controller actions. The game includes original cutscenes between stages, totalling over 40 cutscenes and 8 endings. Over 10 designers have been working for years to create new sprites, creating 19 playable characters all with a complete set of moves, new enemies, new details on the stages and much more. The music has been remixed by 5 different musicians and span practically all the songs in the original series, including Game Gear versions and some new tracks, a total of 76 songs.</Notes>
    <Platform>Windows</Platform>
    <Publisher>Bomber Games</Publisher>
    <Rating>T - Teen</Rating>
    <ReleaseDate>2011-04-03T04:00:00-03:00</ReleaseDate>
    <RootFolder>..\SORRv5</RootFolder>
    <ScummVMAspectCorrection>true</ScummVMAspectCorrection>
    <ScummVMFullscreen>true</ScummVMFullscreen>
    <ScummVMGameDataFolderPath />
    <ScummVMGameType />
    <SortTitle />
    <Source />
    <StarRatingFloat>0</StarRatingFloat>
    <StarRating>0</StarRating>
    <CommunityStarRating>0</CommunityStarRating>
    <CommunityStarRatingTotalVotes>0</CommunityStarRatingTotalVotes>
    <Status />
    <DatabaseID>25494</DatabaseID>
    <WikipediaURL />
    <Title>Streets of Rage Remake</Title>
    <UseDosBox>false</UseDosBox>
    <UseScummVM>false</UseScummVM>
    <Version />
    <Series />
    <PlayMode>Cooperative; Multiplayer</PlayMode>
    <Region />
    <PlayCount>0</PlayCount>
    <Portable>false</Portable>
    <VideoPath />
    <Hide>false</Hide>
    <Broken>false</Broken>
    <Genre>Action;Beat 'em Up</Genre>
    <MissingVideo>false</MissingVideo>
    <MissingBoxFrontImage>false</MissingBoxFrontImage>
    <MissingScreenshotImage>false</MissingScreenshotImage>
    <MissingClearLogoImage>false</MissingClearLogoImage>
    <MissingBackgroundImage>false</MissingBackgroundImage>
    <MissingBox3dImage>false</MissingBox3dImage>
    <MissingCartImage>false</MissingCartImage>
    <MissingCart3dImage>false</MissingCart3dImage>
    <MissingManual>false</MissingManual>
    <UseStartupScreen>false</UseStartupScreen>
    <HideAllNonExclusiveFullscreenWindows>false</HideAllNonExclusiveFullscreenWindows>
    <StartupLoadDelay>0</StartupLoadDelay>
    <HideMouseCursorInGame>false</HideMouseCursorInGame>
    <DisableShutdownScreen>false</DisableShutdownScreen>
    <AggressiveWindowHiding>false</AggressiveWindowHiding>
    <OverrideDefaultStartupScreenSettings>false</OverrideDefaultStartupScreenSettings>
    <UsePauseScreen>false</UsePauseScreen>
    <PauseAutoHotkeyScript />
    <ResumeAutoHotkeyScript />
    <OverrideDefaultPauseScreenSettings>false</OverrideDefaultPauseScreenSettings>
    <SuspendProcessOnPause>false</SuspendProcessOnPause>
    <ForcefulPauseScreenActivation>false</ForcefulPauseScreenActivation>
    <LoadStateAutoHotkeyScript />
    <SaveStateAutoHotkeyScript />
    <ResetAutoHotkeyScript />
    <SwapDiscsAutoHotkeyScript />
    <CustomDosBoxVersionPath />
    <AndroidBoxFrontThumbPath />
    <AndroidBoxFrontFullPath />
    <AndroidBackgroundPath />
  </Game>

Não programo há quase uma década (além de scripts batch e powershell), então tou completamente enferrujado e não queria ter de reaprender somente pra isso.

Alguém se habilita?

 

[Nano]

Faz em Powershell mesmo.

Faz um "for" que pega o APPID e chama essa API: https://store.steampowered.com/api/appdetails?appids=<APPID> (exemplo: https://store.steampowered.com/api/appdetails?appids=220)
A API retorna um JSON, só usar o proprio PS pra ler o JSON. Acho que o mais difícil aí vai ser jogar pro padrão do LB.

Me parece que a API já mostra tudo que você quer.