node-red-contrib-viseo-google-spreadsheet : Problem installing #85

Christian-Me · 2018-04-05T06:49:53Z

Hello,

I installed google-spreadsheet together with node-red-contrib-viseo-google-authentication. I can drag the node into the flow and configure it. Bit when I try to deploy my flows I get this message:

The workspace contains some unknown node types:
google-spreadsheet
Are you sure you want to deploy?

or

Flows stopped due to missing node types.
google-spreadsheet

What am I doing wrong?

Using node-red V0.18.04 on a raspberry pi 3 with raspbian stretch with latest updates. Installed the node via UI: settings/palette/install

Thank you for your help.

Chris

The text was updated successfully, but these errors were encountered:

knolleary · 2018-04-13T11:58:27Z

The current version of the google spreadsheet node is broken.

When trying to load it, you get:

SyntaxError: Unexpected token )

The Node-RED palette manager shouldn't have added it to the palette in this case (so we need to look at that part in Node-RED), but the fundamental issue is the node is broken and cannot load.

Christian-Me · 2018-04-14T13:03:04Z

Thank you for your reply. Sad to hear this. This feature could be verry handy or even essential for my current project.
Can I expect a fix in the near future?
Christian

sejbk · 2018-04-14T13:07:47Z

Same problem, would be great with a fix for this.

Klervix · 2018-04-16T10:36:42Z

Hi everyone,

I don't have this problem on my project. Are you working with the 0.2.9. version? I'll try to fix it today.

mikehole · 2018-04-16T10:50:45Z

Just to answer the question, Yes:

Welcome to Node-RED

13 Apr 12:21:27 - [info] Node-RED version: v0.18.4
13 Apr 12:21:27 - [info] Node.js version: v6.13.1
13 Apr 12:21:27 - [info] Linux 4.9.87-linuxkit-aufs x64 LE
13 Apr 12:21:27 - [info] Loading palette nodes
13 Apr 12:21:28 - [warn] ------------------------------------------------------
13 Apr 12:21:28 - [warn] [node-red/rpi-gpio] Info : Ignoring Raspberry Pi specific node
13 Apr 12:21:28 - [warn] ------------------------------------------------------
13 Apr 12:21:28 - [info] Settings file : /data/settings.js
13 Apr 12:21:28 - [info] User directory : /data
13 Apr 12:21:28 - [warn] Projects disabled : set editorTheme.projects.enabled=true to enable
13 Apr 12:21:28 - [info] Flows file : /data/flows.json
13 Apr 12:21:28 - [info] Creating new flow file
13 Apr 12:21:28 - [info] Server now running at http://127.0.0.1:1880/
13 Apr 12:21:28 - [info] Starting flows
13 Apr 12:21:28 - [info] Started flows
13 Apr 12:22:30 - [info] Installing module: node-red-contrib-viseo-google-spreadsheet, version: 0.2.9
13 Apr 12:22:37 - [info] Installed module: node-red-contrib-viseo-google-spreadsheet
13 Apr 12:22:38 - [info] Added node types:
13 Apr 12:22:38 - [info] - node-red-contrib-viseo-google-spreadsheet:google-spreadsheet : SyntaxError: Unexpected token )
13 Apr 12:50:15 - [info] Stopping flows
13 Apr 12:50:15 - [info] Stopped flows
13 Apr 12:50:15 - [info] Waiting for missing types to be registered:
13 Apr 12:50:15 - [info] - google-spreadsheet

Klervix · 2018-04-16T11:07:49Z

Thank you Mikehole! Could you tell me your version of ""node-red-contrib-viseo-google-authentication"?

sejbk · 2018-04-16T11:12:44Z

Hi, Same problem for me: Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [warn] ------------------------------------------------------ Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [warn] [node-red-contrib-viseo-google-spreadsheet/google-spreadsheet] SyntaxError: Unexpected t Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [warn] ------------------------------------------------------ Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] Settings file : /home/pi/.node-red/settings.js Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] User directory : /home/pi/.node-red Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [warn] Projects disabled : set editorTheme.projects.enabled=true to enable Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] Flows file : /home/pi/.node-red/flows_raspberrypi3.json Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] Server now running at http://127.0.0.1:1880/ Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] Waiting for missing types to be registered: Apr 13 23:20:29 raspberrypi3 Node-RED[25822]: 13 Apr 23:20:29 - [info] - google-spreadsheet Hope this helps or let me know if you need any other logs. / Jonas

…

On 16 Apr 2018, at 13:07, Klervi ***@***.***> wrote: Thank you Mikehole! Could you tell me your version of ""node-red-contrib-viseo-google-authentication"? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#85 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADIynYcdR6IUpVZxBPSWRqoo5rsR1luTks5tpHuGgaJpZM4TH7-8>.

mikehole · 2018-04-16T11:36:34Z

here is a log from a brand new nodered container:

Welcome to Node-RED

16 Apr 11:33:33 - [info] Node-RED version: v0.18.4
16 Apr 11:33:33 - [info] Node.js version: v6.13.1
16 Apr 11:33:33 - [info] Linux 4.9.87-linuxkit-aufs x64 LE
16 Apr 11:33:34 - [info] Loading palette nodes
16 Apr 11:33:34 - [warn] ------------------------------------------------------
16 Apr 11:33:34 - [warn] [node-red/rpi-gpio] Info : Ignoring Raspberry Pi specific node
16 Apr 11:33:34 - [warn] ------------------------------------------------------
16 Apr 11:33:34 - [info] Settings file : /data/settings.js
16 Apr 11:33:34 - [info] User directory : /data
16 Apr 11:33:34 - [warn] Projects disabled : set editorTheme.projects.enabled=true to enable
16 Apr 11:33:34 - [info] Flows file : /data/flows.json
16 Apr 11:33:34 - [info] Creating new flow file
16 Apr 11:33:34 - [info] Server now running at http://127.0.0.1:1880/
16 Apr 11:33:34 - [info] Starting flows
16 Apr 11:33:34 - [info] Started flows
16 Apr 11:34:18 - [info] Installing module: node-red-contrib-viseo-google-authentication, version: 0.0.6
16 Apr 11:34:23 - [info] Installed module: node-red-contrib-viseo-google-authentication
16 Apr 11:34:24 - [info] Added node types:
16 Apr 11:34:24 - [info] - node-red-contrib-viseo-google-authentication:google-service-account
16 Apr 11:34:24 - [info] - node-red-contrib-viseo-google-authentication:google-api-key
16 Apr 11:34:44 - [info] Installing module: node-red-contrib-viseo-google-spreadsheet, version: 0.2.9
16 Apr 11:34:49 - [info] Installed module: node-red-contrib-viseo-google-spreadsheet
16 Apr 11:34:49 - [info] Added node types:
16 Apr 11:34:49 - [info] - node-red-contrib-viseo-google-spreadsheet:google-spreadsheet : SyntaxError: Unexpected token )

These nodes are being added via the pallet management UI. Hope this helps.

Klervix · 2018-04-18T15:23:49Z

We will receive a Raspberry in a few days, and so be able to reproduce this bug (no problem with linux/windows)

mikehole · 2018-04-18T15:28:00Z

I have the issue on docker* by the way I am using the node red official container:

https://hub.docker.com/r/nodered/node-red-docker/

*Docker for windows.

knolleary · 2018-04-18T15:33:29Z

I've had a quick look at the error and identified the problem. This node requires node.js 8.x. It will not work with any earlier version of node.js.

mikehole · 2018-04-18T15:38:13Z

Ah that's a pain there was me thinking that the docker image would be up to date when it comes to node.

sejbk · 2018-04-18T15:39:20Z

Hi, This is some more info on the system I’m running. Raspberry Pi 3 with Raspbian Stretch / Jonas

…

Sent from my MacBook Pro (m) +46 70 793 26 09 (e) jonas.back.se@gmail.com

On 18 Apr 2018, at 17:23, Klervi ***@***.***> wrote: We will receive a Raspberry in a few days, and so be able to reproduce this bug (no problem with linux/windows) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#85 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ADIynZhGO5RI8O8kladWT2nVbfodoV4Hks5tp1qGgaJpZM4TH7-8>.

knolleary · 2018-04-18T15:40:10Z

We do publish node 8 images - https://github.com/node-red/node-red-docker#images - but the default images are still 6. We will be switching over at some point in the future, but can't just switch them as its a major version change.

sejbk · 2018-04-18T16:37:23Z

Yes, so after switching to Node 8 I do get the node to load on the Raspberry Pi.

First it then complained about not having a scope, so added https://www.googleapis.com/auth/cloud-platform to the security configuration. Then it tried to load data but gave another error, it seems that it's somehow builds the URL incorrectly.

Looks like it tries to build the URL by combining the parameter from the node with parts of the REST api version url.

(I've changed the id of the spreadsheet when posting here.)

sheet | "https://docs.google.com/spreadsheets/d/1234567890/edit#gid=0"

The error message from Google is :

404. That’s an error.

The requested URL /v4/spreadsheets/https://docs.google.com/spreadsheets/d/1234567890/edit was not found on this server. That’s all we know.

Klervix · 2018-04-19T08:46:08Z

Hi @sejbk,
Please read our documentation in Node Red info tab. All the fields are described.

Christian-Me · 2018-04-23T10:31:31Z

Hello,

after updating node.js and npn no errors on deployment. But I get the same error as @sejbk

23 Apr 12:24:00 - [warn] [google-spreadsheet:Test1] Error: <!DOCTYPE html>
<html lang=en>
  <meta charset=utf-8>
  <meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width">
  <title>Error 404 (Not Found)!!1</title>
  <style>
    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}
  </style>
  <a href=//www.google.com/><span id=logo aria-label=Google></span></a>
  <p><b>404.</b> <ins>That’s an error.</ins>
  <p>The requested URL <code>/v4/spreadsheets/https://docs.google.com/spreadsheets/d/1T-TRHrbLECIrQNVrVxDQe49MSATSc2ysRT9H0adq7h8/edit</code> was not found on this server.  <ins>That’s all we know.</ins>

Copy paste https:// [....] /edit bings be to the desired spreadsheet.

I think i did all configurations right.

Klervix · 2018-04-23T11:50:29Z

Hi there!
In the node's configuration, you should enter the spreadsheet's ID for the 'ID' field, which is only '1T-TRHrbLECIrQNVrVxDQe49MSATSc2ysRT9H0adq7h8' in your case. The 'range' field must be your tab's name.
You can find the concepts here: https://developers.google.com/sheets/api/guides/concepts

Please tell me if it works! :)

Christian-Me · 2018-04-24T09:00:47Z

Thank you!

my fault. Now I ran into the next problem:

Error: Request had insufficient authentication scopes.

I fixed it with adding the scope "https://www.googleapis.com/auth/spreadsheets" (for other users who run into the same problem)

Thank you for your great work. Have a nice day!

janvda · 2018-04-27T17:41:35Z

I am having the same issue regarding the "SyntaxError" on my raspberry PI when using Node.js version : v6.13.1:

Welcome to Node-RED
===================
27 Apr 19:25:46 - [info] Node-RED version: v0.18.4
27 Apr 19:25:46 - [info] Node.js  version: v6.13.1
27 Apr 19:25:46 - [info] Linux 4.9.35-v7+ arm LE
27 Apr 19:25:47 - [info] Loading palette nodes
27 Apr 19:25:52 - [info] Dashboard version 2.8.2 started at /ui
27 Apr 19:25:57 - [warn] ------------------------------------------------------
27 Apr 19:25:57 - [warn] [node-red-contrib-viseo-google-spreadsheet/google-spreadsheet] SyntaxError: Unexpected token )
27 Apr 19:25:57 - [warn] ------------------------------------------------------
27 Apr 19:25:57 - [info] Settings file  : /home/pi/.node-red/settings.js
27 Apr 19:25:57 - [info] User directory : /home/pi/.node-red

I am willingly to upgrade to version 8 if this won't break my flows or at least that it is not expected that this will break any flows. Can you confirm this ?
And if so are there any instructions how I can best upgrade to version 8 ?

kr
jan

igisho · 2018-12-03T13:14:59Z

Same problem here with node red version 0.19.5 and node.js 9.10.1. Any sugestion?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

node-red-contrib-viseo-google-spreadsheet : Problem installing #85

node-red-contrib-viseo-google-spreadsheet : Problem installing #85

Christian-Me commented Apr 5, 2018 •

edited

Loading

knolleary commented Apr 13, 2018

Christian-Me commented Apr 14, 2018

sejbk commented Apr 14, 2018

Klervix commented Apr 16, 2018

mikehole commented Apr 16, 2018

Klervix commented Apr 16, 2018

sejbk commented Apr 16, 2018 via email

mikehole commented Apr 16, 2018

Klervix commented Apr 18, 2018

mikehole commented Apr 18, 2018 •

edited

Loading

knolleary commented Apr 18, 2018

mikehole commented Apr 18, 2018

sejbk commented Apr 18, 2018 via email

knolleary commented Apr 18, 2018

sejbk commented Apr 18, 2018 •

edited

Loading

Klervix commented Apr 19, 2018

Christian-Me commented Apr 23, 2018 •

edited

Loading

Klervix commented Apr 23, 2018

Christian-Me commented Apr 24, 2018

janvda commented Apr 27, 2018 •

edited

Loading

igisho commented Dec 3, 2018

node-red-contrib-viseo-google-spreadsheet : Problem installing #85

node-red-contrib-viseo-google-spreadsheet : Problem installing #85

Comments

Christian-Me commented Apr 5, 2018 • edited Loading

knolleary commented Apr 13, 2018

Christian-Me commented Apr 14, 2018

sejbk commented Apr 14, 2018

Klervix commented Apr 16, 2018

mikehole commented Apr 16, 2018

Welcome to Node-RED

Klervix commented Apr 16, 2018

sejbk commented Apr 16, 2018 via email

mikehole commented Apr 16, 2018

Welcome to Node-RED

Klervix commented Apr 18, 2018

mikehole commented Apr 18, 2018 • edited Loading

knolleary commented Apr 18, 2018

mikehole commented Apr 18, 2018

sejbk commented Apr 18, 2018 via email

knolleary commented Apr 18, 2018

sejbk commented Apr 18, 2018 • edited Loading

Klervix commented Apr 19, 2018

Christian-Me commented Apr 23, 2018 • edited Loading

Klervix commented Apr 23, 2018

Christian-Me commented Apr 24, 2018

janvda commented Apr 27, 2018 • edited Loading

igisho commented Dec 3, 2018

Christian-Me commented Apr 5, 2018 •

edited

Loading

mikehole commented Apr 18, 2018 •

edited

Loading

sejbk commented Apr 18, 2018 •

edited

Loading

Christian-Me commented Apr 23, 2018 •

edited

Loading

janvda commented Apr 27, 2018 •

edited

Loading