SupplierInvoice lastModifiedDate

[Anonymous]

It should be possible to use the endpoint /controller/api/v1/supplierInvoice to get invoices with a lastModifiedDate, but when I'm using the suggested format it doesn't return anything even though there is an invoice between the date i set and today.

If i skip the HH:mm it goes back to returning all the supplierinvoices,

The dt im using is '2021-06-01 01:00'

/controller/api/v1/supplierInvoice?documentType=Invoice&released=1&lastModifiedDateTime=2021-06-01%2001%3A0

returns no invoices

/controller/api/v1/supplierInvoice?documentType=Invoice&released=1&lastModifiedDateTime=2021-06-01

 returns all the invoices (even invoices from last year), including one with "lastModifiedDateTime": "2021-06-21T14:42:29.02",

Am I doing something wrong, or how is this supposed to be used?

[Yıldırım · Accepted solution]

Hello Tobisas, 

LastModifiedDate parameter should always be used together with "condition".

supplierInvoice?lastModifiedDateTime=2021-06-23
&lastModifiedDateTimeCondition=>=

Here you can see supported comparative operators for LastModifiedDateTime Conditions on filtering option

>
<
<=
>=

*API Response Header Returns : GMT(+0) / UTC Offset: UTC +0
besides

*API&GUI: uses as a compliant DateTime format for both registering database and using in the system as of today it returns and write on database (GMT +1)

In addition to that DTO include ISO 8601 Standarts for DateTime or DateTimeOffset value like following structures what API-DB accept,
*"YYYY-MM-DD"
*YYYY-MM-DDT00:00:00Z

as of today Filtering Parameters does not accept certain characters such as W-Z
These are the formats for filtering
*2001-01-01
*2001-01-01 13:13:13
*2001-01-01 13:13:13.133