I am working on setting up the UFL connector to parse a JSON file. I have a powershell script which calls for a JSON file and stores the file in a local folder when the script is run. The connector is set to parse this file when it updates.
I am working on the .ini file and have not been able to find an answer to the issue I am encountering. The timestamps on the incoming data are in milliseconds since unix epoch. I have tried several different configurations for the .ini file but continue getting the error [1, [Error] . Value start/end is incorrect.]. I believe this issue has to do with the timestamp pulled from my data.
I have tried several different configurations (one of the iterations is below), changing the data type and converting between units, even tried typing in the timestamp as a string, but continue to get the same error.
The final result I would like to get is to convert the milliseconds since unix epoch to seconds GMT and use this as the timestamp to send data to PI.
Here is a sample of my .ini file:
FIELD(1).Name = "OpICAO"
FIELD(2).Name = "Epochms"
FIELD(2).Type = "Number"
FIELD(3).Name = "Epochs"
FIELD(3).Type = "Number"
FIELD(4).Name = "Epochs2"
FIELD(4).Type = "String"
FIELD(5).Name = "UpdateTime"
FIELD(5).Type = "DateTime"
FIELD(5).Format = "SECONDS_GMT"
'==============Define Message Statements========
MSG(1).Name = "Data"
'==========Store PI Points======
Data.FILTER = C1 == "*"
FOREACH (JsonGetItem(__MESSAGE, "acList")) DO
Epochms = JsonGetValue(__ITEM, "PosTime")
Epochs = Epochms/1000
Epochs2 = Epochs
UpdateTime = Epochs2
OpICAO = JsonGetValue(__ITEM, "OpIcao")
StoreEvent(OpICAO + "_" + "OpIcao",, UpdateTime, OpICAO)
And the JSON file:
Any ideas would be much appreciated.