//simple Check Prices script to display server name, item name, and average price
function doPost(e) {
var postdatacontents = JSON.parse(e.postData.contents)
var ss = SpreadsheetApp.openByUrl('urltospreadsheethere')
var sheetnum = 0;
var sheet = ss.getSheets()[sheetnum];
sheet.clear();
var averagePrice = 0;
var itemname = "";
var server = postdatacontents.Server;
sheet.getRange(1, 1).setValue(server); //set server name at A1
var itemexists = false;
const numberOfItemsToCheck = 10; //this can really be anything as it won't check NULL items, but setting it too high will slow down the script.
for (var c = 0; c < numberOfItemsToCheck; c++)
{
itemexists = false;
eval('if (null != postdatacontents.Item_' + (c+1).toString() + ') { itemexists = true; }');
if (itemexists)
{
eval('itemname = postdatacontents.Item_' + (c+1).toString() + '.Name; averagePrice = postdatacontents.Item_' + (c+1).toString() + '.Average_Price;');
sheet.getRange(c+2, 1).setValue(itemname);
sheet.getRange(c+2, 2).setValue(averagePrice);
}
}
return ContentService.createTextOutput('Success');
}