QuerySheet
Google Spreadsheet: Query rows in a Google worksheet.
Input
| Name | Type | Description |
| ID | String |
The ID of the worksheet that you are searching. This can be obtained from the ListWorksheets stored procedure. If you know the feed link, enter it to avoid the extra trips to the server. If left empty, the spreadsheet and worksheet names are required. |
| Name | String |
The spreadsheet name. Required if you do not specify the ID. |
| SheetName | String |
The worksheet name. Required if you do not specify the ID. The default value is sheet1. |
| Orderby | String |
Enter column name if you want results ordered by that column. By default, results are returned in the same order they appear in worksheet. The default value is position. |
| Query | String |
The query string that specifies the columns to query, the binary operators and the values. Leave it empty to get all rows. |
| Reverse | String |
If set to true, the results are sorted in descending order by row number. The default value is FALSE. |
| Start | String |
The index of the first result to return. The default value is 1. |
Output
| Name | Type | Description |
| Content | String | The contents of the row (expect the first column). |
| RowLink | String | The link for the particular row. This can be used for updating/deleting the row. |
| Title | String | The contents of the first column of the row. |
| Updated | String | Date and time the row was last updated. |