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

**URL:** <https://connective.celigo.com/t/troubleshooting-the-google-sheets-api-clear-method-prompts-for-a-required-value/1225>\
**Category:** Integrator.io\
**Tags:** http, google-sheets, error-handling, netsuite\
**Created:** [January 22, 2021, 5:26pm UTC](https://connective.celigo.com/t/troubleshooting-the-google-sheets-api-clear-method-prompts-for-a-required-value/1225 "2021-01-22T17:26:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomsantiago](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tomsantiago/32/7158_2.png) [@tomsantiago](https://connective.celigo.com/u/tomsantiago)\
**Post date:** [January 22, 2021, 5:26pm UTC](https://connective.celigo.com/t/troubleshooting-the-google-sheets-api-clear-method-prompts-for-a-required-value/1225/1 "2021-01-22T17:26:52Z")

</div>

When using integrator.io with the [Google Sheets API clear method](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/clear) 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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/d9cf2824bb8d8d29af42e251008e3dad09355f99.png)

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.](https://connective.celigo.com/t/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/1234)

​