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.
 

api contract pull
Author
Previous Topic Next Topic
Tyrion Estemaire
The Scope
Gallente Federation
#1 - 2014-04-11 01:47:36 UTC
so i have been trying to create a spreadsheet that pulls contracts useing this https://api.eveonline.com/char/Contracts.xml.aspx?characterID=xxxxx&keyID=xxxxxx&vCode=xxxxxxxxxxxxxxxxxxxxx
but is there way to also pul the items in the contracts
Rob Crowley
State War Academy
#2 - 2014-04-11 06:14:58 UTC
Tyrion Estemaire
The Scope
Gallente Federation
#3 - 2014-04-11 17:56:50 UTC
update
i now know have to use this url
https://api.eveonline.com/char/Contractitems.xml.aspx?keyID=2674674&vCode=xxxxx&characterID=xxxx&contractID=xxxxx
in google docs i use this to put contractid
=IMPORTXML("https://api.eveonline.com/char/Contracts.xml.aspx?characterID=xxxxx&keyID=xxxx&vCode=xxxx","//row/@contractid")
and this to pull status
=IMPORTXML("https://api.eveonline.com/char/Contracts.xml.aspx?characterID=xxxxx&keyID=xxxx&vCode=xxxx","//row/@status")
but is there a syntax
to filter out all other contracts that have been completed