Hi all!
Maybe stupid question since I’m quite noob and not beeing a programmer
I call REST api like this:
- resource: "https://api.openvehicles.com:6869/api/historical/<vehicle-id>/*-Log-Notification/?username=****&password=***"
scan_interval: 120
sensor:
- name: ev_consumption
value_template: "{{ value_json.h_data}}"
json_attributes:
- h_data
- h_timestamp
And I get:
h_data: I,Trip 20.0km Avg 28km/h Alt -12m
Energy 125Wh/km; 26% recd
SOC -2.0% = 41.5%
Range -9.4km = 188.0km
h_timestamp: 2023-01-10 06:05:06
friendly_name: ev_consumption
But the problem is that this is the oldest data (timestamp).
If I call REST api with curl, I get more data and also latest data which interests me:
curl --location --request GET 'https://api.openvehicles.com:6869/api/historical/<vehicle-id>/*-Log-Notification/?username=<username>&password=<password>'
[{"h_data":"I,Trip 20.0km Avg 28km/h Alt -12m\rEnergy 125Wh/km; 26% recd\rSOC -2.0% = 41.5%\rRange -9.4km = 188.0km\r","h_recordnumber":20670,"h_timestamp":"2023-01-10 06:05:06"},{"h_data":"I,Trip 21.0km Avg 32km/h Alt -5m\rEnergy 129Wh/km; 25% recd\rSOC +0.0% = 41.5%\rRange -0.2km = 187.8km\r","h_recordnumber":20696,"h_timestamp":"2023-01-10 06:10:19"},{"h_data":"I,Trip 23.0km Avg 34km/h Alt +11m\rEnergy 130Wh/km; 23% recd\rSOC +0.0% = 41.0%\rRange -0.2km = 185.3km\r","h_recordnumber":20721,"h_timestamp":"2023-01-10 06:18:48"},{"h_data":"A,12V Battery critical: 12.8V (ref=14.6V)","h_recordnumber":21357,"h_timestamp":"2023-01-10 08:19:47"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":21582,"h_timestamp":"2023-01-10 08:52:49"},{"h_data":"A,12V Battery critical: 12.8V (ref=14.6V)","h_recordnumber":21757,"h_timestamp":"2023-01-10 09:24:59"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":21922,"h_timestamp":"2023-01-10 09:57:10"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":22295,"h_timestamp":"2023-01-10 10:29:19"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":23608,"h_timestamp":"2023-01-10 11:01:29"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":24106,"h_timestamp":"2023-01-10 11:33:40"},{"h_data":"A,12V Battery critical: 12.8V (ref=14.6V)","h_recordnumber":24296,"h_timestamp":"2023-01-10 12:05:52"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":24485,"h_timestamp":"2023-01-10 12:38:00"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":24677,"h_timestamp":"2023-01-10 13:10:10"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":24852,"h_timestamp":"2023-01-10 13:42:22"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":25056,"h_timestamp":"2023-01-10 14:14:31"},{"h_data":"A,12V Battery critical: 13.0V (ref=14.6V)","h_recordnumber":25590,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"A,12V Battery restored: 14.4V (ref=14.6V)","h_recordnumber":25591,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"A,12V Battery critical: 12.2V (ref=14.6V)","h_recordnumber":25592,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"A,12V Battery restored: 14.0V (ref=14.6V)","h_recordnumber":25593,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":25594,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"A,12V Battery restored: 14.0V (ref=14.6V)","h_recordnumber":25595,"h_timestamp":"2023-01-10 15:50:04"},{"h_data":"I,Trip 23.0km Avg 28km/h Alt +0m\rEnergy 22Wh/km; 79% recd\rSOC -1.5% = 64.5%\rRange -6.3km = 294.9km\r","h_recordnumber":25598,"h_timestamp":"2023-01-10 15:50:28"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":25599,"h_timestamp":"2023-01-10 15:50:33"},{"h_data":"A,12V Battery restored: 13.9V (ref=14.6V)","h_recordnumber":25608,"h_timestamp":"2023-01-10 15:52:33"},{"h_data":"I,Trip 23.0km Avg 0km/h Alt +0m\rEnergy 22Wh/km; 79% recd\rSOC +0.0% = 64.5%\rRange +0.3km = 295.3km\r","h_recordnumber":25612,"h_timestamp":"2023-01-10 15:53:15"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":26238,"h_timestamp":"2023-01-10 17:52:31"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":26429,"h_timestamp":"2023-01-10 18:24:41"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":26595,"h_timestamp":"2023-01-10 18:56:51"},{"h_data":"A,12V Battery critical: 12.8V (ref=14.6V)","h_recordnumber":26616,"h_timestamp":"2023-01-10 19:00:51"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":26803,"h_timestamp":"2023-01-10 19:33:52"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":26850,"h_timestamp":"2023-01-10 20:06:02"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":26910,"h_timestamp":"2023-01-10 20:38:12"},{"h_data":"A,12V Battery critical: 12.5V (ref=14.6V)","h_recordnumber":26970,"h_timestamp":"2023-01-10 21:10:23"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":27029,"h_timestamp":"2023-01-10 21:42:33"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":27070,"h_timestamp":"2023-01-10 22:14:43"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":27115,"h_timestamp":"2023-01-10 22:46:53"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":27178,"h_timestamp":"2023-01-10 23:19:03"},{"h_data":"A,12V Battery critical: 12.3V (ref=14.6V)","h_recordnumber":27232,"h_timestamp":"2023-01-10 23:51:13"},{"h_data":"A,12V Battery critical: 12.3V (ref=14.6V)","h_recordnumber":27269,"h_timestamp":"2023-01-11 00:23:23"},{"h_data":"A,12V Battery critical: 12.3V (ref=14.6V)","h_recordnumber":27311,"h_timestamp":"2023-01-11 00:55:33"},{"h_data":"A,12V Battery critical: 12.3V (ref=14.6V)","h_recordnumber":27358,"h_timestamp":"2023-01-11 01:27:43"},{"h_data":"A,12V Battery critical: 12.2V (ref=14.6V)","h_recordnumber":27515,"h_timestamp":"2023-01-11 01:59:54"},{"h_data":"A,12V Battery critical: 12.2V (ref=14.6V)","h_recordnumber":27560,"h_timestamp":"2023-01-11 02:32:03"},{"h_data":"A,12V Battery critical: 12.2V (ref=14.6V)","h_recordnumber":27593,"h_timestamp":"2023-01-11 03:04:14"},{"h_data":"A,12V Battery critical: 12.2V (ref=14.6V)","h_recordnumber":27623,"h_timestamp":"2023-01-11 03:36:27"},{"h_data":"A,12V Battery critical: 12.1V (ref=14.6V)","h_recordnumber":27655,"h_timestamp":"2023-01-11 04:08:34"},{"h_data":"A,12V Battery critical: 12.1V (ref=14.6V)","h_recordnumber":27689,"h_timestamp":"2023-01-11 04:40:44"},{"h_data":"A,12V Battery critical: 12.1V (ref=14.6V)","h_recordnumber":27763,"h_timestamp":"2023-01-11 05:12:55"},{"h_data":"A,12V Battery critical: 12.1V (ref=14.6V)","h_recordnumber":27881,"h_timestamp":"2023-01-11 05:45:05"},{"h_data":"A,12V Battery restored: 14.3V (ref=14.6V)","h_recordnumber":27949,"h_timestamp":"2023-01-11 06:06:05"},{"h_data":"A,12V Battery critical: 12.4V (ref=14.6V)","h_recordnumber":27992,"h_timestamp":"2023-01-11 06:17:49"},{"h_data":"A,12V Battery restored: 14.4V (ref=14.6V)","h_recordnumber":27993,"h_timestamp":"2023-01-11 06:17:49"},{"h_data":"A,12V Battery critical: 12.9V (ref=14.6V)","h_recordnumber":27994,"h_timestamp":"2023-01-11 06:18:05"},{"h_data":"A,12V Battery restored: 12.0V (ref=12.6V)","h_recordnumber":28052,"h_timestamp":"2023-01-11 06:32:05"},{"h_data":"I,Trip 20.0km Avg 33km/h Alt -11m\rEnergy 85Wh/km; 43% recd\rSOC -2.0% = 71.0%\rRange -9.0km = 322.7km\r","h_recordnumber":880,"h_timestamp":"2023-01-11 15:11:56"},{"h_data":"I,Trip 21.0km Avg 28km/h Alt -17m\rEnergy 95Wh/km; 41% recd\rSOC -0.5% = 69.5%\rRange -2.7km = 315.4km\r","h_recordnumber":3324,"h_timestamp":"2023-01-12 06:16:47"},{"h_data":"I,Trip 29.0km Avg 36km/h Alt +16m\rEnergy 107Wh/km; 37% recd\rSOC -2.5% = 67.0%\rRange -12.1km = 303.3km\r","h_recordnumber":3367,"h_timestamp":"2023-01-12 06:38:27"},{"h_data":"I,Trip 37.0km Avg 33km/h Alt -19m\rEnergy 108Wh/km; 37% recd\rSOC -2.0% = 64.0%\rRange -9.8km = 289.0km\r","h_recordnumber":4001,"h_timestamp":"2023-01-12 15:03:45"},{"h_data":"I,Trip 45.0km Avg 36km/h Alt +20m\rEnergy 104Wh/km; 36% recd\rSOC -1.5% = 62.5%\rRange -7.2km = 281.8km\r","h_recordnumber":4028,"h_timestamp":"2023-01-12 15:20:09"},{"h_data":"I,Trip 54.0km Avg 37km/h Alt -20m\rEnergy 104Wh/km; 36% recd\rSOC -2.0% = 60.5%\rRange -9.6km = 272.2km\r","h_recordnumber":4100,"h_timestamp":"2023-01-12 16:05:05"},{"h_data":"I,Trip 69.0km Avg 30km/h Alt +9m\rEnergy 120Wh/km; 33% recd\rSOC -6.0% = 54.5%\rRange -29.9km = 242.3km\r","h_recordnumber":10343,"h_timestamp":"2023-01-13 06:40:09"},{"h_data":"I,Trip 77.0km Avg 37km/h Alt -30m\rEnergy 117Wh/km; 34% recd\rSOC -2.0% = 52.5%\rRange -10.2km = 232.1km\r","h_recordnumber":25561,"h_timestamp":"2023-01-13 15:12:47"},{"h_data":"I,Trip 78.0km Avg 27km/h Alt +3m\rEnergy 119Wh/km; 33% recd\rSOC -0.5% = 52.0%\rRange -3.9km = 228.2km\r","h_recordnumber":25707,"h_timestamp":"2023-01-13 15:22:29"}]
➜ /config
Is there any filter I can use to get only latest data?
Thank you for your help in advance!