If you made it so far, the Google Apps Script which I have called “Jaguar InControl API” will now run, and download your trips to the “Jaguar InControl Trips” Sheet. You can at any time remove access to this solution in your Google Account if you regret that you gave the authorization. "Allow" Jaguar InControl API to access your Google Account. Click on the "Go To Jaguar InControl API (unsafe)" linkĥ. Google App Scripts Authorization (unsafe) warning. Google App Script: This App Isnt Verified Warning. Google App Scripts Authorization: Choose Accountģ. Google App Scripts: Authorization Required - Review PermissionsĢ. Click on the “Play Button” where the Green Arrow is pointing.Īs mentioned, Google will throw some “red flags and warnings” at you in the authorization process the first time.ġ.Make sure that “AuthJaguarInControlApi” where the Red Arrow is pointing is selected.Don’t worry, you don’t have to do any coding. You will now be revealed to the Google Apps Script that I have written.From the Menu, choose “Tools -> Script editor”.Running the Jaguar InControl Script for the First Time If this for some reason doesn’t work, try a value from the Online UUID Generator. The script I have written will create a random X-Device ID if you leave this field empty. The Jaguar InControl API needs something called an X-Device ID. In the “Overwrite Data” settings field, choose “Yes” the first time you run the scripts. I explain under the headline “How to Download your Trip Data on a Daily Basis (or more often)?”, how you can get more than 3 months of data (if only 3 months is returned). The first time you run the “Jaguar InControl API” script, choose a “Trip Count” number high enough to download at least 3 months of data. Sometimes I get 3 months of data, sometimes I get more. The “ Trip Count” field defines how many rows of data that should be downloaded from the Jaguar InControl API. In the “Settings” Sheet, fill in “Username” & “Password” from your Jaguar InControl account. This is the sheet you should use for reporting and analysing your own trip data. Here we do some calculations and add some more data, based on the data in the “Jaguar InControl Trips API Data” sheet.You can ignore this sheet and hide it if you like. Data from the Jaguar InControl API is saved to this sheet.Open the “Jaguar InControl Trips Sheet example”.Open the Google Sheets example, and make a Copy Maybe – one day – I will share a solution for this as well. That is a different part of the Jaguar InControl API. Although this is much information, detailed information like all the waypoints for each trip will not be downloaded. The reward you will get for going through all these steps, is that you will get 50+ columns of data about your Jaguar InControl Trips. I don’t collect any of your data. I will see if I can get those warnings fixed. Google will throw some “red flags & warnings” at you in the process, since you will have to authorize the script that connects to the Jaguar InControl API. There are unfortunately quite a few steps you have to go through to download your Jaguar InControl Trips to Google Sheets. Script now uses less time in fetching trips and writing trips to Google Sheet.ĭownload your Jaguar InControl Trips to Google Sheets, a Step-by-Step Guide Improved effeciency of the script that is fetching trips.Added support for selecting the correct Jaguar if you have more than 1 car.Added possibility to calculate a more correct Average Consumption.Improved “removeDuplicates” from the Google Apps Script.Moved calculations from the Google Apps Script to a seperate Sheet.Here you get a Google Data Studio Dashboard that let you analyze and visualize your own Jaguar I-Pace Trips.Analyze your Jaguar I-Pace trips in Google Data Studio.
My jaguar incontrol code#
In this blog post I share my Google Sheets solution, and explain how you can download your own Jaguar InControl trips to Google Sheets automagically. When I learned that someone had Reversed Engineered the Jaguar InControl API, I thought it would be fun to see if I could connect Google Sheets to the API, and download the trips from my Jaguar I-Pace for my own analysis and visualization.
0 kommentar(er)
