EVE Technology Lab

So I have been messing around with importing market data from eve-central into google docs.

I know that you can for example do this:

=importXml("http://api.eve-central.com/api/marketstat?&hours=1&typeid=34&usesystem=30000142&minQ=1","//buy/max")

This would output the max buy order for tritanium in Jita

I also know you can just add more typeids into the parameters, and they will fill in the below cells:

=importXml("http://api.eve-central.com/api/marketstat?&hours=1&typeid=34&typeid=35&usesystem=30000142&minQ=1","//buy/max")

This would output trit and below that pyerite.


My question pertains to calling a group of typeid from other cells. What I want to do is have a group of typeid in a column of cells, and be able to select that somehow, and use it in the parameters.

Just using multiple typeid is workable, but it would make things much simpler if I could just have a list of typeid that I could have all of my formulas reference. The most frustrating thing is that it seems to work with the other market websites, for example I can use:

=ImportXML("http://api.eve-marketdata.com/api/importxml_prices2.xml?char_name=demo&buysell=b&type_ids="&JOIN(",",$B2:$B25); "/emd/price")

That gives me exactly what I want, but I can't seem to get it to work with eve-central (which is by far the most up-to-date). I have tried playing with it, using the JOIN command, etc. but it doesn't seem workable.

Eve-central has an (otherwise very helpful) wiki on this and it discusses POST and GET, which I thought might the eve-central equivalent of the JOIN command, but so far its a no go.

Disclaimer: I have no previous experience with XML or parameter commands, most of what I have picked up I have learned through searching the forums and the above wiki this evening. Explain it me as you would to a small child, or a golden retriever please.


The wiki I was discussing above for reference: http://dev.eve-central.com/evec-api/start

Works like a charm, thank you.