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.
 

Xpath Weirdness
Author
Previous Topic Next Topic
Miss Negotiatrix
Science and Trade Institute
Caldari State
#1 - 2015-08-21 22:09:37 UTC
So is anything weird going on with the eve api? I have an excel sheet thats been working for a week now suddenly give me #value errors where I try to get info from the eve api when I changed nothing

my eve central xmls work fine, just not the eve ones
Miss Negotiatrix
Science and Trade Institute
Caldari State
#2 - 2015-08-21 22:18:55 UTC  |  Edited by: Miss Negotiatrix
heres an example that just randomly quit working


=IF(OR(D10="",$A$1<>1),"",IFERROR(FILTERXML(WEBSERVICE(CONCATENATE(eveAPI1,EveAPI2MarketOrder,EveAPI3stuff2,EveAPI4CharID2)),"/eveapi/result//row[@typeID= '"& ItemList!B2 &"' ][@orderState= '0' ]/@price"),0))


when I put together the website myself and pull out the iferror and if(or stuff I get a #value error like there is something wrong with my xml path but it worked just fine yesterday
Miss Negotiatrix
Science and Trade Institute
Caldari State
#3 - 2015-08-22 01:52:06 UTC
I checked it in an xpath checker and my xpath is fine, its like excel suddenly stopped reading it, so confusing
Hel O'Ween
Men On A Mission
#4 - 2015-08-22 11:18:46 UTC
Miss Negotiatrix wrote:

=IF(OR(D10="",$A$1<>1),"",IFERROR(FILTERXML(WEBSERVICE(CONCATENATE(eveAPI1,EveAPI2MarketOrder,EveAPI3stuff2,EveAPI4CharID2)),"/eveapi/result//row[@typeID= '"& ItemList!B2 &"' ][@orderState= '0' ]/@price"),0))


Shouldn't the part ...

/eveapi/result//row

... read ...

/eveapi/result/rowset/row

EVEWalletAware - an offline wallet manager.
Miss Negotiatrix
Science and Trade Institute
Caldari State
#5 - 2015-08-22 18:10:05 UTC
I just tried switching it and it still wont work... its confusing cause this did work for like a week perfectly and then suddenly it wont