Page 1 of 5

Re: ZXDB based Open API

Posted: Fri Mar 23, 2018 8:53 pm
by kolbeck
IMPORTANT:

For now the API is https only, let me know if that's a problem.

/Thomas

Re: ZXDB based Open API

Posted: Sat Mar 24, 2018 3:29 am
by Einar Saukas
This API is awesome!!!

Also it's nice to see how much attention Thomas gives to people's suggestions and how fast he implements them. :)

This API is already being used by Dario's SpeccyBot, an interactive chat bot for Telegram that allows searching online for Spectrum related information. You can see it in action here:

Image

Unfortunately it's currently available in Spanish only. Hopefully it won't take too long to get an English version... For further information:

https://github.com/druellan/speccybot

Re: ZXDB based Open API

Posted: Sat Mar 24, 2018 9:11 am
by kolbeck
Thank you [mention]Einar Saukas[/mention] - part of openness is to pay attention to the users, this case (potentially) all of you.

Let me also inform, that from now on the ZXDB API is hosted on a professional web hosting / datacenter - to ensure top quality performance, stability & availability.

/Thomas

Re: ZXDB based Open API

Posted: Wed Mar 28, 2018 8:54 am
by kolbeck
Hello

The ZXInfo API has been updated to latest ZXDB as of March 28th.

Re: ZXDB based Open API

Posted: Wed Mar 28, 2018 12:23 pm
by Einar Saukas
That's fast! Thank you!

Re: ZXDB based Open API

Posted: Fri Mar 30, 2018 12:48 am
by kolbeck
New beta of ZXDB API has just been released. This version contains WIP of a Magazine focused API

Find more info here: https://api.zxinfo.dk/doc/

TLDR;
Quick examples of use:
List all magazines
https://api.zxinfo.dk/api/zxinfo/v2/mag ... t=name_asc

Show (short)issue info for Sinclair User
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ser/issues

Show full info for issue-id 7 for Sinclair User
https://api.zxinfo.dk/api/zxinfo/v2/mag ... r/issues/7

Show only references in issue-id=7
https://api.zxinfo.dk/api/zxinfo/v2/mag ... references

Show only files in issue-id=7
https://api.zxinfo.dk/api/zxinfo/v2/mag ... es/7/files

Note: issue-id is the internal ZXDB issue-ID and can be found by using the .../issue method.

Better search for magazines is next on the list 8-)
/Thomas

Re: ZXDB based Open API

Posted: Fri Mar 30, 2018 10:57 pm
by Einar Saukas
Awesome! :)

Re: ZXDB based Open API

Posted: Tue Apr 03, 2018 7:28 pm
by druellan
This is awesome! Thanks both of you for making this possible :D

Image

Re: ZXDB based Open API

Posted: Thu Apr 05, 2018 9:11 pm
by kolbeck
API updated to ZXDB as per. 5th. April 2018 :-)

Re: ZXDB based Open API

Posted: Sat May 19, 2018 2:19 pm
by druellan
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!

Re: ZXDB based Open API

Posted: Sun May 20, 2018 7:57 am
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

Re: ZXDB based Open API

Posted: Sun May 20, 2018 12:08 pm
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.

Re: ZXDB based Open API

Posted: Tue May 22, 2018 7:50 am
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

Re: ZXDB based Open API

Posted: Mon Jun 04, 2018 12:29 am
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.

Re: ZXDB based Open API

Posted: Mon Jun 04, 2018 12:42 am
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/

Re: ZXDB based Open API

Posted: Mon Jun 04, 2018 1:48 am
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...

Re: ZXDB based Open API

Posted: Tue Jun 05, 2018 12:42 am
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... :(

Re: ZXDB based Open API

Posted: Tue Jun 05, 2018 2:17 am
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.

Re: ZXDB based Open API

Posted: Tue Jun 05, 2018 3:43 am
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

Re: ZXDB based Open API

Posted: Wed Jun 06, 2018 10:24 pm
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.

Re: ZXDB based Open API

Posted: Wed Jun 06, 2018 10:29 pm
by Einar Saukas
You are welcome!

Re: ZXDB based Open API

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


Image

Re: ZXDB based Open API

Posted: Sat Jun 09, 2018 4:10 pm
by R-Tape
Turrican wrote: Sat Jun 09, 2018 3:40 pm Ok. It lives! :)
Link! Or is it still at the dev stage?

Re: ZXDB based Open API

Posted: Sat Jun 09, 2018 4:22 pm
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.

Re: ZXDB based Open API

Posted: Wed Jun 13, 2018 8:10 am
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