...
Currently, only basic SELECT, INSERT, UPDATE and DELETE queries are supported by the 'Query' mode. Shown below are few example queries.
Sample 1:
| Code Block |
|---|
SELECT customerNumber, customerName, phone, state, country FROM customers |
Sample 2:
| Code Block |
|---|
INSERT INTO customers (customerNumber, customerName, contactLastName)
VALUES(?,?,?) |
Sample 3:
| Code Block |
|---|
UPDATE customers SET contactFirstName=?, contactLastName=? WHERE customerNumber=? |
Sample 4:
| Code Block |
|---|
DELETE FROM customers WHERE customerNumber=? |
You can also create new sheets in the Excel or drop existing sheets.
Sample 5:
| Code Block |
|---|
CREATE SHEET ProductCategories (ProductCode, Category) |
...
Sample 6:
| Code Block |
|---|
DROP SHEET ProductCategories |
| Excerpt | ||
|---|---|---|
| ||
Instructions to create a data source from a Google spread sheet in WSO2 products. |
...