Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
CategoryRegister does not, as you have found, have a single Date field for you to query on. I'll request to add this field but I can't say when it would get fulfilled.
For now you can either fetch all the data and then filter locally or fetch a window of data e.g. 2014, 2015 and then remove the unwanted months locally.
$filter=Year eq 2014 or Year eq 2015
I am trying to retrieve data on the CategoryRegister endpoint for a twelve month period. This endpoint has discrete Month and Year attributes, rather than a single date attribute, so I'm not sure how to filter for a date range. For example, the following won't work that I found on the API Tumblr site:
Date ge datetime'2014-07-01'
At the moment the only way I am able to pull data for the CategoryRegister endpoint is to pull data for each individual month then sum the values, which means 12 API lookups instead of one.
Is there a way to specify a date range filter on this endpoint?
Thank you for your help in advance.