Update with Query

Updates the content for the row matching query.

PATCH https://api.sheet2db.com/v1/{connection-id}/{sheet}?

Path Parameters

sheet string (Optional)

Specify the name of the sheet (tab) you wish to select within your Google Spreadsheet.

Query Parameters

Supports relational operators in query similar to Search

Request Body

Content type: application/json or application/x-www-form-urlencoded

The body should consist of a single object, designed for insertion into a spreadsheet. Object should contain keys corresponding to the column names of the spreadsheet.

Example Request

curl -XPATCH https://api.sheet2db.com/v1/{connection-id}?id=20 \
    -H "Content-Type:application/json" \
    -d '{"name":"Mark","age":18}'

Example Response

 
{updated:1}