get
GET {{base_url}}/passthrough?url=/v4/spreadsheets/{{sheet_id}}/values/{{range}}&org_id={{org_id}}&integration_id={{integration_id}}
Learn more -
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
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 | |
ranges | string |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
api-key | string | ||
api-secret | string |
RESPONSES
status: OK
{"range":"Sheet1!A1:A10","majorDimension":"ROWS","values":[[],["asdf"],["Power Express"],["PORTER"],["Arathi electronics"],["Shell"],["PORTER"],["Jubilant Foodworks Limited"],["Altaf tata ace scrap"],["Sanjay Byalal Jagannath"]]}