...
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:
- 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. - Click Try this service to open the TryIt tool.
- Select the "getProducts" operation and click Send to execute the request. You will get a product list in the response as shown below.