Create a JSON data file
- Last UpdatedAug 16, 2022
- 1 minute read
Data can be uploaded to AVEVA Insight in a wide-format JSON file. Each record in the JSON file can support several tag values, but note that each value will be associated with the timestamp specified by DateTime.
By default, records uploaded to AVEVA Insight with a JSON data file will have an OpcQuality of good (192). Records will also be uploaded using the storage operation "latest."
To create a JSON data file
-
Open a text editor.
-
Create a file using this format:
{
"data": [
{
"DateTime": "<value>",
"<TagName>": <value>,
"<TagName>": <value>,
"<TagName>": <value>,
"<TagName>": <value>,
}
]
}
-
For the first record, replace <value> with actual value for DateTime.
-
Replace each instance of <TagName> with with the names of the tags you intend on updating.
-
Provide values for each instance of <value>.
-
For each subsequent record, copy the lines for the record -- from "{" to "}", inclusive -- and paste them below the first record. Edit the parameter values for each record.
-
Save the file as a JSON file.
Example JSON data file
This JSON file imports two records.
{
"data": [
{
"DateTime": "2019-05-16T00:13:37.661Z",
"Reactor3.Level": 1.51860072870498,
"Reactor3.Temp": 27.1360543141452,
"Reactor3.InletValve": 0,
"Reactor3.Step": 7,
"Line3.Units": 1518,
"Line3.Product": "BRN"
}
{
"DateTime": "2019-05-16T00:14:37.661Z",
"Reactor3.Level": 1.82544328401564,
"Reactor3.Temp": 27.25.8223338096584,
"Reactor3.InletValve": 0,
"Reactor3.Step": 7,
"Line3.Units": 1597,
"Line3.Product": null
}
]
}