Hello, I'm currently trying to insert data into a Dash DB. Msg.payload has the following structure when getting sent to the Dash insert node:
{"timestamp":1536659274297,"sensor":"BUS#2","valueType":"barometer","value":98.35288,"lat":Decimal,"lon":Decimal,"timeDifference":8984}
The keys refer to columns in the DB table. I took out lat and lon for security reasons. Otherwise they're decimals.
I get the following error:
dashDB: Insert failed: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ")" was found following "6861.cleanedData " (". Expected tokens may include: "". SQLSTATE=42601
Not really sure what to do here since I followed the guide's instructions for formatting the data.
I've also previously gotten an error regarding the table name. When I enter [scheme.table] I don't seem to get the same message.
Would be grateful for any advice. Thanks!
