Need protobuf decoding in function,how can i do that? and while inserting rows in table from function node getting error as ""message": "column msgtype is required." "type": "validation"'

[Brandon_Cannaday]

Hello @Gitanjali_Apet,

Losant does not have built-in support for Protobuf decoding. The best solution I can recommend is to use a cloud function like AWS Lambda, Google Cloud Functions, or Azure Functions. The code to decode protobuf would be executed in a cloud function and invoked by a Losant workflow with the data received over MQTT.

As for your error:

column msgtype is required

This indicates you attempted to insert a row into a data table but did not provide a value for msgtype. When configuring a data table, you can mark certain columns as being required. Losant will then validate inserts automatically to ensure a value has been provided.

As a side note, data tables are not designed for device data. If this is timeseries data being reported by a device, it should not be written to a data table. It should be written to Device Attributes. There’s a further explanation here:

JSON to file weird output

Losant Data Tables are designed for relatively static data sets. Something like a table that maps fault codes to their description and other meta data. Data Tables are backed by a database optimized “write light” and “read heavy”. This means data tables can be queried at high rates, but you’ll notice scalability issues if you attempt to continually insert or update data. If you do want to continually insert data into a database, the recommended approach would be to connect to a managed cloud D…