Forum Discussion

JeremyF's avatar
JeremyF
Experienced User
3 years ago

Odata date queries intermittent error.

Hi Dev Folks,

 

Is anyone haveing problems with odata date queries on the /Purchase/Order/Item end point?

 

$filterArray = array('$filter' => "Date gt datetime''2021-01-01T00:00:00Z'");

 

Is throwing up this intermittently. 

An exception was thrown that was not handled correctly. If this situation persists please contact developers@myob.com for further assistance.

 

OData
  • JeremyF's avatar
    JeremyF
    Experienced User
    3 years ago

    Hi an Update for any one interested

     

    The odata queries are really finicky

     

    By adding a second term 'Status eq 'Open' and Date gt datetime'2022-01-01'

     

    The query works and no errors are generated.

     

    NOTE: This appears to only be an issue with /Purchase/Order/Item on large company files with thousands of orders. 

    Weird!

     

     

     

     

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.