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.
 

Q for those familiar with Gdocs spreadsheet and API/XML Import
Author
Previous Topic Next Topic
Strategos
Echelon Research
Goonswarm Federation
#1 - 2012-02-02 02:42:18 UTC  |  Edited by: Strategos
So I am pulling in transaction data on one sheet. The problem I am going to encounter is that it will be limited to the last 100 transactions and then the older transactions will start disappearing because gdocs limits you to 100 cells off an xml pull. What I would like to do is use another sheet to set up a function that will automatically copy the new results generated by the api pull and then paste it into a new sheet (sorted by date and exact time according to the xml) so that it keeps a permanent history of all the data that has been pulled in, not just the last 100 transactions.

Would I need to build a script for this or is it possible through a function? I've read some about journal walking but that seems more complicated then it needs to be.