Versions Compared

Key

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

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 using the deprecated '&updates' parameter, 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. To correct this, please update your business rule to use the '&updatesjson' parameter as described in this documentation.

Alternatively, you may 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...

...