Field | Example | i21 Field | Notes |
---|
deviceId | 618000 | Not Used |
|
serialNumber | 7534188 | TM > Site > Device > Tank Monitor Serial # | Matching Hierarchy #1 this is first to check. - Device Type = Tank Monitor
- Device Serial # matches to file
- Device Linked to a Site
If no match then try Matching Hierarchy #2. |
customerAccount | 12430655 | TM > Site > Customer | Matching Hierarchy #2 - Site with Customer # that Matches API > customerAccount
- Device Linked to Site
- Device Type = Tank
- Device Serial # matches API > customerTank
If no match then give errors that no match was found. |
customerName | John Clutter | Not Used |
|
customerTank | 1361978 | TM > Site > Device > Tank Serial # | Part of Matching Hierarchy #2 see customerAccount |
tankSize | 500 | NA | Should already be setup on TM Site > Tank Device |
address | Howard Street | Not Used |
|
town | Cowen | Not Used |
|
state | WV | Not Used |
|
postcode | 26206 | Not Used |
|
latitude | 38.4132843 | TM > Site > Latitude | Will be used to Update TM Site if there is no existing value |
longitude | -80.5601714 | TM > Site > Longitude | Will be used to Update TM Site if there is no existing value |
lastReportedDate | 08/23/2021 06:39:00 | TM > Site > Reading Event > Event Date | Will ignore adding duplicate readings |
lastReportedLevel | 66 | TM > Site > Estimated % Left TM > Site > Estimated Gallons Left |
Use Estimated % Left x TM Site > Total Capacity to get Estimated Gallons Left |
lastDeliveryDate | 03/04/2021 14:52:00 | Not Used |
|
tankType | Horizontal Tank | Not Used |
|
dailyUsage | 0.0 | Not Used |
|
Sample JSON with 2 records:
[
{
"deviceId": "618000",
"serialNumber": "7534188",
"customerAccount": "12430655",
"customerName": "John Clutter",
"customerTank": "1361978",
"tankSize": "500",
"address": "Howard Street",
"town": "Cowen",
"state": "WV",
"postcode": "26206",
"latitude": "38.4132843",
"longitude": "-80.5601714",
"lastReportedDate": "10/04/2021 06:39:00",
"lastReportedLevel": "65",
"lastDeliveryDate": "03/04/2021 14:52:00",
"tankType": "Horizontal Tank",
"dailyUsage": 0.028571
},
{
"deviceId": "618001",
"serialNumber": "7542459",
"customerAccount": "63150005",
"customerName": "RDR Energy Resources Inc.",
"customerTank": "Concrete Plant",
"tankSize": "2005",
"address": "411 Sycamore Street",
"town": "Clarksburg",
"state": "WV",
"postcode": "26301",
"latitude": "39.2861121",
"longitude": "-80.3520409",
"lastReportedDate": "10/03/2021 15:37:00",
"lastReportedLevel": "54",
"lastDeliveryDate": "10/01/2021 15:00:00",
"tankType": "Diesel",
"dailyUsage": 13.54483
}
]