Reckon one API: get invoices by a range of due date

Stream Lending · July 2018

Hi,
I'm new to the reckon one API
For now, we want to get a list of invoices by the due date
e.g. DueDate ge '2017-07-01' && DueDate le '2017-07-01'
I can see that the api is using OData format with $filter
But there is no document about the filter of datetime

Is it possible to filter the invoice api by datetime? If so, any example?

Thx

Simon Hutchinson_8164484 · July 2018

Hi there,

The best idea for this is to use the greater than or less than (depending on what you want) part of odata with a filter

as a sample for Reckon One this should be

https://api.reckon.com/r1/{cashbookid}/invoices?$filter=DueDate gt '2015-04-04T00:00:00+00:00'
Which would give you the invoices greater than 04/04/2015 midnight
Order is YYYY-MM-DD

Reckon one API: get invoices by a range of due date

Comments

Categories