How to filter between dates using Rest API

PHPMaker General Discussion (PHPMaker)
1

Hi is possible to filter by an value using restapi?example of all records from api call on Table1 usinge GET https://mywebsite.com/api/list/Table1"success": true,
“prod_per_MIS”: [
{
“InsertDate”: “2021-01-01”,
“user”: “User1”,
“TotHours”: 8
},
{
“InsertDate”: “2021-01-02”,
“user”: “User1”,
“TotHours”: 5
},
{
“InsertDate”: “2021-01-03”,
“user”: “User2”,
“TotHours”: 3
}
]Is possible to filter by InsertDate between “2021-01-01” - “2021-01-02” ?

If yes what query params should I use?

2

If the field is enabled for Advanced or Extended Search, you can pass search criteria like the List page.

3

Can you please help… after activating BETWEEN on search.How do you call the api url for BETWEEN?example pseudo-code:

?date_time>2023-09-02 10:00&date_time<2023-09-02 14:00
4
  1. Your query string syntax is invalid, you may google “query string” for more info.
  2. You may search in the List page and see the query string in the browser’s address bar.
  3. You may also try, e.g. ?date_time=BETWEEN| where and are URL-encoded values. (v2023+ only.)