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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page123
 

Google Docs & ImportXML woes regarding EVE-central. Pull stops working

First post
Author
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#41 - 2015-01-02 15:50:01 UTC
Sharkey Bones wrote:
Any advise for those of us using the quicklook api to sum up total volume? Here's what I was using before everything got borked on the new google docs sheets

=SUM(importXml("http://api.eve-central.com/api/quicklook?typeid="&join("&typeid=",B1)&"&usesystem=XXXXXX&refresh=" &$H$1,"//sell_orders//vol_remain"))



Not hellishly difficult, tbh. Assuming you're only ever going to want to pull the sum of sell order volume remaining,in a particular system:

https://gist.github.com/fuzzysteve/909b6a868b168e070866 is a (not very tested) way to do it.

typeid,systemID,sellbuy,cachebuster

If you don't set the 2nd attribute, it defaults to jita.
If you don't set the 3rd attribute, or set it to 1, it loads the sell volume. If it's set to anything else, then it's the buy.
The 4th is just added to the url.

=loadSystemVolume(34,30000142,0) - Jita buy vol for trit
=loadSystemVolume(34,30000142,1) - jita sell vol for trit

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

quikfingrs
Salamander Researches And Industries
#42 - 2015-01-05 14:27:19 UTC
im not sure if it is me or a slightly modified version of your script but,

when i used to do the api pull from eve central it would automatically update my sheet on the fly ( think hourly or 30mins ) with new prices and would pretty much be bob on,

since ive been using your script ive noticed that it doesn't update my script for over 2hrs at a time and some ive sat and watched for close on a hr nothing came back a hr after that and still nothing, so unsure the time interval of when it does update but im pretty sure it does update at some point in 24hrs lol,

i made a separate sheet and uploaded your new script and the first load of prices i compared them to eve-central and they were 2hrs out so its defiantly around the 2hr+ marker

i have set my triggers for the script for time driven 1hr also even set it to 15min just to see and nothing changes,

so is this how it is or has something gone pete tonge my end lol
Hiro Kaichi
Garoun Investment Bank
Gallente Federation
#43 - 2015-03-03 16:21:59 UTC
Hi, can someone help me with my spreadsheet because it was working for awhile, now it says loading indefinitely and N/A. Here is the link to the spreadsheet

https://docs.google.com/spreadsheets/d/1KyTS-EJm-61Z5fLHYFewyvEz2GMUspJv5fZbMe_FG-s/edit?usp=sharing

Thanks
Admiral MastaKilla AlphaU
Itrek Innovations
#44 - 2015-03-30 18:10:18 UTC  |  Edited by: Admiral MastaKilla AlphaU
I have a similar loading issue to the one mentioned above. This code I linked below worked fine for over a year until about a month or two ago and I still can't figure out what is the issue. Is this something on EVE Central side that is now changed? I have tried this in new spread sheets with other type id's and none of them work anymore.

=ImportXML(ʺhttp://api.eve-central.com/api/marketstat?&usesystem=30000142&typeid=ʺ& ʺ2868ʺ ,ʺ/evec_api/marketstat/type/sell/minʺ)

In short, this code above is pulling the min sell price of Integrity Response Drones from the Jita system. Does this work for anyone else using Google Docs?
Bear Templar
Sicario Combine
The Rogue University
#45 - 2015-04-03 19:55:17 UTC
Admiral MastaKilla AlphaU wrote:
I have a similar loading issue to the one mentioned above. This code I linked below worked fine for over a year until about a month or two ago and I still can't figure out what is the issue. Is this something on EVE Central side that is now changed? I have tried this in new spread sheets with other type id's and none of them work anymore.

=ImportXML(ʺhttp://api.eve-central.com/api/marketstat?&usesystem=30000142&typeid=ʺ& ʺ2868ʺ ,ʺ/evec_api/marketstat/type/sell/minʺ)

In short, this code above is pulling the min sell price of Integrity Response Drones from the Jita system. Does this work for anyone else using Google Docs?



I just copied and pasted this and after making some adjustments I got it to work.

I changed the second argument in the function to "//sell/min", and also I noticed that the URL wasn't being read properly and so I removed and then re-added all the quotation marks (on both arguments).

Mine looks like this now:

=IMPORTXML("http://api.eve-central.com/api/marketstat?&usesystem=30000142&typeid=2868", "//sell/min")

If a fish weighs 1 Kilogram plus half its own weight, how much does it weigh? (It's not 1.5kg btw)

Previous page123