When using data services, the user may come across the need to transform the result as they wish. This is handled in WSO2 Data Services Server using XSLT Transformation, where the user can define the transformation in xslt and provide the url of the transformation file in the result element.
Deploying and Running the Sample
To build the sample you need Apache Ant build tool.
1. Stop the currently running Data Services Server instance if any. This is recommended in order to clean the current sample database and redeploy the services.
2. Remove the current sample database and existing sample data services.
# cd CARBON_HOME/samples
# ant clean
3. In a command prompt, switch to the sample directory: <CARBON_HOME>/samples. From there, type ant to deploy all samples.
# ant
4. Start The sample data service ExcelSampleService should be deployed using the instructions in Deploying Data Services section.
Running the Sample
The sample service can be run using the TryIt tool, which is bundled with the WSO2 Data Services Server. For instructions, refer to Installing and Starting DSS.
5. Login to the Data Services Server Management Console. You now have the sample data service deployed on the Server. If you go to the Deployed Services window in the Data Services Serve Management Console, you should be able to see it.
The sample services can be run using the Tryit tool., or a code-generated java client sample as discussed in the Data Services Clients section.
Service Description
The Excel sample data service contains two operations "getProducts" to list all the products that are manufactured in the company, each result record will contain "ID" and "Name" fields. And "getProductClassifications" where to list all the products along with the classifications, which contains two result records which are "Name" and "classification".
Second operation's ("getProductClassifications") actual output has changed as "product-Name" and "product-classification" by using the xslt transformation.
Sample Run
Sample run of the service using the TryIt tool is shown below.
