...
Google data sources can be created in two different modes as follows:
- Google Data Sources in Non-Query Mode : The 'Non-Query' mode allows to simply expose the content of a Google spreadsheet as a service.
- Google Data Sources in Query Mode : The 'Query Mode' allows users to query a Google spreadsheet in a familiar, SQL-like manner, and expose it as a service.
...
Google Data Sources in Non-Query Mode Anchor NonQ NonQ
| NonQ | |
| NonQ |
...
From here, you can manage your data service. For instructions, refer to section Service Management. For a demonstration on the usage of Google Spreadsheets as a data source, refer to Google Spreadsheet Sample.
Google Data Sources in Query Mode Anchor Q Q
| Q | |
| Q |
In the query mode, users can query a Google Spreadsheet in a much familiar SQL-like manner. To implement the query mode, internally the "org.wso2.carbon.dataservices.sql.driver.TDriver" class is used as the SQL Driver. It is a JDBC driver implementation to be used with tabular data models such as Google SpreadSheets, Excel sheets etc.