star This is a Streamsheets Premium feature.

Sends a write request of a value to an OPC UA Server. The Server will respond, if the write was successful or not. You can use the Function Wizard for this function. Click here for a more detailed tutorial on opcua functions.


=OPCUA.WRITE(Producer, Node, ValueJSON, Target[,ResultKeys, Timeout])


ProducerProducer to use for publishing.
NodePath of the node to write to or node id.
ValueJSONJSON with a "value" and a "dataType" field containing the value to write and the data type of the value.
TargetINBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
ResultKeysOptional. Limit the result to the specified JSON Keys
TimeoutOptional. The time to wait for an answer. When left empty a 20 second timeout is being used.

Return Value

The function OPCUA.WRITE always returns a unique random request ID, which can be used with requestinfo to check the state of the request.


=OPCUA.WRITE(|OPCUA Producer,”/Objects/1:Machines/1:H1mrblX0X/name”,JSON(A2:B3), INBOX())
TRUESends the message with id Message from the outbox to an OPCUA Service using the requestId in B1