Google spreadsheet. Imported content is empty

EVE Technology and Research Center Third Party Developers
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

2

Set A24 = //sell/min

1 Like
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.

4

This worked, whats the explanation behind that?

Cheers

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.

1 Like
6

great info.

Thanks

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/

8

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