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.
 

having proble with this formulas on Google Sheet
Author
Previous Topic Next Topic
Astrid Farnsworth
Broke and Famous
#1 - 2017-01-22 03:53:20 UTC
This is one: =IFERROR(WEBSERVICE("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID="&B3&"&vCode="&C3),"")

This is the second one: =IFERROR(WEBSERVICE("https://api.eveonline.com/account/Characters.xml.aspx?keyID="&B3&"&vCode="&C3),"")

when i add them to google sheet they generate an error that i can figure out whats bad on them.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Astrid Farnsworth
Broke and Famous
#2 - 2017-01-22 04:14:24 UTC
Looks like the command should be something like this"

=IMPORTXML("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID="B3"&vCode="C3",")

Where of course B3 is where the keyid is and C3 where vCode is. But I still get the error.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Blacksmoke16
Resilience.
#3 - 2017-01-22 04:39:17 UTC
Think you are missing some & signs, try this:

=IMPORTXML("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID="&B3&"&"&"vCode="&C3,")
Astrid Farnsworth
Broke and Famous
#4 - 2017-01-22 05:03:52 UTC
Blacksmoke16 wrote:
Think you are missing some & signs, try this:

=IMPORTXML("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID="&B3&"&"&"vCode="&C3,")



I dont think you have the right number of " .

This command should show as result Alpha or Omega but is not.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Blacksmoke16
Resilience.
#5 - 2017-01-22 05:47:50 UTC
This works, just have to put in your xpath to get what element you want.

=IMPORTXML("https://api.eveonline.com/account/accountStatus.xml.aspx?keyID="&N1&"&"&"vCode="&O1,"XPATH_HERE")
Astrid Farnsworth
Broke and Famous
#6 - 2017-01-23 01:15:20 UTC
I dont know why when i add the formula its adding one extra ") to the end.

https://puu.sh/tw3ia/904e26234a.png

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Blacksmoke16
Resilience.
#7 - 2017-01-23 01:24:54 UTC
You have no xPath.

Make it like, and can change the paidUntil to get what element text you want.

=IMPORTXML("https://api.eveonline.com/account/accountStatus.xml.aspx?keyID="&N1&"&"&"vCode="&O1,"//paidUntil")
Astrid Farnsworth
Broke and Famous
#8 - 2017-01-23 01:38:47 UTC
ok sorry to bug you so much and thank a lot to try help me.

I have this other command thats I think its wrote bad.

=IMPORTXML(D3,"/eveapi/result/paidUntil")

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Samuel Sachs
#9 - 2017-01-23 03:09:37 UTC  |  Edited by: Samuel Sachs
Because i had a bit work with i like to share it, take a look here and hopefully you enjoy what you see Big smile

SheetMon_V2

Any problems let me know Blink

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Astrid Farnsworth
Broke and Famous
#10 - 2017-01-23 11:59:31 UTC
Gonna try it when I get home. Thanks @Samuel Sachs

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**