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.
 

XML return last update value
Author
Previous Topic Next Topic
Shadevamp
Doomheim
#1 - 2012-04-12 00:18:33 UTC
I'm trying to get my spreadsheet to return the last update from XML and cant understand why it's not working :(

im using this:
Quote:
=ImportXML("http://eve-marketdata.com/api/item_prices2.xml?&type_ids="&JOIN(",",Data!B2:B16), "/emd/updated")


"Data!B2:B16" in the above code is a column with TypeIDs

information references i've found
recent uploads
http://eve-marketdata.com/developers/recent_uploads2.php

V2 code update
http://eve-marketdata.com/developers/api_moving_v1_v2.php

I'm pretty new to using XML but from what i understand i need to return the "updated" value for TypeIDs in cells B2:B16

cheers