You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "bamaer (via GitHub)" <gi...@apache.org> on 2023/09/24 07:04:30 UTC
[I] [Bug]: Google Sheets Output - variables are resolved but don't work (hop)
bamaer opened a new issue, #3252:
URL: https://github.com/apache/hop/issues/3252
### Apache Hop version?
SNAPSHOT-20230923
### Java version?
11.0.20.1
### Operating system
Linux
### What happened?
Google Sheets Output - variables are resolved but don't work
```
2023/09/24 09:02:11 - Google Sheet Output.0 - Spreadsheet:19ZLPp5eJQM1G2Vq71MMEzKAuDndc0sMBHfujx_41lrI exists
2023/09/24 09:02:11 - Google Sheet Output.0 - ERROR: Error: for worksheet : hop-test-sheet-5 in spreadsheet :19ZLPp5eJQM1G2Vq71MMEzKAuDndc0sMBHfujx_41lrI404 Not Found
2023/09/24 09:02:11 - Google Sheet Output.0 - GET https://sheets.googleapis.com/v4/spreadsheets/$%7BPRM_SPREADSHEET%7D
2023/09/24 09:02:11 - Google Sheet Output.0 - {
2023/09/24 09:02:11 - Google Sheet Output.0 - "code" : 404,
2023/09/24 09:02:11 - Google Sheet Output.0 - "errors" : [ {
2023/09/24 09:02:11 - Google Sheet Output.0 - "domain" : "global",
2023/09/24 09:02:11 - Google Sheet Output.0 - "message" : "Requested entity was not found.",
2023/09/24 09:02:11 - Google Sheet Output.0 - "reason" : "notFound"
2023/09/24 09:02:11 - Google Sheet Output.0 - } ],
2023/09/24 09:02:11 - Google Sheet Output.0 - "message" : "Requested entity was not found.",
2023/09/24 09:02:11 - Google Sheet Output.0 - "status" : "NOT_FOUND"
2023/09/24 09:02:11 - Google Sheet Output.0 - }
2023/09/24 09:02:11 - Google Sheet Output.0 - ERROR: com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 Not Found
2023/09/24 09:02:11 - Google Sheet Output.0 - GET https://sheets.googleapis.com/v4/spreadsheets/$%7BPRM_SPREADSHEET%7D
2023/09/24 09:02:11 - Google Sheet Output.0 - {
2023/09/24 09:02:11 - Google Sheet Output.0 - "code" : 404,
2023/09/24 09:02:11 - Google Sheet Output.0 - "errors" : [ {
2023/09/24 09:02:11 - Google Sheet Output.0 - "domain" : "global",
2023/09/24 09:02:11 - Google Sheet Output.0 - "message" : "Requested entity was not found.",
2023/09/24 09:02:11 - Google Sheet Output.0 - "reason" : "notFound"
2023/09/24 09:02:11 - Google Sheet Output.0 - } ],
2023/09/24 09:02:11 - Google Sheet Output.0 - "message" : "Requested entity was not found.",
2023/09/24 09:02:11 - Google Sheet Output.0 - "status" : "NOT_FOUND"
2023/09/24 09:02:11 - Google Sheet Output.0 - }
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$3.interceptResponse(AbstractGoogleClientRequest.java:466)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:552)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:493)
2023/09/24 09:02:11 - Google Sheet Output.0 - at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:603)
2023/09/24 09:02:11 - Google Sheet Output.0 - at org.apache.hop.pipeline.transforms.googlesheets.GoogleSheetsOutput.init(GoogleSheetsOutput.java:130)
2023/09/24 09:02:11 - Google Sheet Output.0 - at org.apache.hop.pipeline.transform.TransformInitThread.run(TransformInitThread.java:66)
2023/09/24 09:02:11 - Google Sheet Output.0 - at java.base/java.lang.Thread.run(Thread.java:829)
2023/09/24 09:02:11 - Google Sheet Output.0 - ERROR: Error initializing transform [Google Sheet Output]
```
### Issue Priority
Priority: 2
### Issue Component
Component: Transforms
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Google Sheets Output - variables are resolved but don't work (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer closed issue #3252: [Bug]: Google Sheets Output - variables are resolved but don't work
URL: https://github.com/apache/hop/issues/3252
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org