Page 1 of 1

Can I limit the REST response to include only certain columns, rather than all columns?

Posted: Sat Dec 21, 2013 7:25 pm
by Bahar Wadia

I am trying to improve the performance of my app by limiting the amount of data that is being transmitted between the app and the REST database.

So I want to limit the number of columns of data that are being returned. What is the best way of doing this?

Thanks


Can I limit the REST response to include only certain columns, rather than all columns?

Posted: Sat Dec 21, 2013 7:36 pm
by Igor

Hello,

You can remove nor used columns from response tab.


Can I limit the REST response to include only certain columns, rather than all columns?

Posted: Sat Dec 21, 2013 10:43 pm
by Bahar Wadia

That worked.

I also have pointers in the collection. How do I limit the columns that I receive through the pointers.

Thanks


Can I limit the REST response to include only certain columns, rather than all columns?

Posted: Sat Dec 21, 2013 11:10 pm
by Bahar Wadia

That does not work


Can I limit the REST response to include only certain columns, rather than all columns?

Posted: Sun Dec 22, 2013 12:02 am
by maxkatz

You can remove response parameters from the response as Igor suggested but the entire JSON response will still be sent to the client. An alternative is to invoke the service in Server Code and there return only the data/columns that you need.