Hi
I have gone ahead and created the node to grab data from google sheets. Set up my authentication correctly and I am able to create a new spredsheet, however when i try read a specific sheet I am getting the following error:
ERROR: The resource you are requesting could not be found.
I have researched and understand the sheet id is the last part of the url after gid=
The details of the error code are:
"name": "StatusCodeError",
"statusCode": 404,
"message": "404 - {"error":{"code":404,"message":"Requested entity was not found.","status":"NOT_FOUND"}}",
"error": {
"error": {
"code": 404,
"message": "Requested entity was not found.",
"status": "NOT_FOUND"
}
},
"options": {
"timeout": 300000,
"headers": {
"Content-Type": "application/json",
"Authorization": "Bearer ..."
},
"method": "GET",
"qs": {
"valueRenderOption": "UNFORMATTED_VALUE"
},
"uri": "https://sheets.googleapis.com/v4/spreadsheets/423432565/values/A:F",
"json": true,
"simple": true,
"resolveWithFullResponse": false,
"transform2xxOnly": false
},
"response": {
"statusCode": 404,
"body": {
"error": {...} // 3 keys
},
"headers": {
"vary": "X-Origin, Referer, Origin,Accept-Encoding",
"content-type": "application/json; charset=UTF-8",
"date": "Sat, 18 Sep 2021 18:49:30 GMT",
"server": "ESF",
"cache-control": "private",
"x-xss-protection": "0",
"x-frame-options": "SAMEORIGIN",
"x-content-type-options": "nosniff",
"alt-svc": "h3=":443"; ma=2592000,h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43"",
"accept-ranges": "none",
"connection": "close",
"transfer-encoding": "chunked"
},
"request": {
"uri": {...}, // 12 keys
"method": "GET",
"headers": {...} // 3 keys
}
}
}
Any help resolving this would be much appreciated.
Thanks,
Mike