Google Sheets™ ESI Add-on
9.2.1 aka version 50 September 22, 2023
aud
JWT token claim format as per https://github.com/esi/esi-docs/pull/77
fuzzworks.co.uk
to urlFetchWhitelist
9.1.0 aka version 43 March 30, 2022
aud
JWT claim is the required value=corporations_corporation_wallets_division_transactions(2,,"Blacksmoke16")
throwing an error saying from_id
should be a number but got string9.0.0 aka version 42 March 26, 2022
Version 9.0.0
deprecates the concept of Sheet Storage in favor of a custom properties store implementation. GESI now supports ~1,400 authenticated characters out of the box. This update also makes GESI 100% compliant with the possible refresh token rotation cut over in the future as outlined here. Previously sheet storage would NOT have handled that correctly.
(breaking) Changed how authentication data is stored (again)
(breaking) Function arguments are now validated to be of the proper type.
NPM dependencies have been bumped to address some security vulnerabilities
Since the logic related to auth has changed, you will need to reauthorize your characters. Be sure to reset your sheet beforehand as well. From within your sheet Extensions => GESI => Reset
.
Due to this issue, if you experience Your Login session has expired
when trying to authorize a character, see this FAQ item.
8.4.0 aka version 37 March 30, 2021
8.3.0 aka version 36 January 18, 2021
This version has been live for quite some time. Given there hasn't been any reported issues I think it's finally time to make it official.
Enable Sheet Auth Storage
menu option to support an alternative auth storage mechanism for handling large amounts of characters/characters/{character_id}/stats/
8.2.0 aka version 25 May 9, 2020
ESIClient
for advanced users