Science & Industry

Hello there,

I'm using importXML with eve central quicklook api in the "new" google sheet and I have a strange issue.
I know that it is better to use javascript instead of importXML function, but I have a lack of knowledge in those kind of scripts.

My sheet works, even using a cachebuster for refreshing the data, my issue is not on the importXLM function itself or the XPath.

The problem is, after some refresh or some time, the importXML data cells are stuck on "Loading Data..." forever.
But, if I make a copy of my sheet in google drive, open this new copy, and refresh data, it works and I don't understand why.
Then same issue, after some refresh / time, I have infinite "Loading Data...".
So I make another copy and it works.... etc

Yeah you've read it, I create a new copy each time I want to refresh my data.... and I'm sick about this ^^


Is anybody know a workaround for my issue ?



Thanks for reading.

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may be of interest.

The principle is different (load all the price data you want into a different sheet, then use vlookup to get it), but it integrates pretty well.