Tirkibo
(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
Krysenth
(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
(Tirkibo)
4
This worked, whats the explanation behind that?
Cheers
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
Krysenth
(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/
system1
(system)
Closed
8
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.