Versions Compared

Key

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

...

Using CSV files is an easy and common way of storing simple tabular data. This sample demonstrates the usage of a CSV file as a data source datasource for data services in WSO2 Enterprise Integrator (WSO2 EI).

...

The CSV file (Products.csv), stored in the <EI_HOME>/samples/data-services/resources/ folder, contains data about the products that are manufactured in an automobile company. Products refer to cars/motorocyles. The data table has the following columns: "ID", "Name", "Classification" and "Price". The sample data service used in this demonstration (CSVSampleService.dbs) contains a single operation named getProducts , which lists all the products that are manufactured in by the company.

See Data integration for a definition of data services and operations.

...

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

Follow the steps below to demonstrate test this functionality using the TryIt tool:

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