Page 2 of 5

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

Re: ZXDB based Open API

Posted: Thu Jun 14, 2018 12:57 am
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!

Re: ZXDB based Open API

Posted: Mon Jul 02, 2018 9:53 pm
by kolbeck
website and API updated to latest ZXDB (June 26) - sorry for the delay :?

/Thomas

Re: ZXDB based Open API

Posted: Fri Sep 14, 2018 1:07 am
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.

Re: ZXDB based Open API

Posted: Fri Sep 14, 2018 7:46 am
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

Re: ZXDB based Open API

Posted: Fri Sep 14, 2018 11:18 am
by Turrican
Working.
Thank you.

Re: ZXDB based Open API

Posted: Sun Sep 23, 2018 1:02 pm
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.

Re: ZXDB based Open API

Posted: Sat Oct 06, 2018 8:19 am
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

Re: ZXDB based Open API

Posted: Fri Oct 12, 2018 11:27 pm
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

Re: ZXDB based Open API

Posted: Sun Oct 14, 2018 11:35 pm
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!

Re: ZXDB based Open API

Posted: Mon Oct 15, 2018 8:59 pm
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