Google Docs script for pulling character information from the wow API

[shadewalker]

this looks sweet! Thanks.

can iLevel for all item slots be added?

[Destahd]

I'm glad it's useful for someone(s) else.

Very nice, as I'm always loosing track of what toon is on what.

Can Professions be added to it, or does that even show up via the API?

Stephen

It can be added and it does show in the API. This is my next goal.

this looks sweet! Thanks.

can iLevel for all item slots be added?

In theory, yes, that can be added, but it would really make the script 'loud' (it also adds a whole layer of complexity for me to work out, as the API just gives item ID and name, so I'd have to figure out how to add an additional lookup to work out individual iLvl.)

Per-slot iLvl is a bit of a stretch, but I'll try to figure out how to work this out, maybe with a toggle, so it can be shown, or not, selectively.

[shadewalker]

In theory, yes, that can be added, but it would really make the script 'loud' (it also adds a whole layer of complexity for me to work out, as the API just gives item ID and name, so I'd have to figure out how to add an additional lookup to work out individual iLvl.)

Per-slot iLvl is a bit of a stretch, but I'll try to figure out how to work this out, maybe with a toggle, so it can be shown, or not, selectively.

I tinkered around with the end of the script a bit to have it look up the item id and then the item iLevel. As you mentioned, it requires an extra look up for each item. I'm not sure if there is a cleaner way to do it or not.

  //get item ids and item information
  var headId = toon.items.head.id;
  var headItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+headId)
  var headItem = Utilities.jsonParse(headItemJSON.getContentText());
  
  var neckId = toon.items.neck.id;
  var neckItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+neckId)
  var neckItem = Utilities.jsonParse(neckItemJSON.getContentText());
  
  var shoulderId = toon.items.shoulder.id;
  var shoulderItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+shoulderId)
  var shoulderItem = Utilities.jsonParse(shoulderItemJSON.getContentText()); 
  
  var backId = toon.items.back.id;
  var backItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+backId)
  var backItem = Utilities.jsonParse(backItemJSON.getContentText());  
  
  var chestId = toon.items.chest.id;
  var chestItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+chestId)
  var chestItem = Utilities.jsonParse(chestItemJSON.getContentText());
  
  var wristId = toon.items.wrist.id;
  var wristItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+wristId)
  var wristItem = Utilities.jsonParse(wristItemJSON.getContentText());  
  
  var handsId = toon.items.hands.id;
  var handsItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+handsId)
  var handsItem = Utilities.jsonParse(handsItemJSON.getContentText());  

  var waistId = toon.items.waist.id;
  var waistItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+waistId)
  var waistItem = Utilities.jsonParse(waistItemJSON.getContentText()); 

  var legsId = toon.items.legs.id;
  var legsItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+legsId)
  var legsItem = Utilities.jsonParse(legsItemJSON.getContentText()); 
  
  var feetId = toon.items.feet.id;
  var feetItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+feetId)
  var feetItem = Utilities.jsonParse(feetItemJSON.getContentText());   

  var finger1Id = toon.items.finger1.id;
  var finger1ItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+finger1Id)
  var finger1Item = Utilities.jsonParse(finger1ItemJSON.getContentText());    

  var finger2Id = toon.items.finger2.id;
  var finger2ItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+finger2Id)
  var finger2Item = Utilities.jsonParse(finger2ItemJSON.getContentText());  
  
  var trinket1Id = toon.items.trinket1.id;
  var trinket1ItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+trinket1Id)
  var trinket1Item = Utilities.jsonParse(trinket1ItemJSON.getContentText());  

  var trinket2Id = toon.items.trinket2.id;
  var trinket2ItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+trinket2Id)
  var trinket2Item = Utilities.jsonParse(trinket2ItemJSON.getContentText());   
  
  var mainHandId = toon.items.mainHand.id;
  var mainHandItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+mainHandId)
  var mainHandItem = Utilities.jsonParse(mainHandItemJSON.getContentText());  
  
  var offHandId = toon.items.offHand.id;
  var offHandItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+offHandId)
  var offHandItem = Utilities.jsonParse(offHandItemJSON.getContentText());  

  var rangedId = toon.items.ranged.id;
  var rangedItemJSON = UrlFetchApp.fetch("us.battle.net/api/wow/item/"+rangedId)
  var rangedItem = Utilities.jsonParse(rangedItemJSON.getContentText());   
  
  var toonInfo = new Array(
    toon.name,
//    "Race: "+toonRace,
//    "Class: "+toonClass,
    toon.level,
    toon.items.averageItemLevel,
    toon.items.averageItemLevelEquipped,
    headItem.itemLevel,
    neckItem.itemLevel,
    shoulderItem.itemLevel,
    backItem.itemLevel,
    chestItem.itemLevel,
    wristItem.itemLevel,
    handsItem.itemLevel,
    waistItem.itemLevel,
    legsItem.itemLevel,
    feetItem.itemLevel,
    finger1Item.itemLevel,
    finger2Item.itemLevel,
    trinket1Item.itemLevel,
    trinket2Item.itemLevel,
    mainHandItem.itemLevel,
    offHandItem.itemLevel,
    rangedItem.itemLevel
  )

      
//  Logger.log("Name: "+toon.name);
//  Logger.log("Race: "+toonRace);
//  Logger.log("Class: "+toonClass);
//  Logger.log("Level: "+toon.level);
//  Logger.log("iLvl: "+toon.items.averageItemLevel);
//  Logger.log("iLvlE: "+toon.items.averageItemLevelEquipped);
//  Logger.log("Head: "+headItem.itemLevel);

  return toonInfo;