Bug 41182

Summary: Sushi harvest should send a full date
Product: Koha Reporter: Nick Clemens (kidclamp) <nick>
Component: ERMAssignee: Jonathan Druart <jonathan.druart>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, jonathan.field, martin.renvoize, matt.blenkinsop, pedro.amorim
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 41182: Pass 10 digit date to SUSHI

Description Nick Clemens (kidclamp) 2025-11-04 17:57:58 UTC
A library attempting to get counter reports from Proquest found they were failing.

In testing, I was able to narrow the problem down to the date range.

We send:
https://sushi.proquest.com/counter/r5/reports/pr?begin_date=2024-11&end_date=2025-10&customer_id={ID}&api_key={KEY}

They expect:
https://sushi.proquest.com/counter/r5/reports/pr?begin_date=2024-11-01&end_date=2025-10-31&customer_id={ID}&api_key={KEY}

From what I can tell in the standard:
https://www.niso.org/sites/default/files/schema-files/sushi1_7_ReportRequest.png
Date is expected as yyyy-mm-dd

We should send the full date and not truncate
Comment 1 Nick Clemens (kidclamp) 2025-11-04 18:02:05 UTC
Created attachment 189044 [details] [review]
Bug 41182: Pass 10 digit date to SUSHI