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.
TargetTarget of the result of the write operation. Can be either INBOX(), OUTBOX("MsgID") or a cell range.
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