Update Row

Updates the content for the specified row.

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

Path Parameters

row number (Required)

Specify the index of the row you want to update. (Index is counted excluding the header row)

Query Parameters

sheet string (Optional)

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

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}/row/3 \
    -H "Content-Type:application/json" \
    -d '{"name":"Mark","age":18,"id":10}'

Example Response

 
{updated:1}