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