Using end=2025-01-01 (without time) in API is confusing

[alinovian]

Hi there,

I'm experiencing an issue with the API for my account. The /api/v0/stats/total endpoint works correctly, but the /api/v0/stats/hits endpoint consistently fails or returns an empty array, even for dates that I can see have data in my dashboard.

My site code is: alinovian

Here are the API calls for diagnostics.

This call SUCCEEDS and returns the correct total:

curl -H "Authorization: Bearer [API_KEY]" \
    "https://[sites]/api/v0/stats/total"

This call FAILS (returns empty or error) even though my dashboard shows N/A visits for this date:

curl -H "Authorization: Bearer [API_KEY]" \
    "https://[sites]/api/v0/stats/hits?from=2025-08-24&to=2025-08-24"

It seems there might be an issue with the /stats/hits endpoint for my account. Could you please look into this?

Thank you!

[arp242]

from and to should be start and end; but I assume that's an error in writing down the example here?

If you call it with just a day without an hour as 2025-08-24 it will use zero for the hour. So the SQL query it runs will be:

where hour >= '2025-08-24 00:00:00' and hour <= '2025-08-24 00:00:00

Instead, you want to call it to the end if the day: start=2025-08-24 & end=2025-08-24T23:59:59Z. Then the query will be:

where hour >= '2025-08-24 00:00:00' and hour <= '2025-08-24 23:59:59'

And you get the expected data.

---

This is fairly obvious in hindsight, although it took me a moment to figure out as well. It would be better if 2025-08-24 would default to 2025-08-24 23:59:59 when used for end=, but that's not so easy to do in how the code is structures because we don't have access to which time format is used. Still, something that I want to look at at some point.

Alternatively, maybe clarifying the documentation might be enough.