Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Queries to a Google sheet can include query parameters or parameters that are part of the path in the URL or a combination of both.  

Note for On Premise Customers

On Premise customers need to also specify the server and port where their Google Connector is hosted. The query url's below will start with  '<YourServer:Port>/google/spreadsheets/. . . '.

Queries using the Spreadsheet key

...

Warning

The column name on a Google sheet must match the control name. The matching is case-insensitive and any spaces in the column name are ignored. A control named "FirstName" matches a column header "first name." However, references to Google Sheet columns in your rule must be lower case and cannot contain spaces. The correct reference for this example is "firstname."

Control NameColumn HeaderColumn Header in Rule
FirstNamefirst namefirstname

Special Characters in Google Sheet and Worksheet Names in Rules

Google supports special characters in Google Sheet and Worksheet Names. If you are using

Frevvoproduct
 v6.1.3, and Google Connector version 2.1, your rules must pass the sheet and worksheet names as query parameters, to avoid any issues with special characters. Special characters  {}, #, + ,& are not supported in rules but they will work in the Save Submissions to a Google Spreadsheet wizard. 

...

Avoid leading/trailing spaces in spreadsheet or worksheet names when using rules to read/update Google sheets. Spaces in the Google Sheet and worksheet names should be encoded with the + (plus) sign. For example, a worksheet named Employee Information should be encoded as Employee+Information.

...