EVE Technology Lab

Hi all

I am trying to setup a spreadsheet where i can select an item and it will pull the pricing data from Eve Central.

I have setup a Web Query to get data from the api there eg. http://api.eve-central.com/api/marketstat?typeid=12066&usesystem=30000142 which works fine.

However following examples i have found on the internet I edited it so it looks like this. http://api.eve-central.com/api/marketstat?typeid=["TypeID", "ID"]&usesystem=30000142. I can edit the parameters of the web query and tell it to use the value of a cell for the TypeID. This is where things go a bit wrong. I get a "Data Source Not Found" error when updating the connection.

If i save the web query as a .iqy file and then use that to create a new query it works but only brings back some of the fields.

Does anyone have a working example of how to pull back data from Eve-Central with a dynamic web query that i can look at as i am going round in circles trying to get it to work.

many thanks in advance

Shuluman