Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When using data services, the user may come across the need XSLT transformation is used in WSO2 DSS to transform the result as they wish. This is handled in WSO2 Data Services Server using XSLT Transformation, where the result of an already defined operation into a different result. The user can define the transformation in xslt and provide the url of the transformation file in the result element.

Table of Contents
maxLevel3
minLevel3

About the sample

...

The Excel sample data service contains (ExcelSampleService), which we use for this demonstration consists of two operations "getProducts" to list :

  • getProducts - Lists all the products that are manufactured in the company

...

  • . Each record in the result contains "ID" and "Name" fields.

...

  •  
  • getProductClassifications - Lists all the products along with the classifications

...

  • . The result will consist of two records, "Name" and "classification".

...

  • However, note that because of the xslt transformation, the actual output of this operation has changed to "product-Name" and "product-classification"

...

See Data Services and Resources for a definition of data services and operations.

Building the sample

The sample data service named ExcelSampleService should be deployed using the instructions in Samples Setupsection.

Running the sample

The sample service can be run using the TryIt tool, which is bundled with the WSO2 Data Services Server, or a code-generated java client sample as discussed in the Data Services Clients section.

...

  1. Log in to the management console of your server and click List under Services in the navigator. The ExcelSampleService will be listed here.
  2. Click Try this service to open the TryIt tool.
  3. Select the relevant "getProductClassifications" operation and click Send to execute the command. You will get the product list in the response as shown below.