This tutorial will guide you on how to expose data in a CSV file as a data service by using the Create New Data Service wizard. We will create a data service that can search for data on the file.
| Note |
|---|
Note that you can only read operations are supported for CSVdata from CSV files. That is, you cannot insert, update or modify WSO2 EI does not support inserting, updating or modifying data in a CSV file using WSO2 EI. |
We will use the Products.csv file that is shipped with WSO2 EI by default. The Products.csv file stored in the <EI_HOME>/samples/data-services/resources folder contains data about products (cars/motorocyles) that are manufactured in an automobile company. The data table has the following columns: "ID", "Name", "Classification" and "Price".
...
- Click Add New Operation to open the following screen.
- In the Operation Name field, enter a name for the operation.
- In the Query ID field, select the query that you created.
- Save the operation.
...