Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // CONFIG
- var API = "<API KEY HERE>";
- var sheetName = "Sheet1";
- var itemTable = {
- "384":"5", // Camel Plushie
- "273":"6", // Chamois Plushie
- "258":"7", // Jaguar Plushie
- "215":"8", // Kitten Plushie
- "281":"9", // Lion Plushie
- "269":"10", // Monkey Plushie
- "266":"11", // Nessie Plushie
- "274":"12", // Panda Plushie
- "268":"13", // Red Fox Plushie
- "186":"14", // Sheep Plushie
- "618":"15", // Stingray Plushie
- "187":"16", // Teddy Bear Plushie
- "261":"17", // Wolverine Plushie
- }
- function update(){
- var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName)
- var response = UrlFetchApp.fetch("https://api.torn.com/torn/?selections=items&key=" + API);
- var price = JSON.parse(response.getContentText());
- var i = 5;
- for (itemId in itemTable){
- for(listing in price.items) {
- if(itemId == listing){
- var market_val = price.items[listing].market_value;
- var name = price.items[listing].name;
- sheet.getRange("B" + itemTable[itemId]).setValue(name);
- sheet.getRange("C" + itemTable[itemId]).setValue(market_val);
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment