GESI Versions Save

Google Sheets™ ESI Add-on

9.2.1

7 months ago

9.2.1 aka version 50 September 22, 2023


Fixes

9.2.0

1 year ago

9.2.0 aka version 48 July 13, 2022


ESI Updates

9.1.1

2 years ago

9.1.1 aka version 44 April 1, 2022


Fixes

  • Do not exclude comments when pushing to GAS
    • Restores the @customfunction and jsdoc comments to each function

9.1.0

2 years ago

9.1.0 aka version 43 March 30, 2022


Additions

  • GESI now has a good amount of proper unit test coverage on its core logic
  • Validates the aud JWT claim is the required value

Fixes

  • Properly handle falsey arguments to optional parameters
    • Handles the context of like =corporations_corporation_wallets_division_transactions(2,,"Blacksmoke16") throwing an error saying from_id should be a number but got string

9.0.0

2 years ago

9.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.

Changes

  • (breaking) Changed how authentication data is stored (again)

    • Sheet Storage concept has been removed
    • Access token is now stored in cache instead of with the rest of the auth data
      • Accounted for 92% of the total size of auth data, moving that allows for more characters to be authed in general
  • (breaking) Function arguments are now validated to be of the proper type.

    • E.g. an error will be raised if you give a string to a function expecting a number, or if a function expecting an array of strings, does not contain only strings.
    • May need to ensure you're passing properly type arguments
  • NPM dependencies have been bumped to address some security vulnerabilities

    • Nothing was relevant to GESI

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.5.0

2 years ago

8.5.0 aka version 39 September 15, 2021


ESI Updates

8.4.1

2 years ago

8.4.1 aka version 38 August 25, 2021


Fixes

  • Better support for passing standard 1D arrays to GESI parameters expecting arrays when using them in custom functions

8.4.0

2 years ago

8.4.0 aka version 37 March 30, 2021


ESI Updates

  • Various ESI version updates not yet currently listed on the changelog
    • See this commit for the full list of changes

8.3.0

3 years ago

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.


Additions

  • Adds an Enable Sheet Auth Storage menu option to support an alternative auth storage mechanism for handling large amounts of characters

Changes

  • Update README and other administrative items to support new script editor and GSP project

Fixes

  • Better support Firefox
    • No longer need to do the right click, open in new tab workaround

ESI Updates

8.2.0

4 years ago

8.2.0 aka version 25 May 9, 2020


Additions

Changes

  • Exposes the ESIClient for advanced users