$select Odata UIDs of all the items

Question

Hi MYOB Team,

I want to fetch just the UIDs of all the items in the company file.

I tried using oData's $select query option as in the snippet below:

url = "https://api.myob.com/accountright/******/Inventory/Item/?$filter=Number eq '23-2115' & $select=UID"

the $filter part is working fine but the $select won't work. I saw an old post with a question on $select not being supported by MYOB AccountRight. Please suggest a correction/workaround for this.

GunveenSingh · Answer

Thanks @HelenB . I ended up building a pipeline in python to get the desired data.

HelenB · Answer

Hi @GunveenSingh

Thanks for reaching out. When using Odata filters with our API's only certain ones are supported. To find out which ones are supported, check out our help article here - Getting Started with OData Filtering.

You might also find these articles helpful as well - Digging into Odata filters and Odata $filter Tips & Tricks .

If you have any questions, feel free to log a ticket with the API Support Team Here