[7.6.0 - version 12] GESI - Google Sheets ESI Add-On - Update install instructions

Blacksmoke,

I’ve been using the function you coded for me for a NPC and it’s worked great. I now want to use it for a specific structure. Here’s what I’ve got…identical to your function except for the endpoint…but it’s returning only a single value. Must be more to this than meets the eye. If you got a couple minutes, great. If not, I’ll keep poking around until I get it!

function typePriceDataStructure(location_id) {
var data = GESI.markets_structures_structure(location_id);
var minSell = Number.POSITIVE_INFINITY;
var maxBuy = 0;
var result = ;

data.forEach(function(order) {
if (order[3] === location_id) {
if (order[1]) {
if(order[6] > maxBuy) {
maxBuy = order[6];
}
} else {
if(order[6] < minSell) {
minSell = order[6];
}
}
}
});
return [[minSell, maxBuy]];

I’m not sure what you’re trying to do here? As it stands this method is just iterating over the first page of orders within the provided structure. Since this endpoint is not limited to a specific type, this function isn’t really helpful. You would want to also pass in a type_id and check that order[8] === type_id, so that you limit the minSell and maxBuy to that type. You should also use -1 as the page param to make sure you are getting all pages of orders.

I’m kind of lost here. There is a guide posted to the dev blogs just a few weeks ago with a notice that this is all already out of date. A few replies above you link to something you call ‘examples’ but this is just a changelog with no examples that I can find. Can someone please link current examples to get us started. I want to just execute a script that imports all my wallet transactions for a period of time.

@Aynder Just follow the setup guide, then type =characters_character_wallet_transactions() in a cell.

Feel free to join the discord server if you need more help.

Also just to clarify. That blog post was made over a year ago for when GESI was not an add-on. The update saying it is now out of date is more so related to the first 60% of it that dealt with installing it. As back then you had to create a dev application, copy files over etc versus now where you just install the add-on. The functionality towards the bottom is the same, however the specific examples prob wont work as the order the response columns and function parameters have changed since it was made.

I updated the install instructions in the readme as it should be installed via sheets not the marketplace (unless you want to enable it for everyone in your organization i guess).

In sheets: Go to Add-Ons => Get add-ons => Search for GESI, and click the + Free.

1 Like

Bump because I don’t want the thread to get locked.

1 Like