On this page:
Table of Contents
...
This may be because you are using an invalid or revoked access token in your business rule. Make sure you are using a valid access token and retest.
This error can also occur if you are writing to a Google Sheet using a business rule, and you have a text or textarea control that gets a value with a comma at runtime. For example, if you are passing a control in the var updateparams rule such as "FullName" and the runtime value entered is "Smith, John" the comma can interfere with the comma-separated update parameters being passed to the Google Sheet. This will be fixed in a future release. A workaround is to add code to your rule to strip the commas:
Code Block |
---|
//Remove Commas
var t = FullName.value;
var tcomma = t.replace(/,/g," "); |
Then, pass the variable "tcomma" in the updataparams rule instead of the original control value.
Invalid String Literal
If you see the error "invalid string literal" when using a business rule to read or update a google sheet, make sure that you have commented out the slashes in your oAuth Code, as in OAuth21\/\/0dqqBnY...
...