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

  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?

Photo of Stream Lending

Stream Lending

  • 110 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Simon Hutchinson

Simon Hutchinson, Employee

  • 2,502 Points 2k badge 2x thumb
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{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