Skip to main content
Version: Streamsheets 3.0

OPCUA.JSON

Premium

Creates a JSON for use with OPCUA.VARIABLES. Use this if you want specify the "data type" and "variable type" of the variables.

Syntax

=OPCUA.JSON(Range)

Arguments

NameTypeDescription
RangeRangeJSON like structure with two optional columns "data type" and "variable type"

Return

TypeDescription
JSONJSON for use with OPCUA.VARIABLES

Examples

AB
1example
2param113
3string1test1
4param212
5string2test2
6param316.23
FormulaResultComment
=OPCUA.VARIABLES(OPCUA.JSON(A1:B6))
"TRUE"The two rows are needed to define the variable name and its value. The amount of columns is flexible, depending on the amount and structure of the variables needed. The Range will automatically assume a structure and settings.