In odata v4.0 is there an option for combining $expand and $select together?
I have a scenario wherein I'm trying to get specific columns in productItemChoices and item. The below query will give you all the columns in productItemChoices. I only need one column in the productItemChoices
odata/Products(08f80b45-68a9-4a9f-a516-556e69e6bd58)?$expand=productItemChoices($expand=item($select=name))
After going through a lot of time on this, I finally got the answer. We can nest select
within expand
using ;
as a separator, something like
odata/Products(8)?$expand=choices($select=col1,col2;$expand=item($select=name))
This is documented in the OData v4 $expand
documentation. The documentation also lists other useful examples such as
Categories?$expand=Products($filter=DiscontinuedDate eq null) Categories?$expand=Products/$count($search=blue)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With