Question

Published Odata service: will expand with select be supported?

2

Hi, we are currently using ODatav4 to server data to the BI solution. It works, but we miss expanding with select (ex: …/orders?$expand=Products($select=ID)) to better handle the queries an lessen the load on our app. Because we can’t expand with select, all related tables are queried in full, resulting in a lot of needless data being served. That quickly can scale to hundreds of wasted MB. Is there any plan to implement this query option?

asked 2022-07-21

Luiz Rocha

2 answers

Krishnaraj · Answer 1 · 2022-07-22

You can select the attributes from the entity exposed in the OData services. You have the option to add and delete the attributes to be exposed in the OData service. Refer to the below image to add and remove the attributes

Add pagination to the services

Ryan Saunderson · Answer 2 · 2023-11-06

We've run into this as well as we work on refactoring our infrastructure apps into separate applications. The lack of support for expand with select on both ends of the pipe leads to far more queries being submitted than should be necessary.