How to get all invoices by Customer DisplayID

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Seedsy
1 Post
User

1Posts

0Kudos

0Solutions

Solved: Go to Solution

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?

1 REPLY 1
Tana
MYOB Moderator
43 Posts
MYOB Moderator
MYOB Moderator

43Posts

92Kudos

3Solutions

Accepted Solution Solved

Re: How to get all invoices by Customer DisplayID

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....

Let me know if this solves your issue. 
Kind regards


Thanks,
@Tana


MYOB API Specialist


MYOB API Support Centre|MYOB App Marketplace|MYOB AccountRight API Endpoint Doc's



Did my answer help?


Mark it as a Solution

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post