$select Odata UIDs of all the items

Question

Hi MYOB Team,&nbsp;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:&nbsp;url = "https://api.myob.com/accountright/******/Inventory/Item/?$filter=Number eq '23-2115' &amp; $select=UID"&nbsp;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.

helenb · Answer

Hi&nbsp;GunveenSingh&nbsp;
&nbsp;
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 -&nbsp;Getting Started with OData Filtering.
&nbsp;
You might also find these articles helpful as well -&nbsp;Digging into Odata filters&nbsp;and&nbsp;Odata $filter Tips &amp; Tricks&nbsp;.
&nbsp;
If you have any questions, feel free to log a ticket with the API Support Team Here

gunveensingh · Answer

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

Forum Discussion

$select Odata UIDs of all the items

2 Replies

Looking for something else?

Related content

OData queries are not working

Odata date queries intermittent error.

Saved Items 101: 💾

Selecting Forms

User can't Receive Items

Selected Forms field missing when emailing.

Change item to Inventoried Item

Email select invoice numbers