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 only read operations are supported for CSV. That is, you cannot insert, update or modify 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.
...