Wiki source code of ThingsBoard

Version 125.1 by Dilisi S on 2025/03/08 20:47

Hide last authors
Dilisi S 1.1 1 **Table of Contents:**
2
3 {{toc/}}
4
Dilisi S 16.1 5 {{warning}}
6 Draft Document
7 {{/warning}}
Dilisi S 1.1 8
Xiaoling 65.1 9
10
11
Xiaoling 64.2 12 = 1. Introduction =
Dilisi S 1.1 13
Xiaoling 64.2 14
Dilisi S 21.1 15 This document guides you on integrating Dragino **-NB** and **-CB** series devices data with ThingsBoard. For this guide, we use ThingsBoard Cloud, which is one of the ThingsBoard versions that allows you to try it for free.
Dilisi S 2.1 16
Dilisi S 21.1 17 The **NB series** devices end with the suffix **-NB**, and the **CB series** devices end with the suffix **-CB**. For example, **S31B-NB** is an **NB device**, and **S31-CB** is a **CB device**.
Dilisi S 11.1 18
Dilisi S 17.1 19
Dilisi S 117.1 20 = 2. Prerequisites =
Dilisi S 11.1 21
Dilisi S 117.1 22 To complete this tutorial, you need to have the following:
Xiaoling 64.2 23
Dilisi S 121.1 24 * ThingsBoard cloud account
Dilisi S 117.1 25 * HiveMQ Cloud account
Dilisi S 59.1 26
Dilisi S 121.1 27 == 2.1 ThingsBoard Cloud ==
Dilisi S 117.1 28
29
Dilisi S 125.1 30 Go to [[https:~~/~~/thingsboard.io/>>https://thingsboard.io/]]
Dilisi S 121.1 31
Dilisi S 125.1 32 Click on the **Try it now**.
33
34
35 [[image:thingsboard-1.png]]
36
37
38 Select either the **North America** or **Europe** region. Here, we use the Europe region.
39
40 [[image:thingsboard-2.png]]
41
42
43 You can sign up with your Google, GitHub, Facebook, or Apple account. If not you can create an account with providing your name, email address and a password.
44
45 [[image:thingsboard-3.png||height="651" width="500"]]
46
47
Dilisi S 121.1 48 == 2.2 HiveMQ Cloud ==
49
50
Dilisi S 117.1 51 Go to [[https:~~/~~/www.hivemq.com>>https://www.hivemq.com]]
52
53 Click on the **Start Free** button.
54
55 [[image:hivwmq-1.png]]
56
57
58 Click on the **Sign Up FREE Now** button in the **HIVEMQ CLOUD** section.
59
60 [[image:hivemq-2.png]]
61
62
63 Click on the **Sign Up** button.
64
65 You can sign up with HiveMQ using your **GitHub**, **Google**, or **LinkedIn** account.
66
67 If not, provide your **email address** and a **password** to create an account by clicking on the **Sign Up** button.
68
69
70 [[image:hivemq-3.png]]
71
72
73 You will receive an email to verify your email address. Click on the **Confirm my account** button.
74
75
76 [[image:hivemq-4.jpg||height="889" width="400"]]
77
78
79 You will be redirected to a page asking you to complete your profile. Once done, click the **Continue** button.
80
81
82 [[image:hivemq-5.png||height="655" width="700"]]
83
84
85 Select the CloudMQ Cloud plan you need. For testing purposes, select the **Serverless FREE** plan by clicking on the **Create Serverless Cluster** button.
86
87
88 [[image:hivemq-6.png]]
89
90
91 You will be navigated to the **Your Clusters** page. Click on the **Manage Cluster** button.
92
93 [[image:hivemq-7.png]]
94
95
96 In your cluster page, you can find some useful parameters you need to create a MQTT connection.
97
98 **URL**: This is the host name. Click on the copy button to copy it.
99
100 **Port**: 8883
101
102
Dilisi S 121.1 103 Click on the **Getting Started** tab to setup the username and the password as the connection credentials.
Dilisi S 117.1 104
105
106 [[image:hivemq-8.png]]
107
108
Dilisi S 121.1 109 In the '**Create Connection Credentials**' section, provide a **username** and **password**, then click the **Add** button.
Dilisi S 117.1 110
Dilisi S 11.1 111
Dilisi S 121.1 112 [[image:hivemq-9.png]]
Dilisi S 11.1 113
Dilisi S 121.1 114
115
116 If everything is successful, you will see the following message.
117
118
119 [[image:hivemq-10.png||height="206" width="500"]]
120
121
122 You will need these MQTT connection parameters when configuring the MQTT integration in the '**Add Integration**' section.
123
124
125 = 3. Data Converters =
126
127
Dilisi S 93.1 128 In **ThingsBoard**, **Data Converters** are components used to transform incoming or outgoing data between different formats, typically to convert raw telemetry data from devices into a structured format that ThingsBoard can understand, or vice versa.
Dilisi S 11.1 129
130
Dilisi S 121.1 131 == 3.1 Uplink ==
Dilisi S 11.1 132
133
Dilisi S 93.1 134 In the left navigation, click **Integrations center**, and then click **Data converters**.
Dilisi S 11.1 135
Dilisi S 59.1 136
137
Dilisi S 93.1 138 [[image:data-converters-list-empty.png]]
Dilisi S 59.1 139
140
Dilisi S 93.1 141 On the **Data converters** page, click on the ‘**+**’ button, and then click on the **Create new converter** from the dropdown menu.
Dilisi S 59.1 142
143
144
Dilisi S 93.1 145 [[image:create-new-converter-menu.png||height="259" width="500"]]
Dilisi S 59.1 146
147
Dilisi S 36.1 148 The **Add data converter** window will appear. Name it ‘**MQTT Uplink Converter NB/CB**’ and select the Type as **Uplink**.
Dilisi S 11.1 149
Dilisi S 93.1 150 Click on the **TBEL** button if not selected it by default. Delete the existing decoder function in the code editor. Now copy and paste the following decoder function written in **TBEL (ThingsBoard Expression Language)** in to the **code editor**. This decoder function is compatible for both NB and CB series devices.
Dilisi S 11.1 151
152 {{code language="JavaScript"}}
Dilisi S 93.1 153 /** Decoder **/
154
Dilisi S 11.1 155 // decode payload to string
156 var payloadStr = decodeToString(payload);
Dilisi S 93.1 157 var data = JSON.parse(payloadStr);
Dilisi S 11.1 158
Dilisi S 93.1 159 var deviceName = metadata.topic.split("/")[3];
Dilisi S 11.1 160 // decode payload to JSON
Dilisi S 93.1 161 var deviceType = 'sensor';
Dilisi S 11.1 162
Dilisi S 93.1 163 // Result object with device attributes/telemetry data
Dilisi S 11.1 164 var result = {
165 deviceName: deviceName,
Dilisi S 93.1 166 deviceType: deviceType,
Dilisi S 11.1 167 attributes: {
Dilisi S 93.1 168 integrationName: metadata['integrationName'],
Dilisi S 11.1 169 },
Dilisi S 93.1 170 telemetry: {
171 temperature: data.temperature,
172 humidity: data.humidity,
173 }
174 };
Dilisi S 11.1 175
Dilisi S 93.1 176 /** Helper functions 'decodeToString' and 'decodeToJson' are already built-in **/
Dilisi S 11.1 177
178 return result;
179 {{/code}}
180
Xiaoling 64.2 181
Dilisi S 21.1 182 Click on the **Add** button.
Dilisi S 11.1 183
184
185
Dilisi S 93.1 186 [[image:add-uplink-data-converter.png||height="529" width="500"]]
Dilisi S 11.1 187
Dilisi S 93.1 188
189 You should see that the newly added **MQTT Uplink converter **NB/CB is listed on the **Data Converters** page.
190
Dilisi S 105.1 191 [[image:data-converter-list-showing-uplink-dc.png]]
Dilisi S 21.1 192
193
Dilisi S 94.1 194
Xiaoling 64.2 195 == 3.2 Downlink ==
Dilisi S 11.1 196
Xiaoling 64.2 197
Dilisi S 21.1 198 On the **Data converters** page, click on the ‘**+**’ button, and then click on the **Create new converter** from the dropdown menu.
Dilisi S 11.1 199
200
Dilisi S 105.1 201 [[image:create-new-converter-menu.png||width="500"]]
Dilisi S 11.1 202
Dilisi S 105.1 203
204
Dilisi S 36.1 205 The **Add data converter** window will appear. Name it ‘**MQTT Downlink Converter NB/CB**’ and select the Type as **Downlink**.
Dilisi S 11.1 206
Dilisi S 93.1 207 Click on the **TBEL** button if not selected it by default. Now copy and paste the following encoder function written in **TBEL (ThingsBoard Expression Language)** in to the **code editor**. This encoder function is compatible for both NB and CB series devices.
Dilisi S 11.1 208
209
210 {{code language="JavaScript"}}
Dilisi S 93.1 211 // Encode downlink data from incoming Rule Engine message
Dilisi S 11.1 212
Dilisi S 93.1 213 // msg - JSON message payload downlink message json
214 // msgType - type of message, for ex. 'ATTRIBUTES_UPDATED', 'POST_TELEMETRY_REQUEST', etc.
215 // metadata - list of key-value pairs with additional data about the message
216 // integrationMetadata - list of key-value pairs with additional data defined in Integration executing this converter
217
218 /** Encoder **/
219
220 var data = {};
221
222 // Process data from incoming message and metadata
223
224 data.tempFreq = msg.temperatureUploadFrequency;
225 data.humFreq = msg.humidityUploadFrequency;
226
227 data.devSerialNumber = metadata['ss_serialNumber'];
228
Dilisi S 11.1 229 // Result object with encoded downlink payload
230 var result = {
Dilisi S 93.1 231
Dilisi S 11.1 232 // downlink data content type: JSON, TEXT or BINARY (base64 format)
Dilisi S 93.1 233 contentType: "JSON",
Dilisi S 11.1 234
235 // downlink data
Dilisi S 93.1 236 data: JSON.stringify(data),
Dilisi S 11.1 237
238 // Optional metadata object presented in key/value format
Dilisi S 93.1 239 metadata: {
240 topic: metadata['deviceType']+'/'+metadata['deviceName']+'/upload'
241 }
Dilisi S 11.1 242
243 };
244
245 return result;
246 {{/code}}
247
248
249 Click on the **Add** button.
250
251
252
Dilisi S 93.1 253 [[image:add-downlink-data-converter.png||height="529" width="500"]]
Dilisi S 21.1 254
255
Dilisi S 93.1 256 You should see that the newly added **MQTT Downlink** Converter NB/CB is listed on the **Data Converters** page.
Dilisi S 21.1 257
Dilisi S 11.1 258
Dilisi S 93.1 259 [[image:data-converters-list.png]]
260
Dilisi S 105.1 261
262
Dilisi S 121.1 263 = 4. Add Integration =
Dilisi S 93.1 264
265
Dilisi S 21.1 266 In the left navigation, click **Integrations center**, and then click **Integrations**.
Dilisi S 11.1 267
Dilisi S 105.1 268
269 [[image:integrations-list-empty.png]]
270
271
Dilisi S 21.1 272 On the **Integrations** page, click on the '**+**' button.
Dilisi S 11.1 273
274
Dilisi S 21.1 275 The **Add integration** window appears.
Dilisi S 11.1 276
Dilisi S 24.1 277 In the **Add integration** window, configure the following settings:
Dilisi S 11.1 278
Dilisi S 21.1 279
Dilisi S 11.1 280 **Basic settings:**
281
Dilisi S 49.1 282 * **Integration type**: MQTT
283 * **Name**: MQTT integration NB/CB
Dilisi S 105.1 284 * **Enable integration**: YES
285 * **Allows create devices or assets**: YES
Dilisi S 11.1 286
287 Click **Next** button.
288
Dilisi S 105.1 289
290
Dilisi S 16.1 291 [[image:add-integration-basic-settings.png||height="511" width="500"]]
Dilisi S 11.1 292
293
Dilisi S 16.1 294 **Uplink data converter:**
Dilisi S 11.1 295
Dilisi S 21.1 296 * Click on the **Select existing** button.
Dilisi S 49.1 297 * **Uplink data converter**: Select **MQTT Uplink Converter NB/CB **from the dropdown list.
Dilisi S 16.1 298
299 Click **Next** button.
300
301
302
Dilisi S 105.1 303 [[image:add-integration-uplink-data-converter.png||height="511" width="500"]]
304
305
Dilisi S 16.1 306 **Downlink data converter:**
307
Dilisi S 21.1 308 * Click on the **Select existing** button.
Dilisi S 49.1 309 * **Downlink data converter**: Select **MQTT Downlink Converter NB/CB **from the dropdown list.
Dilisi S 16.1 310
311 Click **Next** button.
312
313
314
Dilisi S 105.1 315 [[image:add-integration-downlink-data-converter.png||height="511" width="500"]]
316
317
Dilisi S 16.1 318 **Connection:**
319
Dilisi S 93.1 320 * **Host**: Cluster URL (Eg. 011731f7928541588a6cdfbbedfc63f4.s1.eu.hivemq.cloud)
321 * **Port**: 8883
Dilisi S 49.1 322 * **Credentials**: Basic
Dilisi S 93.1 323 * **Enable SSL**: YES
324 * **Username**: Username (from your HiveMQ Cloud Cluster with your credentials)
325 * **Password:** Password (from your HiveMQ Cloud Cluster with your credentials)
326 * **Topic:** tb/mqtt-integration-tutorial/sensors/+/telemetry (the + replaces any 'device name' and creates devices in the Entities -> Devices)
327 * **QoS:** 0-At most once
Dilisi S 105.1 328
329 [[image:add-integration-connection.png||height="511" width="500"]]
330
331
332 Click on the **Advanced settings** button.
333
Dilisi S 93.1 334 * **Clean session:** NO
335 * **Retained**: NO
Dilisi S 16.1 336
Dilisi S 105.1 337 [[image:add-integration-connection-advanced-settings.png||height="510" width="500"]]
338
339
Dilisi S 49.1 340 Click on the **Check connection** button to verify the MQTT connection using the provided parameters.
Dilisi S 16.1 341
Dilisi S 49.1 342
Dilisi S 105.1 343 [[image:check-connection.png||height="83" width="300"]]
344
345
Dilisi S 117.1 346 If the connection is successful, you will see the **Connected** message. If not, check your connection parameters again.
Dilisi S 49.1 347
Dilisi S 105.1 348
349 [[image:connection-success.png||height="511" width="500"]]
350
351
Dilisi S 16.1 352 Click on the **Add** button.
353
Dilisi S 59.1 354 You should see that the newly added integration is listed on the **Integrations** page.
Dilisi S 49.1 355
Dilisi S 59.1 356 Since we haven't received data from a device yet, the integration **Status** is shown as **Pending.**
Dilisi S 49.1 357
358
359
Dilisi S 117.1 360 [[image:new-integration-pending.png]]
361
362
Xiaoling 64.2 363 = 5. Verifying the receipt of data from the device =
Dilisi S 49.1 364
Dilisi S 16.1 365
Dilisi S 64.1 366 On the terminal, issue the following MQTT command which simulates the device S31B-NB.
367
368 {{code language="none"}}
369 mosquitto_pub -d -q 1 -h mqtt.eu.thingsboard.cloud -p 1883 -t v1/devices/S31B-NB/telemetry -u "24vk3w9h7sqdld1me5eh" -m "{temperature:20}"
370 {{/code}}
371
372 If the integration was performed without errors, after the transmission of the first telemetry, a new device with the name “S31B-NB” will appear in the Devices → All. Also, you can verify the input and output data, respectively, before and after conversion in Data converters → UDP Uplink Converter NB/CB → Events.