How to get all invoices by Customer DisplayID

Question

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?

Tana · Accepted Answer

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