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

  • 1
  • Question
  • Updated 2 months ago
  • Answered
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
Photo of Stream Lending

Stream Lending

  • 110 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
Photo of Simon Hutchinson

Simon Hutchinson, Employee

  • 2,392 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

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