ZXDB based Open API

This is the place for general discussion and updates about the ZXDB Database. This forum is not specific to Spectrum Computing.

Moderator: druellan

User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

druellan wrote: Sat May 19, 2018 2:19 pm Hi! Quick question. What's the meaning of the "availability" property?

I thought it was referring to the fact that the game is available (or has permission) to be downloaded.

But if you search for new games using:

https://api.zxinfo.dk/api/zxinfo/v2/sea ... =Available

The list is not the same as using:

https://api.zxinfo.dk/api/zxinfo/v2/sea ... e=SOFTWARE

Not sure if this is a mistake or I'm confused about the meaning of this property.

Thanks!
The two queries are not the same, first one only search for "SOFTWARE" where availability status is Available, the other one search for any "SOFTWARE.

For more info on values for availablity, look at https://github.com/zxdb/ZXDB and in the section: Enumeration tables

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
druellan
Dynamite Dan
Posts: 1466
Joined: Tue Apr 03, 2018 7:19 pm

Re: ZXDB based Open API

Post by druellan »

HI kolbeck. And yes, exactly, but I think I was not clear enough about the problem. Mind, that is not a problem with your API, but probably something related to data entry. I've added this here because I can't check this information directly.

Let's try this:

This game: https://zxinfo.dk/details/0034299
Is missing the "available" tag, but, is ready for download, so, unless I'm confused about what "available" should indicate, I think it is.

Following that interpretation, If you look at both queries, many games added after "Go Race!" should be available, and are not.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

Hi

I vaguely remember this being discusses here before, maybe [mention]Einar Saukas[/mention] can remeber the thread with the discussion of "Availability"?

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Hi kolbeck.
Sorry my ignorance but how can I take an image from a link?
For example: "cover_image":"/pub/sinclair/magazines/SinclairUser/Issue001/SUCover001.jpg" ?

Thank you.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: ZXDB based Open API

Post by Einar Saukas »

From ZXDB at GitHub:
Local file links starting with /pub/sinclair/ refer to content previously available at the original WorldOfSpectrum archive. These files are currently accessible from Archive.org mirror at https://archive.org/download/World_of_S ... /sinclair/

Local file links starting with /zxdb/sinclair/ refer to content added afterwards. These files are currently stored at https://spectrumcomputing.co.uk/zxdb/sinclair/
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: ZXDB based Open API

Post by Einar Saukas »

druellan wrote: Sat May 19, 2018 2:19 pmWhat's the meaning of the "availability" property?
Sorry, this property is outdated.

For the most part, it stores the availability status (M.I.A., available or denied) specifically for WoS, at the time Martijn stopped updating it. Afterwards, certain denied titles granted permission to SC, certain available titles revoked permission from WoS, certain M.I.A. titles were recovered and added to ZXDB, etc.

It's not just a matter of updating this information, because distribution permissions apply to specific sites, so this property doesn't make sense for ZXDB as a whole. I will need to reconsider this property later...
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Einar Saukas wrote: Mon Jun 04, 2018 12:42 am From ZXDB at GitHub:
Local file links starting with /pub/sinclair/ refer to content previously available at the original WorldOfSpectrum archive. These files are currently accessible from Archive.org mirror at https://archive.org/download/World_of_S ... /sinclair/

Local file links starting with /zxdb/sinclair/ refer to content added afterwards. These files are currently stored at https://spectrumcomputing.co.uk/zxdb/sinclair/
Understood.
I´m making an Android app but with this way I can´t show the cover image of magazines so... :(
User avatar
druellan
Dynamite Dan
Posts: 1466
Joined: Tue Apr 03, 2018 7:19 pm

Re: ZXDB based Open API

Post by druellan »

Einar Saukas wrote: Mon Jun 04, 2018 1:48 am
druellan wrote: Sat May 19, 2018 2:19 pmWhat's the meaning of the "availability" property?
It's not just a matter of updating this information, because distribution permissions apply to specific sites, so this property doesn't make sense for ZXDB as a whole. I will need to reconsider this property later...
Yeah. I can see the problem. I think the only property that might have direct relation to the ZXDB could be a MIA indicator.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: ZXDB based Open API

Post by Einar Saukas »

Turrican wrote: Tue Jun 05, 2018 12:42 amUnderstood.
I´m making an Android app but with this way I can´t show the cover image of magazines so... :(
Now you just need to apply the rule I described.

For example:

"cover_image":"/pub/sinclair/magazines/SinclairUser/Issue001/SUCover001.jpg"

This file can be found at:

https://archive.org/download/World_of_S ... ver001.jpg
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Einar Saukas wrote: Tue Jun 05, 2018 3:43 am
Turrican wrote: Tue Jun 05, 2018 12:42 amUnderstood.
I´m making an Android app but with this way I can´t show the cover image of magazines so... :(
Now you just need to apply the rule I described.

For example:

"cover_image":"/pub/sinclair/magazines/SinclairUser/Issue001/SUCover001.jpg"

This file can be found at:

https://archive.org/download/World_of_S ... ver001.jpg
Ahhhh. Ok. Thanks.
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: ZXDB based Open API

Post by Einar Saukas »

You are welcome!
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Ok. It lives! :)


Image
User avatar
R-Tape
Site Admin
Posts: 6353
Joined: Thu Nov 09, 2017 11:46 am

Re: ZXDB based Open API

Post by R-Tape »

Turrican wrote: Sat Jun 09, 2018 3:40 pm Ok. It lives! :)
Link! Or is it still at the dev stage?
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

R-Tape wrote: Sat Jun 09, 2018 4:10 pm
Turrican wrote: Sat Jun 09, 2018 3:40 pm Ok. It lives! :)
Link! Or is it still at the dev stage?
Still at dev stage.
Only a single query by Magazine Name yet.
I will implement more features.

Only for Android.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

Turrican wrote: Sat Jun 09, 2018 3:40 pm Ok. It lives! :)


Image
Oohh.. just so awesome :-)
Please don't hestistate getting in touch if you need help with the API, suggestions for improvement and all that kind of stuff :)

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

kolbeck wrote: Wed Jun 13, 2018 8:10 am
Turrican wrote: Sat Jun 09, 2018 3:40 pm Ok. It lives! :)


Image
Oohh.. just so awesome :-)
Please don't hestistate getting in touch if you need help with the API, suggestions for improvement and all that kind of stuff :)

/Thomas
Sure, thank you!
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

website and API updated to latest ZXDB (June 26) - sorry for the delay :?

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Hi Thomas, how are you?
The certificate of api.zxinfo.dk has expired and the app stopped to work.
Do you have in mind to revalidate the certificate?

Thank you.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

Turrican wrote: Fri Sep 14, 2018 1:07 am Hi Thomas, how are you?
The certificate of api.zxinfo.dk has expired and the app stopped to work.
Do you have in mind to revalidate the certificate?

Thank you.
Opps - looks like auto renewal doesn't work - manually renewed, should be working again. Thanks for the heads-up!

/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Working.
Thank you.
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

Hi Thomas.
Is the api in the magazine search case sensitive?
If you type "your spectrum" there is no result but "Your Spectrum" works.
In the general search the lower case works ok.
Thanks.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

Hi,

Sorry for not seeing this!! (looks like I'm not getting any SC notifications at all).

In general ZXInfo API is case-insensitive, but as magazine was added later I might have forgot to do it properly. I will have a look at let you know
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

Hello [mention]Turrican[/mention] ,

Still working on this. Since the API has not been updated for quite some time, updating and getting to compile is not a trivial task - but i'm working on it and will keep you updated. In the mean time, which API endpoint do you use for the search?

BTW: Got an Android phone in my hand for the first time, and your app was the first installed - great work!

cheers
/Thomas
https://api.zxinfo.dk/v3/ - ZXDB API for developers
zxinfo-file-browser - Cross platform app to manage your files
https://zxinfo.dk - another ZXDB frontend
User avatar
Turrican
Microbot
Posts: 187
Joined: Thu Apr 12, 2018 5:48 pm
Location: Brazil

Re: ZXDB based Open API

Post by Turrican »

kolbeck wrote: Fri Oct 12, 2018 11:27 pm Hello @Turrican ,

Still working on this. Since the API has not been updated for quite some time, updating and getting to compile is not a trivial task - but i'm working on it and will keep you updated. In the mean time, which API endpoint do you use for the search?

BTW: Got an Android phone in my hand for the first time, and your app was the first installed - great work!

cheers
/Thomas
Hi Thomas.
I´m using 2:
1-) /v2/search for General List
2-) /v2/magazines/{magazine-name}/issues for Magazine Search.

Regards!
User avatar
PeterJ
Site Admin
Posts: 6855
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: ZXDB based Open API

Post by PeterJ »

kolbeck wrote: Sat Oct 06, 2018 8:19 am Sorry for not seeing this!! (looks like I'm not getting any SC notifications at all).

Hi Thomas, could you try resubscribing to the topic? I checked and emails are being sent out to other users. Let me know if you still have issues.

Peter
Locked