[Koha-devel] Getting "count" when using REST API

[Tomas Cohen Arazi]

I'll file a bug for that. I'm thinking we could reconsider the return value
for objects.search at this point (i.e. just return the resultset and let
the controller call ->to_api). It feels it would be more consistent too.

Nice one!

El vie, 5 ago 2022 11:42, Renvoize, Martin <martin.renvoize at ptfs-europe.com>
escribió:

> We should probably implement this as a HEAD request.. i.e. instead of
> doing a special ?_page=1&_per_page=1, we should just allow requesting the
> HEAD on whatever the request was and then you can read the X-Total-Count
> header.. in the Koha side we can handle such a request with performance in
> mind and not both fetching all the data to return etc.
>
> *Martin Renvoize, MPhys (Hons)*
>
> <https://www.ptfs-europe.com>
>
> Head of Development and Community Engagement
>
>
>
> *Phone:* +44 (0) 1483 378728
>
> *Mobile:* +44 (0) 7725 985 636
>
> *Email:* martin.renvoize at ptfs-europe.com
>
> www.ptfs-europe.com
>
>
> *Sign up for our newsletters here <http://eepurl.com/dPjjkn> or by
> scanning the QR code*
>
>
>
> Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30
>
> The information contained in this email message may be privileged,
> confidential and protected from disclosure. If you are not the intended
> recipient, any dissemination, distribution or copying is strictly
> prohibited. If you think that you have received this email message in
> error, please email the sender at info at ptfs-europe.com
>
>
> On Fri, 5 Aug 2022 at 01:31, <dcook at prosentient.com.au> wrote:
>
>> How do you mean?
>>
>>
>>
>> In my case, I’m improving how my Keycloak User Storage extension works
>> with Koha. It fetches the count of users and then sends an API request
>> using an offset and that count to handle the paging. Their internal API
>> breaks it into 2 steps, so I have to hit the database twice anyway.
>>
>>
>>
>> David Cook
>>
>> Senior Software Engineer
>>
>> Prosentient Systems
>>
>> Suite 7.03
>>
>> 6a Glen St
>>
>> Milsons Point NSW 2061
>>
>> Australia
>>
>>
>>
>> Office: 02 9212 0899
>>
>> Online: 02 8005 0595
>>
>>
>>
>> *From:* Tomas Cohen Arazi <tomascohen at gmail.com>
>> *Sent:* Friday, 5 August 2022 10:26 AM
>> *To:* David Cook <dcook at prosentient.com.au>
>> *Cc:* Jonathan Druart <jonathan.druart at gmail.com>; Koha Devel <
>> koha-devel at lists.koha-community.org>
>> *Subject:* Re: [Koha-devel] Getting "count" when using REST API
>>
>>
>>
>> That's a smart trick!
>>
>>
>>
>> We should not be lazy though, and add a generic way to retrieve the count
>> without making several DB hits.
>>
>>
>>
>> El jue, 4 ago 2022 20:56, <dcook at prosentient.com.au> escribió:
>>
>> Jonathan, you are a champion! That'll work perfectly for me!
>>
>> David Cook
>> Senior Software Engineer
>> Prosentient Systems
>> Suite 7.03
>> 6a Glen St
>> Milsons Point NSW 2061
>> Australia
>>
>> Office: 02 9212 0899
>> Online: 02 8005 0595
>>
>> -----Original Message-----
>> From: Jonathan Druart <jonathan.druart at gmail.com>
>> Sent: Thursday, 4 August 2022 10:17 PM
>> To: Tomas Cohen Arazi <tomascohen at gmail.com>
>> Cc: David Cook <dcook at prosentient.com.au>; Koha Devel <
>> koha-devel at lists.koha-community.org>
>> Subject: Re: [Koha-devel] Getting "count" when using REST API
>>
>>  I needed that for ERM and I did a GET with _page=1 and _per_page=1 (to
>> retrieve only 1 result) then read the X-Total-Count value from the header's
>> response ;)
>>
>> Le jeu. 4 août 2022 à 12:33, Tomas Cohen Arazi <tomascohen at gmail.com> a
>> écrit :
>> >
>> > Only with x-koha-embed
>> >
>> >
>> > El jue, 4 ago 2022 3:54, <dcook at prosentient.com.au> escribió:
>> >>
>> >> Hi all,
>> >>
>> >>
>> >>
>> >> Is there a method for getting a “count” using the REST API without
>> fetching every record?
>> >>
>> >>
>> >>
>> >> When building a paging lookup outside of Koha, it would be useful to
>> get a total record count and then just fetch the page of records that you
>> need.
>> >>
>> >>
>> >>
>> >> Thanks!
>> >>
>> >>
>> >>
>> >> David Cook
>> >>
>> >> Senior Software Engineer
>> >>
>> >> Prosentient Systems
>> >>
>> >> Suite 7.03
>> >>
>> >> 6a Glen St
>> >>
>> >> Milsons Point NSW 2061
>> >>
>> >> Australia
>> >>
>> >>
>> >>
>> >> Office: 02 9212 0899
>> >>
>> >> Online: 02 8005 0595
>> >>
>> >>
>> >
>> > _______________________________________________
>> > Koha-devel mailing list
>> > Koha-devel at 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/
>>
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at 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/
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220805/51f6af90/attachment-0001.htm>