Hello, i have a file JSON who look like this :
[
{
"$id": "1",
"id": "WHT",
"label": "WHT",
"unit": "degC",
"equipmentId": "WellHead_1/DigiSWAN Temperature",
"equipmentLabel": "Well Head_01",
"scaleMin": 0.0,
"scaleMax": 110.0,
"sampleRange": [
0.0,
5.0,
80.0,
90.0
],
"lastSample": {
"t": 1680094317052,
"v": 138.69134521484375
},
"lastSampleDisplay": 138.7,
"lastSampleState": "Normal",
"lastTrendState": "Normal",
"lastTrend": 0.0,
"channelSamples": [
{
"$id": "2",
"t": 1680094317052,
"v": 138.69134521484375
},
{
"$id": "3",
"t": 1680094316059,
"v": 136.69134521484375
},
{
"$id": "4",
"t": 1680094315070,
"v": 134.69134521484375
},
{
"$id": "5",
"t": 1680094314074,
"v": 132.69134521484375
},
{
"$id": "6",
"t": 1680094313070,
"v": 130.69134521484375
},
{
"$id": "7",
"t": 1680094312067,
"v": 128.69134521484375
},
{
"$id": "8",
"t": 1680094311074,
"v": 126.69133758544922
},
{
"$id": "9",
"t": 1680094310074,
"v": 124.69133758544922
},
{
"$id": "10",
"t": 1680094309064,
"v": 122.69133758544922
},
{
"$id": "11",
"t": 1680094308079,
"v": 120.69133758544922
},
{
"$id": "12",
"t": 1680094307065,
"v": 118.69133758544922
},
{
"$id": "13",
"t": 1680094306076,
"v": 116.69133758544922
},
{
"$id": "14",
"t": 1680094305075,
"v": 114.69133758544922
},
{
"$id": "15",
"t": 1680094304074,
"v": 112.69133758544922
},
{
"$id": "16",
"t": 1680094303075,
"v": 110.69133758544922
},
{
"$id": "17",
"t": 1680094302077,
"v": 108.69133758544922
},
{
"$id": "18",
"t": 1680094301064,
"v": 106.69133758544922
},
{
"$id": "19",
"t": 1680094300069,
"v": 104.69133758544922
},
{
"$id": "20",
"t": 1680094299065,
"v": 102.69133758544922
},
{
"$id": "21",
"t": 1680094298076,
"v": 100.69133758544922
},
{
"$id": "22",
"t": 1680094297069,
"v": 98.691337585449219
},
{
"$id": "23",
"t": 1680094296065,
"v": 96.691337585449219
},
{
"$id": "24",
"t": 1680094295067,
"v": 94.691337585449219
},
{
"$id": "25",
"t": 1680094294066,
"v": 92.691337585449219
},
{
"$id": "26",
"t": 1680094293064,
"v": 90.691337585449219
},
{
"$id": "27",
"t": 1680094292072,
"v": 88.691337585449219
},
{
"$id": "28",
"t": 1680094291064,
"v": 86.691337585449219
},
{
"$id": "29",
"t": 1680094290077,
"v": 84.691337585449219
},
{
"$id": "30",
"t": 1680094289051,
"v": 82.691337585449219
},
{
"$id": "31",
"t": 1680094288050,
"v": 80.691337585449219
},
{
"$id": "32",
"t": 1680094287085,
"v": 78.691337585449219
},
{
"$id": "33",
"t": 1680091813063,
"v": 50.691337585449219
}
],
"criticity": 0
},
{
"$id": "34",
"id": "CSGP",
"label": "CSGP",
"unit": "psia",
"equipmentId": "WellHead_1/DigiSWAN Pressure Casing",
"equipmentLabel": "Well Head_01",
"scaleMin": 0.0,
"scaleMax": 6000.0,
"sampleRange": [
500.0,
1000.0,
4000.0,
4500.0
],
"lastSample": {
"t": 1680094317001,
"v": 285.0
},
"lastSampleDisplay": 285.0,
"lastSampleState": "Normal",
"lastTrendState": "Normal",
"lastTrend": 0.0,
"channelSamples": [
{
"$id": "35",
"t": 1680094317001,
"v": 285.0
},
{
"$id": "36",
"t": 1680094316009,
"v": 280.0
},
{
"$id": "37",
"t": 1680094315009,
"v": 275.0
},
{
"$id": "38",
"t": 1680094314012,
"v": 270.0
},
{
"$id": "39",
"t": 1680094313007,
"v": 265.0
},
{
"$id": "40",
"t": 1680094312006,
"v": 260.0
},
{
"$id": "41",
"t": 1680094311012,
"v": 255.0
},
{
"$id": "42",
"t": 1680094310011,
"v": 250.0
},
{
"$id": "43",
"t": 1680094309002,
"v": 245.0
},
{
"$id": "44",
"t": 1680094308016,
"v": 240.0
},
{
"$id": "45",
"t": 1680094307001,
"v": 235.0
},
{
"$id": "46",
"t": 1680094306012,
"v": 230.0
},
{
"$id": "47",
"t": 1680094305013,
"v": 225.0
},
{
"$id": "48",
"t": 1680094304012,
"v": 220.0
},
{
"$id": "49",
"t": 1680094303014,
"v": 215.0
},
{
"$id": "50",
"t": 1680094302015,
"v": 210.0
},
{
"$id": "51",
"t": 1680094301002,
"v": 205.0
},
{
"$id": "52",
"t": 1680094300006,
"v": 200.0
},
{
"$id": "53",
"t": 1680094299003,
"v": 195.0
},
{
"$id": "54",
"t": 1680094298014,
"v": 190.0
},
{
"$id": "55",
"t": 1680094297005,
"v": 185.0
},
{
"$id": "56",
"t": 1680094296003,
"v": 180.0
},
{
"$id": "57",
"t": 1680094295004,
"v": 175.0
},
{
"$id": "58",
"t": 1680094294006,
"v": 170.0
},
{
"$id": "59",
"t": 1680094293003,
"v": 165.0
},
{
"$id": "60",
"t": 1680094292010,
"v": 160.0
},
{
"$id": "61",
"t": 1680094291001,
"v": 155.0
},
{
"$id": "62",
"t": 1680094290015,
"v": 150.0
},
{
"$id": "63",
"t": 1680094289000,
"v": 145.0
},
{
"$id": "64",
"t": 1680094288000,
"v": 140.0
},
{
"$id": "65",
"t": 1680094287026,
"v": 135.0
},
{
"$id": "66",
"t": 1680091813001,
"v": 65.0
}
],
"criticity": 0
},
{
"$id": "67",
"id": "WHP",
"label": "WHP",
"unit": "psia",
"equipmentId": "WellHead_1/DigiSWAN Pressure",
"equipmentLabel": "Well Head_01",
"scaleMin": 1500.0,
"scaleMax": 5000.0,
"sampleRange": [
2000.0,
2500.0,
4000.0,
4500.0
],
"lastSample": {
"t": 1680094317052,
"v": 346.72836303710938
},
"lastSampleDisplay": 347.0,
"lastSampleState": "Normal",
"lastTrendState": "Normal",
"lastTrend": 0.0,
"channelSamples": [
{
"$id": "68",
"t": 1680094317052,
"v": 346.72836303710938
},
{
"$id": "69",
"t": 1680094316059,
"v": 341.72836303710938
},
{
"$id": "70",
"t": 1680094315070,
"v": 336.72836303710938
},
{
"$id": "71",
"t": 1680094314074,
"v": 331.72836303710938
},
{
"$id": "72",
"t": 1680094313070,
"v": 326.72836303710938
},
{
"$id": "73",
"t": 1680094312067,
"v": 321.72836303710938
},
{
"$id": "74",
"t": 1680094311074,
"v": 316.72833251953125
},
{
"$id": "75",
"t": 1680094310074,
"v": 311.72833251953125
},
{
"$id": "76",
"t": 1680094309064,
"v": 306.72833251953125
},
{
"$id": "77",
"t": 1680094308079,
"v": 301.72833251953125
},
{
"$id": "78",
"t": 1680094307065,
"v": 296.72833251953125
},
{
"$id": "79",
"t": 1680094306076,
"v": 291.72833251953125
},
{
"$id": "80",
"t": 1680094305075,
"v": 286.72833251953125
},
{
"$id": "81",
"t": 1680094304074,
"v": 281.72833251953125
},
{
"$id": "82",
"t": 1680094303075,
"v": 276.72833251953125
},
{
"$id": "83",
"t": 1680094302077,
"v": 271.72833251953125
},
{
"$id": "84",
"t": 1680094301064,
"v": 266.72833251953125
},
{
"$id": "85",
"t": 1680094300069,
"v": 261.72833251953125
},
{
"$id": "86",
"t": 1680094299065,
"v": 256.72833251953125
},
{
"$id": "87",
"t": 1680094298076,
"v": 251.72834777832031
},
{
"$id": "88",
"t": 1680094297069,
"v": 246.72834777832031
},
{
"$id": "89",
"t": 1680094296065,
"v": 241.72834777832031
},
{
"$id": "90",
"t": 1680094295067,
"v": 236.72834777832031
},
{
"$id": "91",
"t": 1680094294066,
"v": 231.72834777832031
},
{
"$id": "92",
"t": 1680094293064,
"v": 226.72834777832031
},
{
"$id": "93",
"t": 1680094292072,
"v": 221.72834777832031
},
{
"$id": "94",
"t": 1680094291064,
"v": 216.72834777832031
},
{
"$id": "95",
"t": 1680094290077,
"v": 211.72834777832031
},
{
"$id": "96",
"t": 1680094289051,
"v": 206.72834777832031
},
{
"$id": "97",
"t": 1680094288050,
"v": 201.72834777832031
},
{
"$id": "98",
"t": 1680094287085,
"v": 196.72834777832031
},
{
"$id": "99",
"t": 1680091813063,
"v": 126.72834777832031
}
],
"criticity": 0
}
]
And I am trying to make it work with a Mutable Data Frame did anyone how to do this ?
Nicolas