Fetch Data From Mysql Table Using WSO2-DSS

Question

Wso2 DSS Fetch Data From Table

Please Help

I have a table named "Address". I want to fetch the all details(all coulmns) from this table using service created through wso2 dss.

I have to get the responce in json format.

I Have tried it ,but not getting the result

pls help

Answer 1

You can check the wso2dss documentation on how to create a DSS and how to return a JSON message. If you face any issue, please post the error stack.

WSO2 DSS distribution comes with default RDBMS sample. you can try that too.

Answer 2

As told by ratha, you can try the sample & understand how it is created. or else you post your table schema and anyone can post xml of that service.

For JSON reponse you need not worry much, you just need to pass one "Accept:application/json" header while calling dss service. first try to get output from dss service.