Updating Tulip tables with Node Red - 2 questions

1

I am using node red to integrate our AMR fleet with Tulip being the interface for mission control. I have connected tulip to MFE software and a send calls for missions. In order to get the JSON message from MFE back to Tulip I had to use a middleware. I have chosen Node Red (since it is already available on our Edge IOs). There are multiple pickup and drop off locations/stands throughout the plant). What i am trying to do is receive a call in node red from the fleet software to keep the status of these stands up to date. Once i get this call I know what stand and what status it should be.

First question, one column in my tulip table is color format. I have tried to pass the message below with the hex code but i get error 422 back. Any thoughts on what i need to send to update the color in the table?

msg.body = {‘yjxyj_status’:‘Not Available’,

‘wpgvf_stand_color’:‘#C33D36’}

return msg;

Second question, in the tulip table node… for the record ID i want to use a payload to determine what record to update. Should this work?

image
image507×733 17 KB

2

I got the command structure to update the color object data type:

msg.body = {

"wpgvf_stand_color": {

"r": 62,

"g": 126,

"b": 232,

"a": 1

}

}

return msg;