# \[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:** 6
**Author:** ![BornToRiseHell](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/borntorisehell/32/65715_2.png) [@BornToRiseHell](https://forums.eveonline.com/u/BornToRiseHell)\ **Post date:** [April 12, 2018, 9:39am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/103 "2018-04-12T09:39:17Z")
Really thanks for that reply. I don’t know what I was doing before but I got errors even with my main character. I then found out that I might have been slightly dumb and not putting my chars in " " and trying to call industry jobs on a character that didn’t have any. It works now with multiple characters. Thanks a lot for the help and your patience 🙂 ---
**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:** [April 12, 2018, 11:59am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/104 "2018-04-12T11:59:56Z")
👍 np ---
**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:** [April 12, 2018, 9:14pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/105 "2018-04-12T21:14:01Z")
**[5.3.0](https://github.com/Blacksmoke16/GESI/releases/tag/5.3.0)** April 12, 2018 * * * ## Additions - `universe_asteroid_belts_asteroid_belt` - Added error message when a character is not authed or is misspelled - Added usage tip to readme for using functions with multiple characters ## Changes - `system_id` added to `markets_region_orders` - `asteroid_belts` added to `planets` object in response from `universe_systems_system` ---
**Author:** ![Shogun\_Mizoe](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/shogun_mizoe/32/401512_2.png) [@Shogun\_Mizoe](https://forums.eveonline.com/u/Shogun_Mizoe)\ **Post date:** [April 24, 2018, 9:24pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/106 "2018-04-24T21:24:37Z")
How to use the parseArray function to get the average daily volume of say “5MN Y-T8 Compact Microwarpdrive” in The Forge for the last 180 days? I know how to use the “markets\_region\_history” endpoint to pull the market history, but I want to be able to parse that lookup get get the average traded volume. IE… My list of item id’s are in Column A, and in say Column C, I want it so show the average traded volume in The Forge over the last 180 days? I used to use Nuadi’s (GCES) “getaveragedailyvolume” function for this purpose, I want to be able to mimic that. ---
**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:** [April 25, 2018, 2:12am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/107 "2018-04-25T02:12:05Z")
That isn’t what `parseArray` is for. `parseArray` is for for columns that contain an array of objects. For example column 1 of `characters_character_skills` Notice how all the data is contained within that one cell vs being row by row like other endpoints. You would then call `=parseArray("characters_character_skills", "skills", A1)` to parse that cell’s value into the row by row listing you are used to. ---
**Author:** ![Shogun\_Mizoe](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/shogun_mizoe/32/401512_2.png) [@Shogun\_Mizoe](https://forums.eveonline.com/u/Shogun_Mizoe)\ **Post date:** [April 25, 2018, 4:45am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/108 "2018-04-25T04:45:52Z")
Thanks for the reply. ---
**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:** [April 28, 2018, 9:24pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/109 "2018-04-28T21:24:15Z")
**5.4.0** April 28, 2018 * * * ## Additions - alliances\_alliance\_contacts\_labels - corporations\_corporation\_contacts\_labels ## Changes - characters\_character\_wallet\_journal (v3 -\> v4) - corporations\_corporation\_wallets\_division\_journal (v2 -\> v3) ## Removals - characters\_character\_chat\_channels ---
**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:** [May 1, 2018, 6:21am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/110 "2018-05-01T06:21:46Z")
Hey guys, just wanted to give you a heads up on the new features coming with the next major release of GESI. This is going to be a major rewrite of my backend tooling, the script i use to generate the files. However this _should_ not change any of the core behavior of GESI, i.e. method names will remain the same and such. I am going to make it a major update to `6.0.0` as there most likely will be changes to the order/number of params of the functions which would break current apps. I am planning on adding the source code and an executable that can be used to generate the files with to the repo, this will allow more technical users to have more control over the data, such as being able to easily add/remove function parameters, change the versioning of the GESI file, such as dev or legacy (as of now GESI is based purely off of `/latest/` ESI endpoint versions), or maintain the script if i ever cannot. This will also allow those who are so inclined to possibly add additional code to the file generations if they wanted to include specific things. For now this update is still a few weeks at most away, but I wanted to get some feedback on if there is anything specific that would be useful for you guys. Feel free to post here or message me on discord. ---
**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:** [May 1, 2018, 7:41pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/111 "2018-05-01T19:41:38Z")
Smoke, I upgraded today and note this: In the corporations\_corporation\_industry\_jobs the column “product\_type\_id” is returning the Blueprint ID which is a duplicate of Column “blueprint\_type\_id” Also, for purposes of doing things like easy left-to-right vLookups, populating the left-most columns with columns such as Blueprint ID and Type ID is super helpful. Ken ---
**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:** [May 1, 2018, 7:45pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/112 "2018-05-01T19:45:20Z")
Only one request: to the extend possible try to enumerate what functions we’ll need to alter in our own code: ie…the return order of columns will be something I need to attend to. ---
**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:** [May 1, 2018, 8:53pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/113 "2018-05-01T20:53:24Z")
> [@KenFlorian](#): > > I upgraded today and note this: In the corporations\_corporation\_industry\_jobs the column “product\_type\_id” is returning the Blueprint ID which is a duplicate of Column “blueprint\_type\_id” Was this job a copy/research job? Do remember that GESI is just generated code from ESI, so if this is an actual bug it would have to be taken up with the esi-issues repo. > [@KenFlorian](#): > > Also, for purposes of doing things like easy left-to-right vLookups, populating the left-most columns with columns such as Blueprint ID and Type ID is super helpful. Ill look into it if i can make the main identifiers be put first by default, but since this is generated there is only so much i can do. > [@KenFlorian](#): > > Only one request: to the extend possible try to enumerate what functions we’ll need to alter in our own code: ie…the return order of columns will be something I need to attend to. Assuming by this mean you `look to see what changed so i dont have to redo everything`. You can already do this by looking at the git diff, which should be a lot cleaner now that the endpoints will always be in a specific order. Example: [April 6 ESI updates · Blacksmoke16/GESI@26e9091 · GitHub](https://github.com/Blacksmoke16/GESI/commit/26e90917365bf98e0b869c1fb5d8c717620e5315) ---
**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:** [May 1, 2018, 11:25pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/114 "2018-05-01T23:25:24Z")
Ignore for now…looking further but I think I’m incorrect. ---
**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:** [May 4, 2018, 3:42am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/115 "2018-05-04T03:42:17Z")
**5.5.0** May 3, 2018 * * * ## Changes - Update BASE\_URL to new host of ‘[https://esi.evetech.net](https://esi.evetech.net)’ ---
**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:** [May 10, 2018, 12:49am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/116 "2018-05-10T00:49:40Z")
GIT diff will do the trick. ---
**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:** [May 23, 2018, 2:49am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/117 "2018-05-23T02:49:45Z")
**5.6.0** May 22, 2018 * * * ## Changes - Update characters\_character\_killmails\_recent to use pagination. - Update corporations\_corporation\_killmails\_recent to use pagination. ---
**Author:** ![Plaguies](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/plaguies/32/427774_2.png) [@Plaguies](https://forums.eveonline.com/u/Plaguies)\ **Post date:** [May 25, 2018, 9:13am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/119 "2018-05-25T09:13:58Z")
So i dont the whole tutorial everything worked. i authorized my character but then i have a blanket google sheet. There is nothing. shouldnt it write in all the informations from the esi in the colums / rows ? i have a second tab in the spredsheet auth data where my 2 characters for testing are imported. but i dont have anything anywhere else. no skill Q informations nothing! ---
**Author:** ![Bartholomeo\_Korsikan](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bartholomeo_korsikan/32/441652_2.png) [@Bartholomeo\_Korsikan](https://forums.eveonline.com/u/Bartholomeo_Korsikan)\ **Post date:** [May 25, 2018, 11:11am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/120 "2018-05-25T11:11:38Z")
Big and great work!!! Thanks !!! I don’t find a function to return all buy-order for all regions for one item. So, I think I need to write it. How can be the structure of such function? Thanks ---
**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:** [May 25, 2018, 12:23pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/121 "2018-05-25T12:23:35Z")
You need to call the corresponding function to get the data, it just doesn’t magically show up for you. For example to get skill queue you would use `=characters_character_skillqueue()` a full list can be found [HERE](https://github.com/Blacksmoke16/GESI/blob/master/function.gs) ---
**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:** [May 25, 2018, 12:28pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/122 "2018-05-25T12:28:33Z")
You would have to use `=markets_region_orders()` set the `order_type` to “buy” and use the `-1` page param, then iterate over each region ID. Just know this probably won’t work due to the 30 sec runtime limit for custom functions in Google Scripts. Probably better off reducing the scope to maybe just the regions you need. ---
**Author:** ![Bartholomeo\_Korsikan](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bartholomeo_korsikan/32/441652_2.png) [@Bartholomeo\_Korsikan](https://forums.eveonline.com/u/Bartholomeo_Korsikan)\ **Post date:** [May 25, 2018, 12:30pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/123 "2018-05-25T12:30:00Z")
Thanks for your help [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=5) [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=7)