Example

This example Application demonstrates how to use the JSON Connector to simulate frequency readings.

You can download the files here to try it out for yourself.

Refer to configuration to understand all configuration options of this Connector.

Step 1: Add the Connection

From the Properties blade of the widget to which the JSON Connector will be linked, a data grid in our example, select the Data Source tab.

Click the plus icon next to Data Source, then the plus icon next to Connection, and select the JSON Connector.

Step 2: Configure Input

Enter the JSON and the definitions grid is pre-populated. Amend the data types as necessary.

In this case, paste the below text as the JSON. Once the grid refreshes, set the type of TagTimeStamp to DateTime, Value as Double, and keep the Attr as String.

[
  {
    "TagTimestamp": "2022-12-08T10:15",
    "Attr": "Hz",
    "Value": "59.967"
  },
  {
    "TagTimestamp": "2022-12-08T10:17",
    "Attr": "Hz",
    "Value": "59.999"
  },
  {
    "TagTimestamp": "2022-12-08T10:19",
    "Attr": "Hz",
    "Value": "59.987"
  }
]

Enter a Name for the Connection and click Save. In this case, set the name to JSON Connector.

Step 3: Use the Connection

Select the Connection that was just created, wait while the entity to read is populated, select the primary key, and enter the Data Source name. Save the Data Source.

In this case, set the primary key to TagTimestamp, and the name to JSON Data.