Forum Discussion

sajju-thambi's avatar
sajju-thambi
Member
2 years ago
Solved

MYOB API Filtering using Custom List

Hi,   Does API supports filtering using a custom list? I need to get all suppliers that have a specific Custom List 1 value. Is this possible? If yes how to provide the filter?   Any help and sug...
  • JeremyF's avatar
    JeremyF
    2 years ago

    Sajju

     

    You might need to try changing your odata query to Customlist1/Label eq '<your value>'

    or Customlist1 /Value eq '<your value>'

     

    Depending on which one you want

     

    cheers

    JF

sajju-thambi's avatar
sajju-thambi
Member
2 years ago

Hi Mike,

Many thanks for your response. I tried what you suggested. But API returns Validation Error. Please see below the error message received.

<Please check your OData query: A binary operator with incompatible types was detected. Found operand types 'MYOB.AccountRight.API.Version2.Contracts.Identifier' and 'Edm.String' for operator kind 'Equal'.>

 

Cannot make out what this error is. Could you kindly guide me where I went wrong?

 

Thanks

Sajju

JeremyF's avatar
JeremyF
Trusted User
2 years ago

Sajju

 

You might need to try changing your odata query to Customlist1/Label eq '<your value>'

or Customlist1 /Value eq '<your value>'

 

Depending on which one you want

 

cheers

JF

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    Hi JeremyF , thanks for correcting my inaccurate effort!

  • sajju-thambi's avatar
    sajju-thambi
    Member
    2 years ago

    Thanks a lot JF. It worked.

     

    Cheers

    Sajju

Looking for something else?

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

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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