Node-Red Help OBIX connector

General
1

Hi All, I am new to node red and am currently trying to use it as a gateway connection from a MS SQL server to Niagara 4, With the purpose of writing data from the MS SQL to the Niagara 4 station.

Currently I have successfully connected to the MS SQL server using node-red-contrib-mssql-plus and am running queries succesfully

I have also successfully connected to my Niagara 4 station using node-red-contrib-obix-niagara-connector and am writing to a numeric value successfully

Where i need help is how do i connect the two to push the data from the query to my Niagara 4 bix connection ?

Below is my flow, Currently the data being written to my Niagara 4 station is whatever the value is setup in the connector

Thankyou for anyone that can help !

image
image956×298 10.7 KB

image
image1164×840 24.8 KB

2

Welcome to the forums @nick.494 - Sorry for the delayed response, the community is a little more tied up in the summer with family commitments

The way I will tackle this, is as follows.
You have connected the query output to a debug Node right?

So why not connect the query output to a change or function node - massage the data, and connect your massaged data to the niagara Node.

It of course does help if you know a thing about javascript and its Object-oriented nature.

Don't overthink it - think of Node RED as passing objects between nodes (and being able to do things at each node).

You will need to understand the niagara node, and massage the returned query to fit as necessary according to the read me of niagara