Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Astrid Farnsworth
Broke and Famous
8
|
Posted - 2017.01.22 03:53:20 -
[1] - Quote
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
8
|
Posted - 2017.01.22 04:14:24 -
[2] - Quote
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.
43
|
Posted - 2017.01.22 04:39:17 -
[3] - Quote
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
8
|
Posted - 2017.01.22 05:03:52 -
[4] - Quote
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.
43
|
Posted - 2017.01.22 05:47:50 -
[5] - Quote
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
8
|
Posted - 2017.01.23 01:15:20 -
[6] - Quote
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.
43
|
Posted - 2017.01.23 01:24:54 -
[7] - Quote
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
|
Posted - 2017.01.23 01:38:47 -
[8] - Quote
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
11
|
Posted - 2017.01.23 03:09:37 -
[9] - Quote
Because i had a bit work with i like to share it, take a look here and hopefully you enjoy what you see
https://drive.google.com/open?id=1f4pqHau3wJGvV86DOBYNayCYIIi33FO5SqECJflD6cQ
Any problems let me know
SheetMon_V2
|
Astrid Farnsworth
Broke and Famous
8
|
Posted - 2017.01.23 11:59:31 -
[10] - Quote
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**
|
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |