Spark Core and Node-RED integration

Social Project Share
81

Hi,
I use Node-Red with a Flow to save data in mongoDB. It’s possible to get published_at + code_id from the msg.raw and add both into the payload.data before insert in mongoDB ?

In my mongoDB table, I would like a format column like :slight_smile:
_id | code_id | published_at | temperature | humidity | temperature2 | relay

Instead of:
_id | temperature | humidity | temperature2 | relay

Here my payload.data :
{“event”:“mongo-test”,“data”:"{“temperature”: 73.2,“humidity”: 22.4,“temperature2”: 74.4,“relay”: 0}",“published_at”:“2018-03-20T02:40:40.275Z”,“coreid”:“MYCODEIDHERE”,“userid”:“MYUSERID”,“fw_version”:10,“public”:false,"_id":“THEFALSEIDHERE”}

Can use flow in Node-Red to get published_at + code_id or I need to include both information into my publish event (in firmware)

Thanks