How to get all invoices by Customer DisplayID
Trying to fetch all invoices for a specific Customer
https://ar1.api.myob.com/accountright/.../Sale/Invoice?$filter=DisplayID eq '123456'
returns "The property 'DisplayID' is not an expected property"
I also cannot use Customer.DisplayID, Customer[DisplayID] or Customer{DisplayID}
What am I doing wrong?
Hi there.
Thank you for reaching out via the forum.
If looking to retrieve data from a field nestled inside an object (Customer), just use a forward slash.
example:/Sale/Invoice?$filter=Customer/DisplayID eq 'PMN017'
This support note here will help with tips for Odata filtering:
https://apisupport.myob.com/hc/en-us/articles/360000496136-OData-filter-Tips-Tricks?_ga=2.198193832.623009221.1610310389-34809390.1551044684
Let me know if this solves your issue.
Kind regards
