Cannot get ui_table to display message

Dashboard
1

Tried to display an ui_table. (code attached).
But it seems to not show up on the dashboard.
Input to ui_table is an array of objects which contains row data.
Take a look at the code here :dark_sunglasses:

[{"id":"ced72a38.39e1c8","type":"inject","z":"3cc16b43.65ffe4","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":180,"y":60,"wires":[["5e8fe52d.db801c"]]},{"id":"5e8fe52d.db801c","type":"template","z":"3cc16b43.65ffe4","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"[\n    {\n        \"Name\": \"Kazuhito Yokoi\",\n        \"Age\": \"35\",\n        \"Favourite_Color\": \"red\",\n        \"Date_Of_Birth\": \"12/09/1983\"\n    }\n    \n]","output":"str","x":180,"y":140,"wires":[["e90cf562.a431c8","e277537.732d4b"]]},{"id":"e90cf562.a431c8","type":"ui_table","z":"3cc16b43.65ffe4","group":"c604d450.9712c8","name":"","order":16,"width":0,"height":0,"columns":[{"field":"msg.payload.Name","title":"NAME","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"msg.payload.Age","title":"AGE","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"msg.payload.Favourite_Color","title":"COLOUr","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"msg.payload.Date_Of_Birth","title":"DOB","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":410,"y":200,"wires":[]},{"id":"e277537.732d4b","type":"debug","z":"3cc16b43.65ffe4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":430,"y":140,"wires":[]},{"id":"c604d450.9712c8","type":"ui_group","z":"","name":"tab1","tab":"c733c61c.6e4828","order":1,"disp":true,"width":"12","collapse":false},{"id":"c733c61c.6e4828","type":"ui_tab","z":"","name":"Home1","icon":"dashboard","disabled":false,"hidden":false}]
2

I see two problems:

1.) your template return a string! ... but you need an Object
image
2.) your field properties are wrong. You do not need msg.payload

Solution for 1.)

use a change node or the inject node itself to define a JSON which will be sent as an msg.payload object.
image
the debug node should show this

image

Solution for 2.)

image

[{"id":"b12fd6b8.cef2b8","type":"inject","z":"cbe6938f.7259","name":"","topic":"","payload":"[{\"Name\":\"Kazuhito Yokoi\",\"Age\":\"35\",\"Favourite_Color\":\"red\",\"Date_Of_Birth\":\"12/09/1983\"}]","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":288,"y":136,"wires":[["aa96221a.106c1","29228e2f.9f5092"]]},{"id":"29228e2f.9f5092","type":"ui_table","z":"cbe6938f.7259","group":"d0293776.578938","name":"","order":16,"width":0,"height":0,"columns":[{"field":"Name","title":"NAME","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Age","title":"AGE","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Favourite_Color","title":"COLOUr","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Date_Of_Birth","title":"DOB","width":"","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":528,"y":276,"wires":[]},{"id":"aa96221a.106c1","type":"debug","z":"cbe6938f.7259","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":548,"y":216,"wires":[]},{"id":"d0293776.578938","type":"ui_group","z":"","name":"tab1","tab":"3d46863a.9d043a","order":1,"disp":true,"width":"12","collapse":false},{"id":"3d46863a.9d043a","type":"ui_tab","z":"","name":"Home1","icon":"dashboard","disabled":false,"hidden":false}]
3

I do get the array object.
But no ui_table appears on the dashboard.
I'am using Node-RED v 1.0.6 on IBM cloud
image

5

Sorry it seams that this is a known problem (and I do not have a solution)

6

As this does not work, do you know how to display csv file data into a table?

7

Sorry ... as I'm a big fan of ui-table I never tried a different solution.

But I tried to look into the IBM cloud issue ...

image

But even could not create an account ... will try later

1 Like
8

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.