Batch Update

Update using multiple queries.

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

Path 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

Must be an array with objects containing query & record.

query: We will use this query to find all the rows that needs to be updated.

record: Designed for insertion into a spreadsheet. record should contain keys corresponding to the column names of the spreadsheet.

Example Request

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

Example Response

 
{updated:1}