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-unsubscr...@hop.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org