Published Odata service: will expand with select be supported?
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?
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