EVE Technology Lab

var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&regionlimit="+regionID+"&typeid=";

var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&usesystem="+regionID+"&typeid=";

Alphae wrote:

Quote:

bah! I wrote a response. Then the forum ate it

I'll rewrite in a while.

Anyway, the 2048 error is as you're trying to pull too much at once.

http://stackoverflow.com/questions/8495687/split-array-into-chunks may work, for splitting it up, into multiple chunks. you want to break up cleanTypeIDs into chunks of, say, 100 entries.

The vlookup may be down to a text/number thing. Do you have a parseInt around the typeid in the function?

I don't have the necessary knowledge to use the split array into chunks method, If you could give me a concrete example ? I'll try digging into it.

The Vlookup thing : I tried to change the format of cells into numbers, text, nothing works. I don't have parseInt around the typeid in the function, i don't know what it is, would that help ?

Quote:

If you are referencing a sheet with a space in the name then you must wrap the name inside quotation marks (it's either ` ' or " I can't remember exactly but one of those 3). It's best to simply keep all your sheet names without spaces in them so just rename price load to PriceLoad instead.

I renamed the sheet, it's not working either.

var price=[parseInt(rows[i].getAttribute("id").getValue()),

function loadPrices(priceIDs,locationID,cachebuster){
// priceIDs = [[35],[36],[37]];
  if (typeof locationID == 'undefined'){ 
    locationID=10000002; // default region is The Forge
  }
  var str = locationID.toString();  // is region or system, throw if neither
  var strScope = str.substr(0,1);
  if(strScope=="3")
    var scope = "usesystem=";
    else
      if(strScope=="1")
        var scope = "regionlimit=";
        else
          throw 'Invalid locationID';
  
// no typeIds specified
  if (typeof priceIDs == 'undefined'){
    throw 'need typeids';
  }
  if (typeof cachebuster == 'undefined'){
    cachebuster=1;
  }

// define some arrays and base uri
  var prices = new Array();
  var dirtyTypeIds = new Array();
  var cleanTypeIds = new Array();
  var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&"+scope+locationID+"&typeid=";
  
  if(typeof priceIDs === 'number')  // check for single number typeID
    dirtyTypeIds.push(priceIDs);
    else
  if(!Array.isArray(priceIDs))        // check for invalid input
    throw 'Invalid typeID(s)';
  else
  priceIDs.forEach (function (row) {  // So must be a range reference or array
    dirtyTypeIds.push(row);
    row.forEach ( function (cell) {
      if (typeof(cell) === 'number' ) {
        dirtyTypeIds.push(cell);
       }
     });
   });
  
  cleanTypeIds = dirtyTypeIds.filter(function(v,i,a) {
    return a.indexOf(v)===i;
  });

  var parameters = {method : "get", payload : ""};
  var xmlFeed = UrlFetchApp.fetch(url+cleanTypeIds.join(","), parameters).getContentText();
  var xml = XmlService.parse(xmlFeed);
  
  var prices = new Array;
  
  if(xml) {
    var rows=xml.getRootElement().getChild("marketstat").getChildren("type");
    for(var i = 0; i < rows.length; i++) {
      var price=[rows[i].getChild("sell").getChild("percentile").getValue(),
                 rows[i].getChild("buy").getChild("percentile").getValue(),
                 rows[i].getChild("sell").getChild("volume").getValue(),
                 rows[i].getChild("buy").getChild("volume").getValue()];
      prices.push(price);
    }
  }
  return prices;
}