Help with spreadsheet script

Help with spreadsheet script

in API Development

Posted by: Mel.8769

Mel.8769

Hi. I am trying to learn how to use the API in a script in Google spreadsheets. My goal is to pull the current trading post sell price of an item from the API into a cell in the spreadsheet. I am a novice and this is my first attempt at any sort of programming/scripting/etc… Needless to say it is not working. :P I would greatly appreciate help from you more experienced community members. Thanks!

Script I am using:
http://pastebin.com/s0T7RTj5

Using the function =Test(itemID) in spreadsheet cell
Ex: =Test(19723) for the price of green wood log

Common sense is a flower that doesn’t grow in everyone’s garden. -Unknown