It seems that you're using an outdated browser. Some things may not work as they should (or don't work at all).
We suggest you upgrade newer and better browser like: Chrome, Firefox, Internet Explorer or Opera

×
Community
General discussionYe olde GOG product ids public API charting enterprise(523 posts)(523 posts)
(523 posts)
Pages:
1
5
10
15
20
25
26
27
28
29
30
35
This is my favourite topic
Posted March 24, 2022
This is what I get returned, along with my code replacements and adjustments.

ID = 1100566473
title = Drakensang
description = Drakensang is a third-person party-based RPG based on the pen & paper role-play rules of The Dark Eye. Drakensang is the first PC game for over 10 years to be based on Germany's most successful and popular role-play system.
Drakensang builds on the pen & paper rules as applied in version 4. 0. The developers have optimized the rulebook specially for the PC realization in order to make the game more accessible.
full = Drakensang is a third-person party-based RPG based on the pen & paper role-play rules of The Dark Eye. Drakensang is the first PC game for over 10 years to be based on Germany's most successful and popular role-play system.
Drakensang builds on the pen & paper rules as applied in version 4. 0. The developers have optimized the rulebook specially for the PC realization in order to make the game more accessible. But the essential qualities and the depth of the original rules have not been compromised.
Intensive tactical combat and intriguing quests, embedded in a wonderfully detailed 3D graphic presentation — these are the cornerstones of the fantasy epic.
whats_cool_about_it = Experience an exciting story within a huge campaign involving numerous main and side quests
Adventure groups with up to four adventurers
Expert character-creation mode for experienced DSA fans
More than 40 spells, with over 30 talents and almost 40 special abilities allow a large range of possibilities for character creation
Numerous and varied enemies and monsters from the DSA universe, such as linnorms, ogres, undead mules, giant amoeba and many more
Story by original DSA authors
Rule-compliant implementation of the DSA licence in the tradition of the Nordland Trilogy
Tactical combat system with pause function
Varied and flexible magic system
Talent-based dialogue system
Posted March 24, 2022
avatar
WinterSnowfall: It is quite possible (and saner even) to reconstruct publisher/developer data by collecting a full list of developer/publisher values from each game ID, using the v2 games API endpoint, e.g. : https://api.gog.com/v2/games/1?locale=en-US
Thank you for that, it is exactly why I came here today looking for, as I am revamping a portion of my wishlist program code, and I wanted a simple quick way to get copyright holder and developer names.

i.e. https://api.gog.com/v2/games/1078350245?locale=en-US

I also note it lists tags and features, so genre and singleplayer &/or etc, which is what I was also after.

Previously I have just been using the slower scraping method to get all those and more.

I of course use the following now to get most of the rest I need.

https://api.gog.com/products/1078350245?expand=downloads,expanded_dlcs,description,screenshots

Once again, BIG THANKS.
Post edited March 24, 2022 by Timboli
Posted March 24, 2022
avatar
Timboli: So it may be no issue to just simply remove them from any return.
That's what I ended up doing, because somewhere along the way of dropping them in a db table and back, those unicode control chars were interpreted rather than saved as-is for some reason. I'm still amazed they'd randomly show up in game cards, but anyway... GOG is GOG...

avatar
Timboli: Once again, BIG THANKS.
No worries. If you have any other questions about the APIs which I've not addressed here I'm happy to oblige :). If I have an answer - the APIs are dark and full of terrors.
Post edited March 27, 2022 by WinterSnowfall
Posted March 25, 2022
high rated
I guess some people may remember a large portion of my API query scripts were already available on github.

Well, now all of them are, including the Galaxy builds vs offline installer comparison logic I've talked about in the posts above and the backend data collection utilities that scrape the data for it. It's all here, now dubbed under the project's original name of "gog_gles": https://github.com/WinterSnowfall/gog_gles

I've taken the liberty of keeping a separate branch with more sensitive stuff (hiding from the GOGBear shenanigans), but functionally it's pretty much identical as far as API calls are concerned.

I hope it'll prove a useful reference to some people at least, and of course now if I ever suddenly kick the bucket, it's all there for posterity.
Post edited March 25, 2022 by WinterSnowfall
Posted March 25, 2022
Thanks again.
Posted March 27, 2022
Apparently GOG has really stated fixing up some discrepancies, including some of the older ones (I expect this is due to mrkgnao's insistance)... unfortunately, there's also a bit of less good news...

avatar
mrkgnao: I will attempt to report these to GOG (again).
It looks like GOG has taken your reports quite literally and they've only corrected Mac and Windows installers, ignoring similar Linux installer discrepancies which sadly can't be tracked because Galaxy has no Linux support...

One example of this is "Sphinx and the Cursed Mummy", ID 1118073204 -> the Mac installer has been upgraded to 2019.08.28, however the Linux installer is still on 2019.03.26 (as was the case with the Mac installer before you reported it).
Post edited March 27, 2022 by WinterSnowfall
Posted March 27, 2022
avatar
WinterSnowfall: Apparently GOG has really stated fixing up some discrepancies, including some of the older ones (I expect this is due to mrkgnao's insistance)... unfortunately, there's also a bit of less good news...
Good news.

avatar
mrkgnao: I will attempt to report these to GOG (again).
avatar
WinterSnowfall: It looks like GOG has taken your reports quite literally and they've only corrected Mac and Windows installers, ignoring similar Linux installer discrepancies which sadly can't be tracked because Galaxy has no Linux support...

One example of this is "Sphinx and the Cursed Mummy", ID 1118073204 -> the Mac installer has been upgraded to 2019.08.28, however the Linux installer is still on 2019.03.26 (as was the case with the Mac installer before you reported it).
Well, if you create a table of games where the linux offline installer version differs from the windows offline installer version, then we can go over it, clean it up, and then nag GOG about it.
Posted March 28, 2022
avatar
mrkgnao: Well, if you create a table of games where the linux offline installer version differs from the windows offline installer version, then we can go over it, clean it up, and then nag GOG about it.
Alright, sounds like a decent plan.I'll post a link here when the list is ready... and at least partially sane.
Posted March 28, 2022
avatar
mrkgnao: Well, if you create a table of games where the linux offline installer version differs from the windows offline installer version, then we can go over it, clean it up, and then nag GOG about it.
It's not exactly a table, since I don't see myself tracking esoteric differences on what are already very shaky grounds, but I've SQLed my way into listing the differences between the latest windows installer version and the latest linux installer version for all IDs.

Here's an unfiltered csv export: https://drive.google.com/file/d/1ZyVAwaPB0H073fWZgA5Jr5S4srhmJUgy/view?usp=sharing

And here's an ODS (I hope penguins are your friends :) where I filtered out obvious and likely false positives already: https://drive.google.com/file/d/1SrW72tPzlovszxfEfkOdgggY61z3k1wn/view?usp=sharing

I can regenerate it at a later date if we ever need to check things again, but... let's not do it very often. GOG's versioning system really is a lesser known circle of hell.
Post edited March 28, 2022 by WinterSnowfall
Posted March 28, 2022
avatar
WinterSnowfall: ......
FYI this is what I have been working on and it works well.

Screenshot 1 - Main Window

Screenshot 2 - ID Search

You can ADD a game to the list, along with details and two images, using the GOG Game ID.
The ADD button does that or updates a selected entry.
Or alternatively you can use the GET GAME ID button along with some title text to get one or more Game IDs.
The title can be full or partial, which will determine how many returns you get, as shown in the second screenshot.
One image is the Box Art cover image (first screenshot). You can click that to see a larger (widescreen) second image.

Once again, BIG THANKS for your assistance in this thread.
Posted March 28, 2022
avatar
mrkgnao: Well, if you create a table of games where the linux offline installer version differs from the windows offline installer version, then we can go over it, clean it up, and then nag GOG about it.
avatar
WinterSnowfall: It's not exactly a table, since I don't see myself tracking esoteric differences on what are already very shaky grounds, but I've SQLed my way into listing the differences between the latest windows installer version and the latest linux installer version for all IDs.

Here's an unfiltered csv export: https://drive.google.com/file/d/1ZyVAwaPB0H073fWZgA5Jr5S4srhmJUgy/view?usp=sharing

And here's an ODS (I hope penguins are your friends :) where I filtered out obvious and likely false positives already: https://drive.google.com/file/d/1SrW72tPzlovszxfEfkOdgggY61z3k1wn/view?usp=sharing

I can regenerate it at a later date if we ever need to check things again, but... let's not do it very often. GOG's versioning system really is a lesser known circle of hell.
First: I don't think ODS has much to do with penguins. It is, I believe, the format used by Libre Office (on Win, Mac, Linux, etc.), which is an offshoot of the earlier Open Office, which is an offshoot of the even earlier Star Office. Star Office was born in the 1980s, well before Linux was dreamt of. In fact, I still remember using Star Office on MS-DOS in the late 1980s (before I discovered WordPerfect).

Since I use Open Office on Windows regularly (I don't want to pay for MS Office and I don't like Libre Office), I am well acquainted with ODS, ODT, etc.

Second: Oh your god, this is a long list. I didn't expect it to be so long. I'm afraid it's a lost cause, at least for me. If I was using Linux on my desktop, I might have been tempted to wade into the morass, by I'm not and I'm unlikely to ever be (after four spectacularly failed past attempts to use it). Perhaps someone who does use Linux might be interested.
Post edited March 28, 2022 by mrkgnao
Posted March 28, 2022
I do not know much about programming but what I do know about is databases and filling them with data. What I do not understand is why there is no consistency. A simple way would be to set up checklists for different tasks you may want to do in the database and then whoever from GOG does a change to the data has to follow that checklist. Whenever you run into trouble you do NOT just shrug and fill in whatever but report the problems in either database setup or the checklists. Then those should be changed according to need and new checklists made and translated. I thought this was kind of basics but maybe noone at GOG has secretarial schooling.
Posted March 29, 2022
avatar
mrkgnao: Second: Oh your god, this is a long list.
... and I've already used every trick in the book, including dropping "(gog-x)" like installer versions

avatar
mrkgnao: I didn't expect it to be so long.
Comparing windows installer versions to linux installers was never going to be ideal, but at least it's something.

avatar
mrkgnao: I'm afraid it's a lost cause, at least for me.
I'll try to run some of these against what I own from that list and confirm at least what is blatantly obvious, then I'll make a shortlist. But I'll put this in the slow burner for now, got bigger fish to fry elsewhere. What was the patron saint of lost causes again? :P We might need his/her help.

avatar
Themken: What I do not understand is why there is no consistency.
Beside the insert "this is GOG!" (Sparta) meme, it's mostly because Linux is not supported by Galaxy, so there's really no way of tracking available Galaxy builds in the APIs. Linux installers are simply a stand-alone affair and a lot harder to track and generate if you are a developer/publisher.
Post edited March 29, 2022 by WinterSnowfall
Posted March 29, 2022
avatar
WinterSnowfall: ......
avatar
Timboli: FYI this is what I have been working on and it works well.
...................
I've now updated to GetGameInfo v1.2, and decided to share my little side project and given you a thank you on the download page.

DOWNLOAD PAGE
Posted March 29, 2022
avatar
Timboli: I've now updated to GetGameInfo v1.2, and decided to share my little side project and given you a thank you on the download page.
Happy to have helped :). Nice work!
Pages:
1
5
10
15
20
25
26
27
28
29
30
35
This is my favourite topic
Community
General discussionYe olde GOG product ids public API charting enterprise(523 posts)(523 posts)
(523 posts)