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

Name	Type	Description
Range	Range	JSON like structure with two optional columns "data type" and "variable type"

Return

Type	Description
JSON	JSON for use with OPCUA.VARIABLES

Examples

	A	B
1	example
2	param1	13
3	string1	test1
4	param2	12
5	string2	test2
6	param3	16.23

Formula	Result	Comment
=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.