Google spreadsheet. Imported content is empty


(Tirkibo) #1

Any idea why this doesn’t work.

I have =IMPORTXML(C2,A$24)

c2 = https://api.evemarketer.com/ec/marketstat?usesystem=30000142&typeid=16634
A24 = /evec_api/marketstat/type/sell/min

I get an #n/a as well as “Imported content is empty” message?

cheers


(Blacksmoke16) #2

Set A24 = //sell/min


(Krysenth) #3
=IMPORTXML(
CONCATENATE(
"http://api.evemarketer.com/ec/marketstat?regionlimit=10000002&typeid=",
<cell containing typeid>),
"/exec_api/marketstat/type/buy/max"
)

Getting imported content is empty could mean that there are no orders of that type available there.


(Tirkibo) #4

This worked, whats the explanation behind that?

Cheers


(Blacksmoke16) #5

The double slash says find the attribute sell/min no matter where it is in the tree, without specifying the full path.

For example if you did //min you would get two rows, one for buy and another for sell.


(Tirkibo) #6

great info.

Thanks


(Krysenth) #7

Well, if what’s in the OP is a direct copypasta as well, you typo’d in the spreadsheet. /evec_api/ vs /exec_api/


(system) #8

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