nhorquender

Untitled

Sep 24th, 2019
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. // CONFIG
  2. var API = "<API KEY HERE>";
  3. var sheetName = "Sheet1";
  4. var 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. }
  19. function 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. }
Add Comment
Please, Sign In to add comment