Version: Streamsheets 2.5

OPCUA.READ

This is a premium 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

Name	Description
Producer	Producer to use for publishing.
Node	Path of the node to read or node id.
Target	INBOX(), 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

Formula	Result	Comment
`=OPCUA.READ(\|OPCUAProducer,A5,INBOX())`	The request ID	This reads the node and places the result into the inbox.
`=OPCUA.READ(\|OPCUAProducer,"/Objects/1:Machines/1:H1mrblX0X/name",C5:G9)`	The request ID	This reads the name of the app with the id "H1mrblX0X" and places the result into the inbox.