Forum Discussion

KevinBiehl's avatar
5 years ago

MYOB Advanced API - unable to run the following query "$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"

"$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"

 

what should be right datetime format?

 

"message": "An error has occurred.",
"exceptionMessage": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThanOrEqual'.",

 as error message.

  • For anyone else having this issue this is the valid way to filter by date

     

    ShipmentDate gt datetimeoffset'2020-07-27T00:00:00Z'


    KevinBiehl wrote:

    "$filter": "LastModifiedDateTime ge '2020-10-10T11:00:00'"

     

    what should be right datetime format?

     

    "message": "An error has occurred.",
    "exceptionMessage": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThanOrEqual'.",

     as error message.


     

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.