EVE Technology Lab

Hi Everyone;

Been a bit, however i'm back working on my corp spreadsheet, and i'm back to hit a couple quick questions to help me understand what's going on.

1. My ImportXML calls to eve-central seem to really lag and time our often, it will call the data abit slowly if i make a change to the call, however it seems to time out and then i get NA's all over the place. I'm wondering is this a failure on Google Sheets, or are thre just too many calls to EVE Central, and it's getting over loaded?

2. I have not yet played with ESI much, however i'm not abject to giving it a spin if it accomplishes what i'm looking for, I'm on board with moving from google sheets to a full on web application if ESI calls will get me what i need. So I guess tthe question here is two fold.

a) Can ESI call System specific Market Data? IE Max Sell or Min Buy on say a specific item or items such as PI commodities?

b) Is it more stable than google sheets with importXML? or is ESI a mess like CREST ?



// Start fuzzworks brown nosing moment

So it's important for me here to tell Steve that I love the EVE central website, and all the data that is being provided, and if I move away from it, it's in now way a discredit to the amazing service Steve continues to offer the community.

// end moment


Thanks for the input in advance.

1) iirc gsheet have a max requests/seconds, so this might be the reason

2a) for current price, you can't. You'll have to get the data (which is region wide) and then filter (in google scripts or in the sheet itself) the data you want/don't want.

2b) Imho ESI is far more stable and reliable than CREST, but it's different than just importXML (unless there's a importJSON) ?