6609HiRK

1// CONFIG
2var API = "<API KEY HERE>";
3var sheetName = "Sheet1";
4var itemTable = {
5  "384":"5",  // Camel Plushie
6 "273":"6",  // Chamois Plushie
7 "258":"7",  // Jaguar Plushie
8 "215":"8",  // Kitten Plushie
9 "281":"9",  // Lion Plushie
10 "269":"10", // Monkey Plushie
11 "266":"11", // Nessie Plushie
12 "274":"12", // Panda Plushie
13 "268":"13", // Red Fox Plushie
14 "186":"14",  // Sheep Plushie
15 "618":"15", // Stingray Plushie
16 "187":"16", // Teddy Bear Plushie
17 "261":"17", //  Wolverine Plushie
18}
19function update(){
20  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName)
21  var response = UrlFetchApp.fetch("https://api.torn.com/torn/?selections=items&key=" + API);
22  var price = JSON.parse(response.getContentText());
23  var i = 5;
24  for (itemId in itemTable){
25    for(listing in price.items) {
26      if(itemId == listing){
27        var market_val = price.items[listing].market_value;
28        var name = price.items[listing].name;
29        sheet.getRange("B" + itemTable[itemId]).setValue(name); 
30        sheet.getRange("C" + itemTable[itemId]).setValue(market_val); 
31      }
32    }
33  }
34}