=importxml Gives answer #N/A

[Rikard Nilsson]

Ohoi there!

My problem is the following, we are trying to compile a big spreadsheet. When we do import Veldspar we get it to show just fine in the spreadsheet, but after a while it gives the answer #N/A any ideas about this?

Code we use is

=importxml("http://api.eve-central.com/api/marketstat?typeid=1230&typeid=17470&typeid=17471&usesystem=30000142&minQ=1","//marketstat/type/sell/min")

And remember, is does not appear immediatly it takes between 20-60min before the error occurs.

Thanks 

/ DrD

[Rikard Nilsson]

Solved it, thanks anyway

[Elisaro Kado]

I think I'm running into the same issue, would you mind sharing your solution?

[Dan Conia]

You might try putting "https" in front instead of just "http". This seems to have worked for me.....so far. :)