MYOBCommunity
Partner Zone
|
|
Partner Zone

Filter by Dates on CategoryRegister endpoint

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
1 REPLY 1
Former Staff ShaunWilde
62 Posts
Former Staff
Australia
ShaunWilde
Former Staff

62Posts

3Kudos

22Solutions

Re: Filter by Dates on CategoryRegister endpoint

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

 

Regards

Shaun Wilde
Highlighted
Contributing Partner markportbury
14 Posts
Contributing Partner
Australia
markportbury
Contributing Partner

14Posts

0Kudos

0Solutions

Filter by Dates on CategoryRegister endpoint

Hi

 

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.

 

Mark

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post