There is not. If its not possible via ESI then it’s not possible in GESI.
Thanks, that helps a lot.
Great work on this, thanks for all your work.
8.0.0 aka version 23 April 21, 2020
Version 8.0.0 is now released. See the Github release for details. As always feel free to stop by the Discord server to report any issues or ask for help.
3 Likes
Hi I am unable to Authorise my character in my sheet anymore it was working fine last week.
when I type a formula I get the error: Access not granted or expired (line 454)
I have tried recreating new sheets an am getting the same error.
have you had this problem?
(also I am using a Mac if that matters?)
Did you reauthorize your character? This release changed how auth is stored so will need to redo it.
Yeah I have tried a couple of times. I also tried de-authorize and re authorising but that did not help.
I can only get the Eve log in to work if I open in a new tab?
And you get to the end where it says “Thank you for using GESI xxx”?
Some things to try:
- Make sure GESI library is up to date if you’re using custom functions and such in the script editor
- The
pageparam got removed, so anyplace you were including a-1, remove it. - If none of these help, stop by the discord server and we can figure it out.
If you’re using Firefox then yea, i added a note to the modal to say that.
1 Like
this was the problem I just needed to remove the “-1”
Thanks a lot you are always very helpful.
love the GESI!
Ray
1 Like
8.1.0 aka version 24 April 28, 2020
Version 8.1.0 is now released. See the Github release for details. As always feel free to stop by the Discord server to report any issues or ask for help.
1 Like
8.2.0 aka version 25 May 9, 2020
Version 8.2.0 is now released. See the Github release for details. As always feel free to stop by the Discord server to report any issues or ask for help.
@Blacksmoke16 Just in case you are not aware of, oauth is broken. Do you have any plans fixing it, can’t wait to start using it!
Broken how? If you mean that issue right after you install it see https://github.com/Blacksmoke16/GESI/issues/70#issuecomment-639815701.
Thanks for the prompt response. Yes, this is the one. Is there a workaround?
Did you try refreshing? Might be able to look thru the Google bug tracker for something as well.
1 Like
just checked again and now I see several menu options that weren’t there before. Seems that is working. Great!! Thanks a lot for the response and for the effort to built it.
Hello!
First of all, thanks for providing this useful tool to the community.
I have installed GESI in my Google sheets, but I am receiving an error “Result too large” when I try to use
markets_region_orders(10000002,buy,18,TRUE)
Am I missing something or is this a limit in Google Sheets?
Cheers!
This is a limit of Google Sheets. Jita just has so many orders it cannot all fit into a sheet (you hit the cell limit). Your best bet would be do some filtering in JS first, use another API that pre-aggregates the data you need (like https://market.fuzzwork.co.uk/api/), or make your application using an actual programming language.
Oh, I see; many thanks!
I am not good enough to write my own app though 
May I ask if there is a way to put the data downloaded right into an array, instead of into the cells? I think I could be able to deal with some basic scripting…
Cheers!
Yes, you would want to use the script editor. From there you could filter it down how you’d like. However there is also a request limit in sheets. TBH you would be best off getting the pre aggregated data like from fuzz’s API.
Hi.
Have a question, using “universe_ids” to resolve character IDs it works ok, but what if there two characters with the same name (1st one deleted in Doomheim corporation and 2nd one is active)
It’s always return deleted character ID 
Any advise?