OPCUA.WRITE

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.

Syntax

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

Arguments

Name

Description

Producer

Producer to use for publishing.

Node

Path of the node to write to or node id.

ValueJSON

JSON with a “value” and a “dataType” field containing the value to write and the data type of the value.

Target

Target of the result of the write operation. Can be either INBOX(), OUTBOX(“MsgID”) or a cell range.

ResultKeys

Optional. Limit the result to the specified JSON Keys

Timeout

Optional. 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.

Examples

Function

Result

Comment

=OPCUA.WRITE(“OPCUA Producer”,”/Objects/1:Machines/
1:H1mrblX0X/name”,JSON(A2:B3), INBOX())
OPCUA.WRITE

The request ID

This sets the name of the machine with the id “H1mrblX0X” to “New Name”. The result of the operation, either confirmation or any error is placed into the Inbox.