cancel
Showing results for 
Search instead for 
Did you mean: 
My Areas

Sign in or create account

to get a personalized navigation.

TobiasJ
CONTRIBUTOR **

SupplierInvoice lastModifiedDate

by TobiasJ

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?

1 REPLY 1
Accepted solution
Yildirim
VISMA

by Yildirim (Updated ‎23-06-2021 12:47 by Yildirim VISMA )

Hello Tobisas, 

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

 

 

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