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.
 

EVE XML API - Multiple character training expiration time [Solved]
Author
Previous Topic Next Topic
Big Chief StiffRod
Big Deuce
#1 - 2016-07-25 03:57:14 UTC  |  Edited by: Big Chief StiffRod
solved
Christmas Cheer
Doomheim
#2 - 2016-07-26 16:17:03 UTC
I would love to see the solution. Working on this myself.
Big Chief StiffRod
Big Deuce
#3 - 2016-07-30 01:07:34 UTC
Christmas Cheer wrote:
I would love to see the solution. Working on this myself.


I used this function in google sheets, just fill in with API info and it should give you a result of 1-2 cells depending on how many chars are training. It only gives you the chars that are currently on multiple training, it wont give you the main char training on the account. If you need that main char call let me know i can give it to you as well. Not 100% sure what permissions the API key needs but you should be able to look those up on the third party developer help website that gives info about calls from CCP.


=IMPORTXML("https://api.eveonline.com/account/AccountStatus.xml.aspx?keyID=&vCode=","//@trainingEnd")
David Cheal
TM Industrialists
#4 - 2016-09-09 08:10:44 UTC
Big Chief StiffRod wrote:
Christmas Cheer wrote:
I would love to see the solution. Working on this myself.


I used this function in google sheets, just fill in with API info and it should give you a result of 1-2 cells depending on how many chars are training. It only gives you the chars that are currently on multiple training, it wont give you the main char training on the account. If you need that main char call let me know i can give it to you as well. Not 100% sure what permissions the API key needs but you should be able to look those up on the third party developer help website that gives info about calls from CCP.


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


I dont want to undermine you achievement as it took me ages to get api to work but I would recommend not relying on =importXML if you're pulling a lot of api information in future as it just caves in on itself and becomes relatively buggy. But if you're only calling one thing then you'll be fine :) Just a warning as i ran into that problem.
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#5 - 2016-09-10 10:10:39 UTC
David Cheal wrote:


I dont want to undermine you achievement as it took me ages to get api to work but I would recommend not relying on =importXML if you're pulling a lot of api information in future as it just caves in on itself and becomes relatively buggy. But if you're only calling one thing then you'll be fine :) Just a warning as i ran into that problem.


*cough, importXML2, cough*