# \[10.0.0 - version 52\] GESI - Google Sheets ESI Add-On - Now an EVE Online Partner! **URL:** \ **Category:** Third Party Developers\ **Tags:** esi, tool\ **Created:** [August 3, 2017, 10:59pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406 "2017-08-03T22:59:11Z")\ **Posts on this page:** 20\ **Page:** 8
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [July 15, 2018, 7:04pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/144 "2018-07-15T19:04:03Z")
@Chani_El_zrya Are you sure? Seems fine to me. ![image](https://global.discourse-cdn.com/eveonline/original/3X/e/d/eded91fcbd11248f5bf773336cff95a1eca3fe98.png) ---
**Author:** ![Chani\_El\_zrya](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/chani_el_zrya/32/320962_2.png) [@Chani\_El\_zrya](https://forums.eveonline.com/u/Chani_El_zrya)\ **Post date:** [July 15, 2018, 7:08pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/145 "2018-07-15T19:08:32Z")
Yep Using : =markets\_region\_orders(buy,10000002,1,1230,TRUE) ![image](https://global.discourse-cdn.com/eveonline/original/3X/c/4/c47f590778bf1f2ada822fbb7cd769445b258f63.png) ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [July 15, 2018, 7:09pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/146 "2018-07-15T19:09:04Z")
What do you have in the cell to get this? What version of GESI are you on? ---
**Author:** ![Chani\_El\_zrya](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/chani_el_zrya/32/320962_2.png) [@Chani\_El\_zrya](https://forums.eveonline.com/u/Chani_El_zrya)\ **Post date:** [July 15, 2018, 7:09pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/147 "2018-07-15T19:09:55Z")
=markets\_region\_orders(buy,10000002,1,1230,TRUE) GESI code downloaded 3 days ago ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [July 15, 2018, 7:10pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/148 "2018-07-15T19:10:25Z")
Order type needs to be a string, you just have `buy` needs to be `"buy"` ---
**Author:** ![Chani\_El\_zrya](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/chani_el_zrya/32/320962_2.png) [@Chani\_El\_zrya](https://forums.eveonline.com/u/Chani_El_zrya)\ **Post date:** [July 15, 2018, 7:14pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/149 "2018-07-15T19:14:35Z")
Aaaaaarrrgh. 😏 Thanks you. I was not getting any error, so i supposed it was working as intended. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [July 15, 2018, 7:15pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/150 "2018-07-15T19:15:09Z")
That field is optional in the ESI request. So you were giving it an invalid option so it was falling back to default of “all”. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 6, 2018, 12:03am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/152 "2018-08-06T00:03:59Z")
**6.5.0** August 5, 2018 * * * ## Changes - Fixes the data type of the `opt_headers` param ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 14, 2018, 2:20pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/153 "2018-08-14T14:20:34Z")
Which version of ESI do you use for GESI? _Poll ([view on site](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/153))_ ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 25, 2018, 3:04am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/154 "2018-08-25T03:04:10Z")
**7.0.0 aka version 1** August 24, 2018 Version 7.0.0 brings about a major rewrite of GESI to both make it easier to setup, but also to maintain. ## Highlights - An actual add-on - Now written in TypeScript - Implemented cacheing - Better readme - Much much easier to setup - Logging GESI is now installed via an official Google Sheet add-on. Installation is as easy as installing the add-on, then authing your characters. No more copying files, no more setting up dev apps. Updates come automatically as well. * * * ## Additions - `contracts_public_bids_contract` - `contracts_public_items_contract` - `contracts_public_region` ## Changes - Add `corporation_id` param to `loyalty_stores_corporation_offers` ([#35](https://github.com/Blacksmoke16/GESI/issues/35)) - Fix an error when using the `characters_character_mail` among others ( [#34)](https://github.com/Blacksmoke16/GESI/issues/34) - Fix inability to parse deep nested JSON ([#33](https://github.com/Blacksmoke16/GESI/issues/33)) ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [August 25, 2018, 2:47pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/155 "2018-08-25T14:47:09Z")
It goes nearly without saying but this code set is smokin’. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [August 25, 2018, 2:50pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/156 "2018-08-25T14:50:46Z")
Any suggestions on smoothest upgrade process? ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 25, 2018, 2:52pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/157 "2018-08-25T14:52:18Z")
install it on a clean sheet and setup what you had before. Will have to reauth your chars, but other than that everything else should work the same. But do make sure it isnt being used on a sheet with the old setup, the old code will override the add-on. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [August 25, 2018, 2:57pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/158 "2018-08-25T14:57:29Z")
Fair enough and thanks! For me this might need to be a “someday” project because of how much I’ve bulilt on it but I’ll take a look as soon as I can. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 25, 2018, 3:04pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/159 "2018-08-25T15:04:03Z")
In theory you could just 1. Install the add-on 2. Make a copy of your sheet 3. Delete the script tied to that sheet 4. Reauth your chars 5. Done But would have to give it a go. EDIT: Of course if you have custom functions keep the script tied to the copied sheet, just remove all the GESI stuff. Will also have to add GESI as a library, details are for that are in the readme. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [August 25, 2018, 3:14pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/160 "2018-08-25T15:14:28Z")
I love Named Ranges and I cannot lie…a couple dozen. But the caching will likely be worth the effort since I have done the inelegant “multiple calls on a tab” method in a few tabs. I’ll let the thread know what I find. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [August 27, 2018, 11:00pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/161 "2018-08-27T23:00:44Z")
Generally seems to have worked except…I changed the return column order on a couple of functions. example: characters\_character\_assets so that it returns type\_id in the left-most column to make vlookups easier. Short of getting into the actuaTypeScript code and making it “my own”, is there any other way to alter the return order? ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [August 27, 2018, 11:59pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/162 "2018-08-27T23:59:53Z")
Not by default, it returns the data in the same order as ESI returns it. If you _really_ want it done you could create a custom function wrapping it that just returns the data in a diff order. But is up to you. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [September 6, 2018, 1:05am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/163 "2018-09-06T01:05:48Z")
**7.1.0 aka version 2** September 5, 2018 * * * ## Additions - `refreshToken` Ability to refresh the token of a given character. Useful for custom function logic. - `getRawData` Returns the raw JSON data and headers from the ESI request. For example: ```auto var params = {page: 4}; var rawData = GESI.getRawData("universe_types", params); ``` It takes the string name of the function you want data from, as optionally an a param object. You can see what params the given function uses by finding it in functions.ts. The return value is an object with a data property, which is the raw JSON from the ESI request, and a headers property which includes the headers from the request (if you wanted to use X-Pages to do other requests to get all the pages for example). ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [September 7, 2018, 1:57pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/164 "2018-09-07T13:57:56Z")
**7.1.1 aka version 3** September 7, 2018 * * * ## Changes - Fix `ReferenceError: "name" is not defined. (line 80, file "gesi", project "GESI")` when trying to set a new main character or auth for the first time [Previous page](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406.md?page=7) [Next page](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406.md?page=9)