...
2. The "Create Data Service" page appears. Fill in the fields and click "Next." The Data Service name is mandatory.
| Info |
|---|
For more information on Advanced Configurations in creating data servicesadvanced configurations, refer to section Transaction Handling Advanced Data Service Configurations. |
3. The "Data Sources" page appears. Click on the " Add New Data Source" link and add your Data Source details.
...
Grouped by element : Products
Row name : Product
Row namespace : http://ws.wso2.org/dataservice/sample
Click on "Add Output Mapping" button to define how the output looks like. We have created ID as an element and "Name" and "Classification" as attributes.
For information on adding validations to your input mappings in the query, if any, refer to section Input Validators . 
Also, detailed information on writing queries can be found in section Data Service Queries.
6. Once a new query is added, it will be listed as follows:
...
Click "Save" once done. For example,
8. The operation will be listed in the "operations" page. You can edit or delete your operation.
...
9. The Data Service configuration is done. Click "Finish" . ( You can also continue to add resources by clicking the "Next" button).
10. Once the "Finish" button is clicked, you will be navigated to the "Deployed Services" page where the newly added data service is listed .
From here, you can manage your data service. For instructions, refer to section Service Management.
For a demonstration of service-enabling an Excel sheets, refer to page Excel Sample .
Excel Data Sources in Query Mode Anchor Q Q
| Q | |
| Q |
...
2. The "Create Data Service" page appears. Fill in the fields and click "Next." The Data Service name is mandatory.
| Info |
|---|
For more information on Advanced Configurations in creating data servicesadvanced configurations, refer to section Transaction Handling Advanced Data Service Configurations. |
3. The "Data Sources" page appears. Click on the " Add New Data Source" link and add your Data Source details. The data source type should be EXCEL and select the "Use Query Mode" option. For example,
...
6. Enter the query and click "Generate Input Mappings" to auto generate the input mapping parameters. For example,
7. Once a new query is added, click "Next".
8. The "Operations" page appear s. Add the operation details. In the following example, operation name is "insertProducts". Select the created query from the drop down list and click on "Add Query Params as Operation Params" to add the parameters to operation. Click "Save" once done.
9. The operation will be listed in the "operations" page. You can edit or delete your operation.
...
From there, you can manage your data service. For instructions, refer to section Service Management.
For a demonstration of service-enabling an Excel sheets, refer to page Excel Sample .
Queries Supported in the 'Query' Mode Anchor sup sup
| sup | |
| sup |
Currently, only basic SELECT, INSERT, UPDATE and DELETE queries are supported by the 'Query' mode. Shown below are few example queries.
...