How do I get all Assistance records entered after a certain date?
There are four query parameters you can use to filter Assistance records based on date:
- entry_date_gte
- entry_date_lte
- mod_date_gte
- mod_date_lte
entry_date corresponds to the date the Assistance record was first created in the system.
mod_date corresponds to the last time the Assistance record was updated or modified.
The _gte and _lte are common denotations for "greater than or equal to" and "less than or equal to".
Let’s look at an example GET request:
/api/v1/assistances?entry_date_gte=2022-01-01&entry_date_lte=2022-12-31
This would pull all Cases entered on or after January 1st, 2022 and on or before December 31st, 2022.
You could also use this filtering to also pull all records modified after a specific date, like so:
/api/v1/assistances?mod_date_gte=2024-01-01
This would pull only the Assistance records that have been modified or updated since January 1st, 2024.
You may also pull the latest Assistance records based upon a full datetime stamp, including the hour and minute. As an example, the following query:
/api/v1/assistances/?entry_date_gte=2026-06-01T14:30:00
Would pull all Assistance entered on or after June 1st, 2026 at 2:30 PM or later.
