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.
 

Google Scripts issues with API

Author
Dean Hekki
Nerapa Krabbing Industries
#1 - 2015-04-21 02:47:59 UTC
So I have a script in my google doc... the important part is:

if(xml) {
var rows=xml.getRootElement().getChild("result").getChild("rowset").getChildren("row");
for(var i = 0; i < rows.length; i++) {
order=[
parseInt(rows[i].getAttribute("typeID").getValue()),
parseInt(rows[i].getAttribute("volRemaining").getValue()),
parseInt(rows[i].getAttribute("duration").getValue()),
parseInt(rows[i].getAttribute("price").getValue()),
parseInt(rows[i].getAttribute("stationID").getValue()),]

if (rows[i].getAttribute("accountKey").getValue() == wallet & rows[i].getAttribute("orderState").getValue() === '0' & rows[i].getAttribute("accountKey").getValue() === '1000') {
orders.push(order);



anyway this outputs perfectly to a chart for me, however when I try to do a vlookup from that chart things get screwy and it returns values that at times arent even in the same row

Did I do something wrong?
Dean Hekki
Nerapa Krabbing Industries
#2 - 2015-04-21 03:23:00 UTC
oh it was me being stupid... I forgot to do false at the end of my vlookup