I need your help with Google Scripting. My car has a datalogger that I can access via a web interface, but the interface has authentication (user/pw). I tried to create a Google Script to 'login' into the page but alas it is not my specialty, i think part of my issue is that the login redirected to another internal page. I want to access this site and access the API : [login to view URL]
Then, I want the data to be copied into a Google Drive spreadsheet (probably using the IMPORTHTML function?) and have it refresh every 15 minutes. I will then run an IFTTT task based on the value of some parameters.
Can you help? Below is the info if you want to take a look at how to do it:
Site : [login to view URL]
user/PW will be shared, msg me.
-----
Below is an example of the data that is in the API:
{
"fleetName": "Charge the North - Eastern",
"fleetId": 624,
"vehicles": [
{
"reportId": "5040eef1-d2b5-45c3-991f-9bf1dda7dee9",
"lastDataUpdate": "2019-03-22T14:06:36Z",
"speed": null,
"maf": null,
"fuelRate": null,
"soc": 86.5,
"chargerPower": null,
"outsideTemperature": null,
"batteryPower": null,
"batteryVoltage": null,
"batteryCurrent": null,
"batteryTemperatureC": null,
"rpm": null,
"isCharging": false,
"isDriving": false,
"lastLocationUpdate": "2019-03-22T14:05:40.6Z",
"latitude": 45.573320555555554,
"longitude": -73.767056666666662,
"altitude": null,
"vehicleId": 106483,
"model": "e-Golf",
"make": "Volkswagen",
"year": 2018,
"vin": "WVWPR7AU1JW907496",
"licensePlate": null,
"unitId": null,
"identifier": "WVWPR7AU1JW907496",
"identifierWithModel": "WVWPR7AU1JW907496, (2018 Volkswagen e-Golf)",
"yearMakeModel": "2018 Volkswagen e-Golf"
}
]
}