{"id":11151,"date":"2020-07-17T10:03:24","date_gmt":"2020-07-17T13:03:24","guid":{"rendered":"http:\/\/kb.elipse.com.br\/en\/?p=11151"},"modified":"2020-07-17T10:03:24","modified_gmt":"2020-07-17T13:03:24","slug":"kb-109501-collecting-timestamp-from-a-json-message-via-driver-mqtt","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb-109501-collecting-timestamp-from-a-json-message-via-driver-mqtt\/","title":{"rendered":"KB-109501: Collecting values and timestamp from a JSON message via Driver MQTT."},"content":{"rendered":"

Question:<\/h2>\n

I receive messages in JSON format in my MQTT devices, so I would like to collect the values Time <\/strong>(timestamp), var1<\/strong>, and var2<\/strong>. How should I set up the Elipse MQTT driver<\/a> template to do so?<\/p>\n

{\r\n\"FormatId\":\"TagValues\",\r\n\"ApiVersion\":1,\r\n\"CollectionId\":1,\r\n\"TagData\":[{\r\n                    \"Time\":\"2020-05-25T21:11:07.337-3:00\",\r\n                    \"Values\":{\"var1\":110,\"var2\":true}\r\n                    }]\r\n}<\/pre>\n
Solution:<\/h2>\n
JSON<\/b> (JavaScript Object Notation) is a lightweight data-interchange format. To extract the contents in a JSON message and collect the Elipse MQTT driver’s timestamp value, you will need to declare the template. Templates allow reporting not only about the messages format but also which parts should be turned into data. They can come in different types, such as JSON, CSV, or XML, and each template must use keywords, in order to replace the values you need to extract. A list of keywords is available at the Elipse MQTT driver’s manual.<\/p>\n
On Templates <\/strong>tab, you will be able to set up different patterns for the MQTT message data, whose elements can then be automatically extracted.<\/p>\n
In this case, for the message specifically discussed in this article, we can use the following template:<\/p>\n
{\"FormatId\":\"DUMMY\",\r\n\"ApiVersion\":\"DUMMY\",\r\n\"CollectionId\":\"DUMMY\",\r\n\"TagData\":[{\"Time\":\"TS_TEXT(%Y-%m-%dT%H:%M:%S.%f%+)\",\r\n\"Values\":{\"var1\":\"E3VAL\",\"var2\":\"E3VAL\"}}]}<\/pre>\n
In order to receive data from the variables, you must first create an I\/O Block tag with two elements; then, at the tag’s Item parameter (ParamItem<\/strong> property), you will need to indicate both the topic and the template.<\/p>\n
The value of Time variable will automatically be attributed to the tag’s timestamp.<\/p>\n
NOTE<\/strong>: The demo application attached to this article was developed with Elipse E3 version 5.1 build 175.<\/p>\n
Related Article:<\/h3>\n
\n