Skip to main content
Version: Streamsheets 2.5

OPCUA.READ

star This is a Streamsheets Enterprise feature.

Reads a value from an OPC UA Server. You can use the Function Wizard for this function.

Syntax

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

Arguments

NameDescription
ProducerProducer to use for publishing.
NodePath of the node to read or node id.
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.
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

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

Examples

READPayload

FormulaResultComment
=OPCUA.READ(|OPCUAProducer,A5,INBOX())
The request IDThis reads the node and places the result into the inbox.
=OPCUA.READ(|OPCUAProducer,"/Objects/1:Machines/1:H1mrblX0X/name",C5:G9)
The request IDThis reads the name of the app with the id "H1mrblX0X" and places the result into the inbox.