Blog ⁽⁴⁵⁾

UA Office Link's Excel connector can now generate Excel workbooks on the fly, based on a trigger or in regular intervals. Input-style placeholder cells within the workbook are replaced with live values at the time of report generation. The input style is optionally removed for the generated report. Timing and…

UA Office Link introduces new task processors for string manipulation and 'Debounce'. Also new is an "Interval Timer" task input. Supported string manipulation processors include "Left String", "Right String", "Substring" and "Concatenation". The "Debounce" processor takes inputs from potentially disparate sources and relays complete data sets after a configurable delay.

A fully featured MQTT connector is now available in preview. The MQTT connector module functions as an MQTT broker and as one or more MQTT client(s), capable of exchanging data with other MQTT brokers and MQTT clients. Because the MQTT connector integrates into the UA Office Link connector system, it…

With the upcoming MQTT Connector in mind, UA Office Link introduces two new Task Processors to encode and decode JSON or binary data. The JSON Encoder accepts other tags and builds a JSON object string from a template, filling in live values where required before passing it on to the…

UA Office Link's ODBC connector can now be used as a task "Processor", simplifying recipe transfers or calls to stored procedures that expect input arguments and return result values. Besides "Read" and "Write" access, the ODBC Connector topics feature a new "Process" access mode. In this mode, a custom query…