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 and insert data into the file.
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.
...