Forum Discussion

Seedsy's avatar
Seedsy
Member
5 years ago
Solved

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...
Tana's avatar
Tana
MYOB Staff
5 years ago

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

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.