OData Query Columns

primeap

Hello

I am wondering if it is possible with NAV2013 Odata to limiting the columns returned.

Like in CRM (h[url]ttp://msdn.microsoft.com/en-us/library/gg309461.aspx[/url])

For example, the query /AccountSet?$select=Name,opportunity_customer_accounts&$expand=opportunity_customer_accounts returns only the account name and the expanded opportunity records.


I know we can use Filters (http://msdn.microsoft.com/en-us/library/hh169248(v=nav.70).aspx)
but how to select specific columns?

Best Regards

Thank you for any feedback.

primeap

Well dont know why I did not realize it earlier. but you CAN already do that..

http://localhost:7048/DynamicsNAV70/Oda ... ct=No,Name



so just add a ?$select=
after the entity
and then the fields

thegunzo

Hi

I would suggest creating a new page with only the columns that are required and publishing that page.

primeap

This would be my alternative.. but in some cases it would be more efficient to just have the page created and published once..


Really no chance to get this done in NAV?

primeap

Well dont know why I did not realize it earlier. but you CAN already do that..

http://localhost:7048/DynamicsNAV70/Oda ... ct=No,Name



so just add a ?$select=
after the entity
and then the fields