# mySQL datatable to OPC UA server using node-red

**URL:** <https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460>\
**Category:** General\
**Tags:** function-node, opcua, mysql\
**Created:** [17 October 2024 12:07 UTC](https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460 "2024-10-17T12:07:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![skibidifanuc](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@skibidifanuc](https://discourse.nodered.org/u/skibidifanuc)\
**Post date:** [17 October 2024 12:07 UTC](https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460/1 "2024-10-17T12:07:39Z")

</div>

Hey!  
I'm struggling to send an array of extension objects through from mySQL to an OPC server. When I send values manually (for example I send 3 to point[3].fuseType) it works but I always struggle with the array. The program sends the correct data up until the opc ua client node, but the client node only stores the nodeId, not the value.. Does anyone have any idea?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/c/ac3cb15bdff5c4fef38b86bc0a8bdbe311e6d9ae.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/1/41e2f700a652cb1969914bccb938b53681e46b84.png)

---

<div class="post-metadata">

**Author:** ![piwi447](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/piwi447/32/67335_2.png) [@piwi447](https://discourse.nodered.org/u/piwi447)\
**Post date:** [17 October 2024 19:04 UTC](https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460/2 "2024-10-17T19:04:52Z")

</div>

Hello,  
I made the reverse, read8ngextension object with OPC UA. Bu I had to decode myself the structure, so I think that this extension object is not really supported. My advice I to check this question on github with the developper of OPCUA node. Because it is more a OPC UA trouble than a nodered problem.  
Perhaps trying first to read the extension object from the PLC to node read will show you what the node expect to receive

Pierre RUWET

---

<div class="post-metadata">

**Author:** ![skibidifanuc](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@skibidifanuc](https://discourse.nodered.org/u/skibidifanuc)\
**Post date:** [18 October 2024 06:48 UTC](https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460/3 "2024-10-18T06:48:31Z")

</div>

Thank you for your reply! I'll try it out

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [16 January 2025 06:49 UTC](https://discourse.nodered.org/t/mysql-datatable-to-opc-ua-server-using-node-red/92460/4 "2025-01-16T06:49:17Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.