JSON Mapping | 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 | John Clutter | 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 | John Clutter | 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": "John Clutter", "customerName": "John Clutter", "customerTank": "John Clutter", "tankSize": "500", "address": "Howard Street", "town": "Cowen", "state": "WV", "postcode": "26206", "latitude": "38.4132843", "longitude": "-80.5601714", "lastReportedDate": "08/23/2021 06:39:00", "lastReportedLevel": "66", "lastDeliveryDate": "03/04/2021 14:52:00", "tankType": "Horizontal Tank", "dailyUsage": 0.0 }, { "deviceId": "618001", "serialNumber": "7542459", "customerAccount": "RDR", "customerName": "RDR", "customerTank": "Concrete Plant", "tankSize": "2005", "address": "411 Sycamore Street", "town": "Clarksburg", "state": "WV", "postcode": "26301", "latitude": "39.2861121", "longitude": "-80.3520409", "lastReportedDate": "08/23/2021 15:37:00", "lastReportedLevel": "58", "lastDeliveryDate": "08/17/2021 15:00:00", "tankType": "Diesel", "dailyUsage": 7.623467 } ] |
---|