Api call on daily basis product information

Using my Dolibarr
,
1

Hello,

Does any one have an idea on how to change this to a recall daily?

products?limit=%limit%&page=%pageNo%&sqlfilters=(

t.tms%3Alike%3A’%252023-07-29%25’

)&pagination

i got the advice to use the below but that doesn’t work unfortiantly

t.tms BETWEEN CONCAT(DATE_SUB(CURDATE(), INTERVAL 1 DAY), " 00:00:00") AND CONCAT(CURDATE()," 23:59:59")

Hope someone is able to help, as you can see i have to daily change the

%252023-07-29%

2

Hi @PimDolie,

what kind of database are you using? Mysql or Postgres?

Regards,
Sven

3

Hi,

It’s MariaDB 10.6.12, php version 8.1.21 with a innoDB dataset.

4

Hi @PimDolie,

I tried the following query in maria db and it works fine:

SELECT * FROM llx_product WHERE DATE(tms) = CURDATE();

This means you now just need to adapt the t.tms part accordingly.

Regards,
Sven