Hi all,
I’m wondering if anyone can help me with google spreadsheet script and the gw2 price api.
I have a script set up to pull the prices through the api. The script runs just fine when activated manually. However, when I set up a timed based trigger, the script fails.
[15-03-16 20:29:16:984 EDT] UrlFetchApp.fetch([http://api.guildwars2.com/v2/commerce/prices/12138]) [59.919 seconds]
[15-03-16 20:29:16:984 EDT] HTTPResponse.getContentText() [0 seconds]
[15-03-16 20:29:16:988 EDT] Execution failed: SyntaxError: Empty JSON string (line 34, file “Code”) [60.485 seconds total runtime]
Anyone have any idea on what’s wrong here?