Field | Example | i21 Field | Notes |
---|
deviceId | 618000 | Not Used |
| serialNumber | 7534188 | TM > Site > Device > Tank Monitor Serial # | Matching Hierarchy #1, this is the 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 Used to Update TM Site if there is no existing value | longitude | -80.5601714 | TM > Site > Longitude | Will be used 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 } ] |