Importing data from MSSQL into a table in dashboard

[Steve-Mcl]

@ALIEN

Hello friends, Finally I found the problem and I'd like to share my experince with you maybe it helps you later to save your time!

Glad you have things up and running once more.

@ALIEN

I noticed msg.payload has many subfolders which seems starnge,

More technically correct to say "msg.payload had multiple properties". NOTE: It is designed like that to permit the return of multiple queries and to access things like the count of rows affected, output parameter values, SQL Server system error messages etc, etc.

@ALIEN

I reinstalled node-red and imported the flows. I'm reading data directly from db(MSSQL) and Honestly I don't know how to fix this

TBH, I mean no disrespect but that is a terrible way to do SQL. You risk SQL injection hacks. You should use the UI to make parameters.

Here are some examples that should help...

1. Logging data in to MSSQL - #13 by Steve-Mcl
2. Extracting a value from an MS-SQL database - #6 by Steve-Mcl