Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
2 weeks ago
2 weeks ago
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 suggestions will be highly appreciated.
Thanks
Sajju
Solved! Go to Solution.
2 weeks ago
2 weeks ago
Hi @sajju-thambi,
Welcome to the Community Forum.
I believe forum users that have experience with this will be able to respond to your query. Additionally, you can reach out to the integration team via this link.
In the meantime, feel free to create a new thread if you require any other assistance.
Thanks,
Genreve
2 weeks ago
2 weeks ago
Hi @sajju-thambi , this is documented at MYOBapi Developer Centre, in particular:
The $filter query can be added to the endpoint request:
.../?$filter=Customlist1 eq '<your value>'
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
2 weeks ago
2 weeks 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
2 weeks ago
2 weeks 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
2 weeks ago
2 weeks ago
Thanks a lot JF. It worked.
Cheers
Sajju
2 weeks ago
2 weeks ago
Hi @JeremyF , thanks for correcting my inaccurate effort!
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
by
jen3
3 weeks ago
2
130
|
2
|
130
|
||
by
BareBeauty
3 weeks ago
8
215
|
8
|
215
|
||
by
AL6
a month ago
0
147
|
0
|
147
|
||
41
|
3336
|
|||
14
|
589
|