Getting partial responses through WSO2 DSS

Question

I have setup WSO2 DSS 3.1.1 and have connected with an Oracle database. The service is setup well and working fine. Now what I want to try out is to see whether I can get the service to send partial json responses i.e. I can specify as a parameter in the service request what are the columns on the response I want and the service would return me those columns.

e.g. If i request for columns a,b,c then then the service would return me a,b,c columns and if I request for d,e,f columns it would send me only those columns.

1. Is this possible using WSO2 DSS or even ESB?
2. If yes how can it be established?

Thanks in advance.

Answer 1

You can try number of approaches.

1. Have two different data services for both cases and at ESB, route the request to correct service. That is, based on request call relavat dataservice.
2. You can filter out your return results based on the roles.
3. You can do change at dataservice. That is, define a stored procedure, where identify the input parameters and based on that return specific columns.