TROUBLESHOOTING: The Google Sheets API "clear" method prompts for a required value

Integrator.io
, , ,
1

When using integrator.io with the Google Sheets API clear method to clear data before each flow run, you might receive a warning that you must provide a required Build HTTP request body value. If ignored, the following error returns:

"{\n \"error\": {\n \"code\": 400,\n \"message\": \"Invalid JSON payload received. Unknown name \\\"connection\\\": Cannot find field.\\nInvalid JSON payload received. Unknown name \\\"export\\\": Cannot find field.\\nInvalid JSON payload received. Unknown name \\\"data\\\": Cannot find field.\\nInvalid JSON payload received. Unknown name \\\"exportStartTime\\\": Cannot find field.\\nInvalid JSON payload received. Unknown name \\\"settings\\\": Cannot find field.\\nInvalid JSON payload..."

If you are replacing specific values, you can make the call via the Relative URI field:

​​

5301043caa20740200000001-c88edf0ff028411eab3e2c4ed4edba83.png
5301043caa20740200000001-c88edf0ff028411eab3e2c4ed4edba83.png399×412 14.6 KB

For example:

v4/spreadsheets/1.../values/Sheet1!A1:O20000:clear

If it's the HTTP request body that's causing problems, you can add an empty object by typing "{}" in the request body (and nothing else).

See the following related community post for more information on using the clear method:

Troubleshooting: When sending data from a NetSuite saved search to Google Sheets, the import performs a sheets delete method and then a sheets write method for each line of the saved search.

​