A new request with request id 8324 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is :
Title : Koha-devel Digest, Vol 200, Issue 15
Category :
Description : Send Koha-devel mailing list submissions to
koha-devel@lists.koha-community.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
koha-devel-request@lists.koha-community.org
You can reach the person managing the list at
koha-devel-owner@lists.koha-community.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."
Today's Topics:
1. Re: Checkouts API Question (Stephen Graham)
2. Re: Help needed (Tomas Cohen Arazi)
----------------------------------------------------------------------
Message: 1
Date: Tue, 12 Jul 2022 15:04:52 +0000
From: Stephen Graham <s.graham4@herts.ac.uk>
To: "koha-devel@lists.koha-community.org"
<koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Checkouts API Question
Message-ID:
<LO0P265MB26204E7ACE155246ED7F49FDE7869@LO0P265MB2620.GBRP265.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset="utf-8"
Thanks Arthur for the quick reply! I had totally forgotten about the ILS-DI interface. We do have it set up on our test server – so that is defiantly an option. We have written a custom endpoint for something else previously so maybe we should explore that avenue again to achieve what we want – I prefer the Oauth2 authentication I think.
Cheers, Stephen
From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Arthur
Sent: 12 July 2022 15:15
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Checkouts API Question
Hi Stephen,
Although it's quite old, the ILS-DI interface is still available in 21.11.
You can check the GetPatronInfo with "show_loans=1" parameter (perhaps by default?) to get the loans.
Then you also get bibliographic information about those loans in one API call.
However, ILS-DI is not secure by design, there is no authentication, which means, when you activate ILS-DI it is open to everyone to get personnal information on any of your patrons by scraping with random biblionumber, just be aware of this a put decent security (we use IP restriction which is not ideal but minimum required IMO)
Best,
Arthur Suzuki
Developper @BibLibre
On 12/07/2022 16:06, Stephen Graham wrote:
Hi All – we are on 21.11, and would like to include patron account data in our bespoke University mobile app. I was planning on using the RESTful API to get the data. What we would like is simply a list of titles (plus author and ISBN) along with the due back dates. I’m struggling , when looking at https://api.koha-community.org/21.11.html<https://api.koha-community.org/21.11.html>, to see how this could be done without using lots of API calls. Would I have to do something like the following:
1. Call /checkouts to get a list of checkouts from the patron
2. Iterate over the checkout_id and call /checkouts/$id for each checkout
3. I cannot see any Biblio references in the returned data, so I’d have to then grab the biblio_id from the /items/$id endpoint and then call the /biblios endpoint to get the actual bibliographic data.
If the patron had 10 items out this would be at least 30 calls to get the bib data. Is that what I would have to do, or am I missing something – like a header or extra query which would return all the info I require from the first endpoint call?
Any advice/pointers would be much appreciated!!
Cheers, Stephen
--------------------------------------
Stephen Graham
Library Technology Consultant
Library and Computing Services
University of Hertfordshire
Hatfield, Hertfordshire, AL10 9AB
Email: s.graham4@herts.ac.uk<mailto:s.graham4@herts.ac.uk>
Website: herts.ac.uk
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org>
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel>
website : https://www.koha-community.org/<https://www.koha-community.org/>
git : https://git.koha-community.org/<https://git.koha-community.org/>
bugs : https://bugs.koha-community.org/<https://bugs.koha-community.org/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220712/4ff24f8e/attachment-0001.htm>
------------------------------
Message: 2
Date: Tue, 12 Jul 2022 12:07:20 -0300
From: Tomas Cohen Arazi <tomascohen@gmail.com>
To: Jonathan Druart <jonathan.druart@gmail.com>
Cc: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Help needed
Message-ID:
<CABZfb=XajPTqyzugScgC49Oo10-EvBY9UhfS89xMx0J2UoQOzQ@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Thanks everyone!
El mar, 12 jul 2022 a las 0:15, Tomas Cohen Arazi (<tomascohen@gmail.com>)
escribió:
> Thanks, Jonathan. Your pointer was very helpful.
>
> El lun, 11 jul 2022 6:27, Jonathan Druart <jonathan.druart@gmail.com>
> escribió:
>
>> I think the problem is that Koha::Checkouts::Renewals has 2
>> ("virtual") FKs on the same column.
>>
>> t::lib::TestBuilder::_create_links is generating an object (/values)
>> for "checkout" and $col_values->{checkout _id} has the ID from the
>> checkout we generated.
>> THEN we are processing the next relationship, old_checkout, and
>> generate another checkout, but this time we pass the checkout_id
>> previously generated. As we cannot pass an AI value, TestBuilder
>> explodes with "Value not allowed for auto_incr issue_id in Issue".
>> I guess the fix would be to use the constraint's name instead of the
>> column's name.
>>
>> Le sam. 9 juil. 2022 à 02:18, Tomas Cohen Arazi <tomascohen@gmail.com> a
>> écrit :
>> >
>> > Hi all, I've been trying to track down a problem with TestBuilder
>> tests. The are failing (almost) randomly but I narrow it down to:
>> >
>> > - Koha::Checkouts::Renewals
>> > - Koha::Biblio::ItemGroup::Items
>> >
>> > I ran out of fuel today, but it would be great if some more eyes were
>> put on this, so I can move on with pushing new stuffs with a happy test
>> suite. This is the subset of TestBuilder.t that I'm looking at (put it in
>> t/db_dependent/test.t):
>> >
>> > https://paste.koha-community.org/10864
>> >
>> > My feeling is TestBuilder->_should_be_fk is not working as it should
>> (for Koha::Checkouts::Renewals) and about Koha::Biblio::ItemGroup::Items,
>> all I can say is that the table is a linking table, pretty much like the
>> club holds one.
>> >
>> > Thanks in advance and have a great weekend!
>> >
>> > --
>> > Tomás Cohen Arazi
>> > Theke Solutions (http://theke.io)
>> > ✆ +54 9351 3513384
>> > GPG: B2F3C15F
>> > _______________________________________________
>> > Koha-devel mailing list
>> > Koha-devel@lists.koha-community.org
>> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> > website : https://www.koha-community.org/
>> > git : https://git.koha-community.org/
>> > bugs : https://bugs.koha-community.org/
>>
>
--
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220712/77aebcf7/attachment.htm>
------------------------------
Subject: Digest Footer
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
------------------------------
End of Koha-devel Digest, Vol 200, Issue 15
*******************************************
NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.