update
PUT {{base_url}}/passthrough?url=/v4/spreadsheets/{{sheet_id}}/values/{{range}}&org_id={{org_id}}&integration_id={{integration_id}}&valueInputOption=USER_ENTERED&includeValuesInResponse=true
Learn more -
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
url | string | (Required) - YNAB API url. | |
org_id | string | (Required) - Cashflowy org id | |
integration_id | string | (Required) - Cashflowy integtration id | |
valueInputOption | string | ||
includeValuesInResponse | boolean |
Request Body
{"majorDimension"=>"ROWS", "values"=>[["alex", "alex2"]]}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
api-key | string | ||
api-secret | string |
RESPONSES
status: OK
{"spreadsheetId":"13WxwyH7z8ndfdpPvlcLZqefJrtmZ4cdC31VaiscljNU","updatedRange":"Sheet1!K1:L1","updatedRows":1,"updatedColumns":2,"updatedCells":2,"updatedData":{"range":"Sheet1!K1:N1","majorDimension":"ROWS","values":[["alex","alex2","Monday","Nasty"]]}}