This guide covers how to leverage JSON within Q-SYS for advanced control, scripting, and external integration. 1. External Control via QRC (JSON-RPC)
SELECT * FROM TABLE(QSYS2.JSON_TABLE( '{"employees":[{"name":"Alice","id":101},{"name":"Bob","id":102}]}', 'lax $.employees[*]' COLUMNS( name VARCHAR(50) PATH '$.name', id INT PATH '$.id' ) )) AS JT; qsys json
if json_data:HasKey("temperature") then local temp = json_data:GetDouble("temperature") end This guide covers how to leverage JSON within