These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Pull data not working anymore
Author
Previous Topic Next Topic
Jake Rake
Rattini Tribe
Minmatar Fleet Alliance
#1 - 2013-06-07 06:48:25 UTC
Before the Odyssey patch, I had some Google docs market spread sheets that pulled data so I dint have to have all the :effort: to calculate stuff myself. They are not working anymore tho, so I wonder if any of you can help me out with the debugging. Unfortunately I'm such a n00b in programming, so I can't debug it myself.

This is the a string:

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&Join("&typeid=",22291)&"&usesystem=30000142&minQ=10000&hours=11","//buy/max")

where typeid is the objects ID and usesystem is which system i pull the price from. In this case its the price for Ballistic Control System II in Jita.

Can anyone help?
Zappity
New Eden Tank Testing Services
#2 - 2013-06-07 08:28:11 UTC
You are pulling from eve-central so probably not Odyssey. I just checked my Google docs and they are updating fine from eve-central.

Sorry, not good enough to debug on my phone. Sure your query didn't change? Try another item ID.

Zappity's Adventures for a taste of lowsec and nullsec.
Jake Rake
Rattini Tribe
Minmatar Fleet Alliance
#3 - 2013-06-07 08:39:16 UTC
Zappity wrote:
You are pulling from eve-central so probably not Odyssey. I just checked my Google docs and they are updating fine from eve-central.

Sorry, not good enough to debug on my phone. Sure your query didn't change? Try another item ID.


I've tried with new IDs but those are broken as well.
Any chance I can have a peak at your sheet? Cool
Zappity
New Eden Tank Testing Services
#4 - 2013-06-07 08:57:35 UTC
=importXml("http://api.eve-central.com/api/marketstat?&hours="& $A$1 &"&typeid="&JOIN("&typeid=",$A3:$A115)&"&usesystem="& D1 &"","/evec_api/marketstat/type/sell/percentile")

Hours is static at A1, system in D1 and I use a join column for multiple itemID lookups.

Zappity's Adventures for a taste of lowsec and nullsec.
Jake Rake
Rattini Tribe
Minmatar Fleet Alliance
#5 - 2013-06-07 09:50:05 UTC
Thx, I managed to solve it with you help.
I'm most grateful, and Big smile
Zappity
New Eden Tank Testing Services
#6 - 2013-06-07 10:03:31 UTC
Big smile

Zappity's Adventures for a taste of lowsec and nullsec.