When using the =characters_character_skills(charName) function, the output is split into three columns - Skills, Total SP, Unallocated SP. All of the skills returned appear unformatted in the same cell in the "Skills" column instead of appearing spread out down the whole column. I'm not sure if this is intentional but it hinders the usefulness of the function.

Possibilty to not get the header with the itemTypes request (Column Names)

I am trying to authorize characters:

Steps:
-go to add-on tab>GESI>authorize characters
-the EVE login window shows up I log select char>window closes and new tab pops saying:

"Thank you for using GESI Darkmift. You can close this tab."

I close said tab>return to spreadsheet>nothing happens....click add on>GESI and its asking to authorize again.

I will not be surprised if Im doing something wrong.

I would appreciate your help.
Thank you.

After ESI got an Update and some Endpoints like character_names and others have to be migrated into the '/v2/universe/names/' scope now, GESI is missing a replacement for this.

One temporary workaround was Blacksmoke´s idea with this code snippet:

/**

• Resolve a set of IDs to names and categories. Supported ID’s for resolving are: Characters, Corporations, Alliances, Stations, Solar Systems, Constellations, Regions, Types.
• @param {array} The ids to resolve.
• @return List of id/name associations for a set of ID’s.
• @customfunction
  */
  function names(ids) {
  var data = doRequest_(BASE_URL + '/v2/universe/names/', 'POST', null, ids.map(function(id) { return id[0]; }));
  var response = [];
  data.data.forEach(function(d) {
  var temp = [];
  temp.push(d['id']);
  temp.push(d['name']);
  response.push(temp);
  });
  return response;
  }

But sadly this is not working if single cell conent want to be used, it is only working for a "range" of values.

A Solution would be nice to see :-)

I might be doing something wrong, but trying to authorize a charecter gives the following error:
The coordinates or dimensions of the range are invalid. (line 290, file "gesi", project "GESI")

I just installed the addon and clicked on authorize charecters

When I enter any of my accounts into the authorization portal it works fine. But my friends get this error after selecting their characters: You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit. (line 257, file "gesi", project "GESI")
Is there a way to allow them to use my sheet I shared with them without need them to make their own copies? (I assume the making their own private copy may fix the issue)

Would it be possible to make a new function or modify this one to do a few things, first enumerate the corporationObservers() function then dump the corporationObserverMining() to ALL observer IDs, and ideally specify a date-range in the output? Ideally also doing lookups for the Refinery name, and character name from their respective IDs.
That would be sweet.

=markets_region_history() returns the error after the 7.4.0 patch if no character is Authed

TypeError: Cannot call method "getCell" of null. (line 262).

Do you have a plans to add POST requests to ESI, like a /v2/universe/names/ ?

https://esi.evetech.net/ui/#/Universe/get_universe_system_kills

Full line should read:

Get the number of ship, pod and NPC kills per solar system within the last hour ending at the timestamp of the Last-Modified header, excluding wormhole space. Only systems with kills will be listed

If you set headers to false in any function that has getarrayobjectresponse instead of getobjectresponse, there is no output at all. For instance, the skillQueue function.

Here is my test path to reproduce.

=universe_systems_system(31001688, en-us, true)

The planets cell has unparsed data.

[{"planet_id":40438381},{"planet_id":40438382},{"planet_id":40438383},{"planet_id":40438384},{"moons":[40438386],"planet_id":40438385},{"moons":[40438388],"planet_id":40438387},{"moons":[40438390,40438391],"planet_id":40438389},{"moons":[40438393],"planet_id":40438392},{"moons":[40438395,40438396,40438397,40438398,40438399,40438400,40438401,40438402,40438403,40438404,40438405,40438406,40438407,40438408,40438409,40438410,40438411,40438412,40438413],"planet_id":40438394},{"moons":[40438415,40438416,40438417,40438418,40438419,40438420,40438421,40438422,40438423,40438424,40438425,40438426,40438427,40438428,40438429,40438430,40438431,40438432,40438433,40438434,40438435,40438436,40438437,40438438,40438439],"planet_id":40438414},{"moons":[40438441,40438442,40438443,40438444,40438445,40438446],"planet_id":40438440},{"moons":[40438448,40438449,40438450,40438451,40438452,40438453,40438454,40438455,40438456,40438457,40438458,40438459,40438460,40438461,40438462,40438463,40438464,40438465],"planet_id":40438447}]

I'm not sure if I understand it 100% correctly if there should be a planets column and a moons column etc. But hopefully, this is enough to explain the issue.

I wasn't sure if It was meant to be Client ID or Script ID in the third bulletin, but It appears to also represent step 5 instead of step 4.

{"body":"{"error":"Not found"}","code":404,"path":"https://esi.evetech.net/v1/characters/affiliation/","sheet_id":"1-TfHicMlu-qoH5om1454hJbEC12RqIJKnjuGtz8aE2Q","character":null} (line 291, file "gesi", project "GESI")

universe_ids is not returning ID data for the supplied names.

When I run the following

function testFunc() {
var all_sheets = SpreadsheetApp.getActiveSpreadsheet();
var test_sheet = all_sheets.getSheets()[0]
data = GESI.universe_ids(['pyerite', 'catalyst'])
for (var i = 0; i < data.length; i++) {
test_sheet.appendRow(data[i]);
}
}

I get the following output:

Directly using https://esi.evetech.net/ui/ gives the expected values.

The expected values would include the ID information for Pyerite and Catalysts. Instead, this is returning a single row through some logic I really don't understand.

The method for this endpoint is getting overridden by the POST version of the same name. This is causing the request to fail due to not having the required scope to send mail.

using the "corporations_corporation_assets" function with page = -1, the error 'Internal error when executing the custom function.' is reported in the cell. My corporation usually has more than 20 pages (25, 28). Some advice?

Hello,

after playing arround with alliance id function and my tries to get the names from them i run into an issue.

For example, at this moment eve has 3009 alliance ids and the function can call them all, fine so far, but then when i try to get the names for them with the function =allianceNames() i have to insert a range, the problem is as soon the value of alliances increases over 3009 i get this error message https://i.imgur.com/RKV3EOp.png

Obviously the function can not identify the range from where to where an id is existing automaticly in the collumn, so i tried to use a workaround using =ArrayFormula(MAX(IF(A3:A<>"";ROW(3:3500)))) to get the number of the last row with an alliance id and then my options are not much because i can not whrite the code to change the function that way it can identify the last cell in the collumn with an alliance id.

Would be nice to make it happen your script can do this automaticly and this for other functions too, to avoid the hassle to run into this kind of limitations or problems.

Next thing i saw is if i want to get the alliance corporations it returns only the corporation ids but not the names so i whrote this function in the way i am able to:
`
/**

• Resolve a set of alliance corporation IDs to alliance corporation names
• @param {boolean} opt_headers Default: True, Boolean if column headings should be listed or not.
• @return Returns a list of id/name associations.
• @customfunction
  */
  function corporationNames(corporation_ids, opt_headers) {
  if (!corporation_ids) throw 'A range of corporation ids is required';
  return getArrayObjectResponse_(arguments.callee.name, '', opt_headers, {corporation_ids: corporation_ids});
  }
  `

This way i can get the names up to 100 corporations from the ids but as you remember the issue with calling the names for alliances the limmitations bringing the problem if an alliance has more then 100 corporations like goons or some others, so the function to load "Chunks" is needed.

Then it would be nice to be able to get the members from a corporation, this function is not existing at this moment, but would be greate to use for also hopefully soon introduced functions for the mining ledger esi calls to identify members and get some kind of statistics and the abillity to compare the lists from people who mined and get fetched with the observer fuction, i hope i explained this correct so u can understand.

So theese things are more QOL things then real issues but this can make the script more usable and user friendly.

Best Regards,

Samuel

After some time the "GESI" entry in the menu just disappears, Instead there's a dropdown menu called "Script Center Menu" with the only entry "Read Data".

Clicking on "Read Data" doesn't seem to do anything.

All functions simply return "FALSE" without any error message.

When calling =allianceNames() from alliance_ids it seems it has a hard limit on the url lenght, not sure if google is giving out this limit or the api itself but its not possible to call more then 100 for me.

The same occurs when using =corporationNames() from corporation_ids to get the names, i whrote my own part for this and it came up with the same issue, i called the goon id and they have more then 500 corporations, but calling more then 100 was also giving back url length error.

Regards Samuel

universe_types_type

loyalty_stores_corporation_offers does not include a param for corporation_id.

Will be fixed in 7.0.0.

Work around for now:

Replace the loyalty_stores_corporation_offers object in endpoints.gs with:

"loyalty_stores_corporation_offers": {
    "description": "Return a list of offers from a specific corporation's loyalty store",
    "headers": [
      {
        "name": "ak_cost"
      },
      {
        "name": "isk_cost"
      },
      {
        "name": "lp_cost"
      },
      {
        "name": "offer_id"
      },
      {
        "name": "quantity"
      },
      {
        "name": "required_items",
        "sub_headers": [
          "quantity",
          "type_id"
        ]
      },
      {
        "name": "type_id"
      }
    ],
    "method": "GET",
    "path": "/v1/loyalty/stores/{corporation_id}/offers/",
    "parameters": [
      {
        "description": "An EVE corporation ID",
        "in": "path",
        "name": "corporation_id",
        "type": "number",
        "required": true
      },
      {
        "description": "Default: true, Boolean if column headings should be listed or not.",
        "in": "parameters",
        "name": "opt_headers",
        "type": "boolean",
        "required": false
      }
    ],
    "summary": "A list of offers"
  },

and the function in functions.gs with

/**
 * Return a list of offers from a specific corporation's loyalty store
 * @param {number} corporation_id (Required) An EVE corporation ID
 * @param {boolean} opt_headers  Default: true, Boolean if column headings should be listed or not.
 * @return A list of offers
 * @customfunction
 */
function loyalty_stores_corporation_offers(corporation_id, opt_headers) {
  if(!corporation_id) throw 'corporation_id is required';
  return parseData_('loyalty_stores_corporation_offers',{corporation_id:corporation_id,opt_headers:opt_headers})
}

When I try to load any data through characters_character_industry_jobs or characters_character_assets.

Even when I try to "refresh" token allowing again a user I got this error message :

SyntaxError: Unexpected token: < (ligne 308, fichier "gesi", projet "GESI")

it's french, ligne mean line, fichier => file and projet => project.

Thanks :)

Can't log in with Google account. This is preventing users from adding GESI as an add-on to Google Sheets.

Hi !
I try to use your script, but i have an issue !
i follow all the step and all is ok, but, when i click on the link in the side panel, the new page show this code :

{"error":"invalid_scope","error_description":"The requested scopes either don't exist, or are not valid for this client"}

Thank you.

Hi! Whenever I try to install GESI, I get the following error:

"Sign in with Google temporarily disabled for this app

This app has not yet been verified by Google in order to use Google Sign in."

I tried to call =characters_character_mining( and got this:
https://i.imgur.com/wbVE03z.png
https://i.imgur.com/SSXQ1yg.png

Having issues with multiple users on the same sheet.

I can auth as many characters/accounts as I want, and they all run fine, however if someone else (who isn't the owner of the sheet) attempts to do the same, it never auths, even though it says it has successfully authed. As I said, if he copies the sheet, reauths, it runs fine.

Some endpoints are public and can take arbitrary character/corporation/alliance ids, vs that of the authing character.

Hi,

any idea why i get for any function error 400
https://login.eveonline.com/oauth/token.
{"error":"invalid_request","error_description":"Refresh token is missing."}.

???

Best Regards

While inside the script editor, I get an error stating "We're sorry, a server error occurred. Please wait a bit and try again.". If I run a function on the spreadsheet cells, with GESI calls in the script, it returns an internal error. This has started happening today.

So there used to be the option to modify the header ordering in endpoints, but this was removed from the readme with the migration to an add-on from the pure google-script implementation, do I have to manually copy and paste the scripts as in the paste to override the header ordering, or is this just not possible anymore?

I'm trying to modify which headers are optional and which are returned by default when opt_headers is False.
Just upgraded from v5.7

As per the read me it doesn't seem there is a +Free button any longer. It only gives the option to "Install" when trying to install i get the following error.

https://i.imgur.com/z9ReYGz.png

This function seems to output the headers but thats it. No adjustment to the variables gives any data.

endpoints.gs is tossing a Syntax error on line 9081 now when you try to save the updated code on Google Scripts, looks like it may just be an extra bracket at the end? Seems to save fine and work properly if removed.

Happens on characterAssets, and prob other ones with pagination.

Happens when no data is in that page AND opt_headers is false.

When using a function without an authed character it throws the error Cannot call method "getDataRange" of null.

Hi

when i use =universe_systems_system(,Q3,true)
i have an error than i havent yesterday

ESI response error: {"error":"Invalid 200 response: 'star_id' is required","code":500} (ligne 202).

value in Q3 : 30000142

The corporations_corporation_alliancehistory and characters_character_corporationhistory need corporation_id and character_id params respectively. Otherwise they will always be in relation to the main character not the character/corporation it is given.

Hi. I have a few custom functions that piggyback off of GESI. I recently upgraded from an old version of GESI, where the auth information (i.e., the refresh tokens), was stored in Properties. By way of background, I have about 115 characters authed.

The goal of my scripts is to get the skill queue, attributes, and trained skills for each of my 115 characters, and then output them to a sheet. So for each character, I call the API three separate times. In the old version of GESI, where the auth data was stored in Properties, the entire script took about ~150 seconds to run, since getting the auth data for each character is significantly quicker from Properties than it is from the Auth Data spreadsheet.

In the new version of GESI, those same scripts take almost 2x as long to run, since for each call to the API, GESI reads the auth information from the Auth Data spreadsheet. So for each of the three GESI functions I am using, each function makes a separate call to the Auth Data sheet. Multiply that by 115 characters and im sure you can see the problem. As im sure you are aware, reading the auth data from a spreadsheet is significantly slower than calling that same information from properties.

As a result, the same scripts which executed in 150 seconds in the old version of GESI now take twice as long to execute in the new. Often I hit the execution time limit. Is there a way to reduce the amount of calls to the Auth Data sheet when running multiple functions? Perhaps storing the information from the Auth Data spreadsheet in Properties as well, and then using that information from Properties to make the API calls? Anything to reduce the amount of calls to the Auth Data spreadsheet when running multiple functions for the same character would be appreciated.

Whenever using the market_structures_structure function it always returns an error with the description, "ESI response error: Market access denied (line 249)". This is regardless of structure ID used, or any other variables in use. The plugin has been set up as per the instructions listed on the main page.

The characterPlanetsDetail function call is returning the following error: "TypeError: Cannot read property "planet_id" from undefined. (line 1080)."

I've tried to provide the first parameter in the function call as an actual number: 12345678 and as a cell based upon the results of a characterPlanets call.

If I hard code a planet_id value (12345678) between line 850 and 851, the function characterPlanetDetails starting at line 1322 has a parameter planet_id value of: {planet_id=1.2345678E7}

Perhaps the conversion to scientific notation is causing the error?

As stated in the title, despite have an authorized character, an error occurs when calling some functions:
Error: No characters have been authenticated. Visit Add-ons => GEST => Authorize Character to do so. (line 100)

Also, the following error occurs whenever GESI.markets_region_orders is called:
Error: {id} is not authed, or is misspelled. (line 102)
where {id} is the type_id passed to GESI.markets_region_orders.

Include /markets/prices and /markets/structures/{structure_id}/ possible but not necessary include the maximum buy and minimum sell price for a specific item or range

Instructions say to replace a value 'SCRIPT_ID' in one of the javascript files.

"Go to File -> Project Properties and copy the Script ID. Update the SCRIPT_ID variable towards the top with your copied value."

There is no SCRIPT_ID value in any of the files.

Looks like google might have shadowbanned the addon. I can't add it to my sheets because a weird window pops up:

It appears you need to go through a validation step to make sure your addon isn't scraping people's google account info.

https://esi.tech.ccp.is/latest/#!/Wallet/get_characters_character_id_wallets

I followed the GESI readme but My spreadsheet couldn't use GESI functions . I am not sure the GESI script had loaded.
Is there any way to confirm？The page of Script Editor is blank.

When fetching all contracts available to a corporation using the following command:

=corporations_corporation_contracts("characterName",-1)

The -1 option fetches all pages EXCEPT the first page. I believe that the -1 option is supposed to fetch all pages.

I'm trying to use GESI according to the walkthrough here: https://developers.eveonline.com/blog/article/using-esi-with-google-sheets but I keep getting prompted that I'm missing a ; (semicolon) before the statement on line 8 of the GESI file. Is there a fix for this? I don't understand coding at all so I don't want to accidentally break something.