# GESI MemberID

**URL:** <https://forums.eveonline.com/t/gesi-memberid/75474>\
**Category:** Third Party Developers\
**Created:** [May 10, 2018, 5:40pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474 "2018-05-10T17:40:04Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mellanie\_Donier](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mellanie_donier/32/71904_2.png) [@Mellanie\_Donier](https://forums.eveonline.com/u/Mellanie_Donier)\
**Post date:** [May 10, 2018, 5:40pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/1 "2018-05-10T17:40:05Z")

</div>

Does someone know the Line to get the Corporation Member IDS to names ?

=HLOOKUP(“name”; universe\_types\_type(“en-us”; INDIRECT(ADDRESS(ROW(); 12)); TRUE); 2; FALSE)

does not work.

Help would be nice, thanks

---

<div class="post-metadata">

**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 10, 2018, 6:15pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/2 "2018-05-10T18:15:34Z")

</div>

Is there an error or? It might be due to ESI being down/wonky due to the DDoS attack.

---

<div class="post-metadata">

**Author:** ![Mellanie\_Donier](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mellanie_donier/32/71904_2.png) [@Mellanie\_Donier](https://forums.eveonline.com/u/Mellanie_Donier)\
**Post date:** [May 10, 2018, 7:22pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/3 "2018-05-10T19:22:49Z")

</div>

Error #REFF “Out of bound Range” and no its not because of the DDoS attack.  
And the command i posted did convert : type\_id to name . i am now looking for the GESI Command to convert Member\_ID to name .

Thanks for your reply

---

<div class="post-metadata">

**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 10, 2018, 8:32pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/4 "2018-05-10T20:32:25Z")

</div>

Could use a custom function like

```auto
function corpMembers(name) {
  var member_ids = corporations_corporation_members(name,false);
  var members = [];
  
  eachSlice_(member_ids, 100).forEach(function(m) {
    members = members.concat(characters_names(m.join(','),false));
  });
  
  return members
}

```

Then use it like `=corpMembers()`

---

<div class="post-metadata">

**Author:** ![Mellanie\_Donier](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mellanie_donier/32/71904_2.png) [@Mellanie\_Donier](https://forums.eveonline.com/u/Mellanie_Donier)\
**Post date:** [May 11, 2018, 4:59am UTC](https://forums.eveonline.com/t/gesi-memberid/75474/5 "2018-05-11T04:59:28Z")

</div>

added your code to the function.gs at the bottom.

getting this error now :

Error  
ReferenceError: “eachSlice\_” is not defined. (line 2039).

Did i miss something?

## --------EDIT 2------ is it also not possible to add a funtion to endpoints.gs to get name and not the id ?

Thanks

---

<div class="post-metadata">

**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 11, 2018, 12:04pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/6 "2018-05-11T12:04:53Z")

</div>

OO my bad, there was another function required for this:

```auto
function eachSlice_(array, size){
  var arr = []
  for (var i = 0, l = array.length; i < l; i += size){
    arr.push(array.slice(i, i + size))
  }
  return arr
};

```

No, ESI corp member list endpoint only returns IDs of the characters.

---

<div class="post-metadata">

**Author:** ![Mellanie\_Donier](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mellanie_donier/32/71904_2.png) [@Mellanie\_Donier](https://forums.eveonline.com/u/Mellanie_Donier)\
**Post date:** [May 11, 2018, 12:23pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/7 "2018-05-11T12:23:43Z")

</div>

Yes. It shows ids and names now. Can i marry you 🙂

Thank you

P.S. Would be good if you add those two functions to funtion.gs for all to have 😛

---

<div class="post-metadata">

**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 11, 2018, 1:29pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/8 "2018-05-11T13:29:24Z")

</div>

No, GESI is just a method of getting data from ESI into Sheets. What the user’s do with it is up to them. I don’t want it to become something that has a bunch of user specific features.

I could maybe make another file that would be optional that i could put common things tho…I’ll have to think about it.

---

<div class="post-metadata">

**Author:** ![Mellanie\_Donier](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mellanie_donier/32/71904_2.png) [@Mellanie\_Donier](https://forums.eveonline.com/u/Mellanie_Donier)\
**Post date:** [May 11, 2018, 1:49pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/9 "2018-05-11T13:49:35Z")

</div>

Please think anout it and Thanks again 🙂  
Good Hunting and Good Weekend

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [August 9, 2018, 1:49pm UTC](https://forums.eveonline.com/t/gesi-memberid/75474/10 "2018-08-09T13:49:37Z")

</div>

Closed on August 9, 2018, 1:49pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.