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
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: 6852
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
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: Sun Oct 14, 2018 11:35 pm ...
Hi Thomas.
I´m using 2:
1-) /v2/search for General List
2-) /v2/magazines/{magazine-name}/issues for Magazine Search.

Regards!
OK - 2) is not a search function, but more a lookup. The idea back then was to use the list of magazines e.g. https://api.zxinfo.dk/api/zxinfo/v2/mag ... 0&offset=0 - and then use the name from here to do a specific lookup.

That said, I like the idea of a magazine oriented search, if you have any input let me know :-)

/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 Nov 21, 2018 11:01 am
Turrican wrote: Sun Oct 14, 2018 11:35 pm ...
Hi Thomas.
I´m using 2:
1-) /v2/search for General List
2-) /v2/magazines/{magazine-name}/issues for Magazine Search.

Regards!
OK - 2) is not a search function, but more a lookup. The idea back then was to use the list of magazines e.g. https://api.zxinfo.dk/api/zxinfo/v2/mag ... 0&offset=0 - and then use the name from here to do a specific lookup.

That said, I like the idea of a magazine oriented search, if you have any input let me know :-)

/Thomas
Oh! I´m using it directly with the input from user. That´s why it´s working as case sensitive so. :)
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'm working on a new "Magazine Search" function, will let you know when it's ready :-)

/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
PeterJ
Site Admin
Posts: 6852
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: ZXDB based Open API

Post by PeterJ »

Has anyone used the API with Python? I'm struggling.
User avatar
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

PeterJ wrote: Fri Nov 30, 2018 4:39 pm Has anyone used the API with Python? I'm struggling.
Have you tried postman? It can generate python code snippets.

/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
kolbeck
Manic Miner
Posts: 309
Joined: Mon Nov 13, 2017 9:04 pm

Re: ZXDB based Open API

Post by kolbeck »

[mention]Turrican[/mention] - I've added a /magazine/search method to the API, please try it out - https://api.zxinfo.dk/doc/

/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: Sat Dec 01, 2018 11:31 pm @Turrican - I've added a /magazine/search method to the API, please try it out - https://api.zxinfo.dk/doc/

/Thomas
Ok. 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 »

kolbeck wrote: Sat Dec 01, 2018 11:31 pm @Turrican - I've added a /magazine/search method to the API, please try it out - https://api.zxinfo.dk/doc/

/Thomas
Hi Thomas.
I´m using the magazine search in a different way.
This new method shows all magazines (only one line, with basic info) with all words that I input, right?
The app lists all magazines issues with the same name in the input field. :)

So in the new method if I input "your sinclair" it shows "Your Sinclair", "Sinclair User", "Your Spectrum", etc...
How my search works:
When I input "Your Sinclair" it shows all Your Sinclair issues with cover images. The problem here is that it is case sensitive.
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 »

ahh.. ok - in general REST URLs are case sensitive. The idea was that a client, in this case your app, used the magazine list or the new search to find the exact magazine name - but in this case I think an exception could be made.

The following should now work and return the same result:
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/

/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: Tue Dec 04, 2018 8:25 pm ahh.. ok - in general REST URLs are case sensitive. The idea was that a client, in this case your app, used the magazine list or the new search to find the exact magazine name - but in this case I think an exception could be made.

The following should now work and return the same result:
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/
https://api.zxinfo.dk/api/zxinfo/v2/mag ... ir/issues/

/Thomas

Danke!
Locked