This documentation is for WSO2 Data Services Server 3.2.0. View the home page of the latest release.

Unknown macro: {next_previous_link3}
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Introduction

One of the most often used spreadsheet format is Microsoft Excel. An Excel sheet can be used as a data source in creating data services in the WSO2 Data Services Server.

Building the sample

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, or a code-generated java client sample as discussed in the Data Services Clients section.

File and service description

The Excel file (CARBON_HOME/samples/resources/Products.xls) uses the same structure and data used in the CSV Sample which contains automobile information.

The Excel sample data service contains two operations:

  • getProducts - Lists all the products that are manufactured in the company. Each result record will contain "ID" and "Name" fields.
  • getProductClassifications - Lists all the products along with the classifications, which contain two result records named "Name" and "classification".

Sample run of the service using the TryIt tool is shown below.

  • No labels