LinkedIn
Twitter
" I am sending e.postData.Contents concatenated with your code, and I am getting the following where undefined is output for data.Task."
Maybe it's just late, but that sentence doesn't make any sense to me.
------------
"You mean that the array isn't coming through at all? If that was the case, e.postData.contents would have been blank. Or perhaps I have missed your point completely."
I mean that you built "Task" as an array in your Bot:
But the content you said you were getting did not have an array in it:
When I was testing, I struggled first and wrote out typeof results to a gSheet to see what I was getting.
What do you get for
typeof e.postData.contents <= I got "string"
typeof JSON.parse(e.postData.contents) <= I got "object"
?
And just to make sure, this is my test Webhook settings for comparison
Basically all default values..
I was curious, so I ran a little test of my own.
If you have not figured this out, here are my results.
function doPost(e) {
const sh = ss.getSheetByName('test');
const contents = e.postData.contents;
sh.getRange(sh.getLastRow() + 1, 1).setValue(contents); //This shows the whole JSON object
try {
const j = JSON.parse(contents);
sh.getRange(sh.getLastRow() + 1, 1).setValue(Array.isArray(j["mainTable"])); //TRUE
sh.getRange(sh.getLastRow() + 1, 1).setValue(j["mainTable"]); //This displays ONLY the first element of the array in mainTable
j["mainTable"].forEach((e) => { //this lists every element
sh.getRange(sh.getLastRow() + 1, 1).setValue(e);
})
sh.getRange(sh.getLastRow() + 1, 1).setValue(j["mainTable"][3]["id"] + ' ' + j["mainTable"][3]["fld1"]); // Display each value in the object of an array element
} catch (err) {
sh.getRange(sh.getLastRow() + 1, 1).setValue(err);
}
}
So in your case,
JSON.parse(e.postData.contents)["Task"] is returning an array (this is how you set up in your bot).
If you want to access individual array elements, you have to use a subscript.
@TeeSee1 wrote:I was curious, so I ran a little test of my own.
If you have not figured this out, here are my results.
function doPost(e) {
const sh = ss.getSheetByName('test');
const contents = e.postData.contents;
sh.getRange(sh.getLastRow() + 1, 1).setValue(contents); //This shows the whole JSON object
try {
const j = JSON.parse(contents);
sh.getRange(sh.getLastRow() + 1, 1).setValue(Array.isArray(j["mainTable"])); //TRUE
sh.getRange(sh.getLastRow() + 1, 1).setValue(j["mainTable"]); //This displays ONLY the first element of the array in mainTable
j["mainTable"].forEach((e) => { //this lists every element
sh.getRange(sh.getLastRow() + 1, 1).setValue(e);
})
sh.getRange(sh.getLastRow() + 1, 1).setValue(j["mainTable"][3]["id"] + ' ' + j["mainTable"][3]["fld1"]); // Display each value in the object of an array element
} catch (err) {
sh.getRange(sh.getLastRow() + 1, 1).setValue(err);
}
}
So in your case,
JSON.parse(e.postData.contents)["Task"] is returning an array (this is how you set up in your bot).
If you want to access individual array elements, you have to use a subscript.
I tried your solution with different variations, but I am just not able to get any value for Task. It identifies that Task is an array with length = 1, but everything else after that is simply not accessible.
here is my code, followed by output of each step;
code
var strMessage = "Start execution at " + Utilities.formatDate(new Date(), "GMT+8", "dd/MM/yyyy HH:MM:SS");
setAppendDebug(strMessage) ;
const data = JSON.parse(e.postData.contents) ;
setAppendDebug(cNO_TEXT.concat("type of e.postData.contents -->", typeof(e.postData.contents).toString()));
setAppendDebug(cNO_TEXT.concat("type of JSON.parse(e.postData.contents) -->", typeof(JSON.parse(e.postData.contents)).toString()));
setAppendDebug(cNO_TEXT.concat("e.postData.contents -->", e.postData.contents));
setAppendDebug(cNO_TEXT.concat("JSON.parse(e.postData.contents) -->", JSON.parse(e.postData.contents)));
setAppendDebug(cNO_TEXT.concat("Array.isArray(data[Task]) -->", Array.isArray(data["Task"]))) ;
setAppendDebug(cNO_TEXT.concat("Task array length) -->", data["Task"].length)) ;
data["Task"].forEach((tsk)=>{
//setAppendDebug("tsk type:", getObjType(tsk));
setAppendDebug("tsk --> ", (tsk)) ;
setAppendDebug("JSON.stringify(tsk) --> ", JSON.stringify(tsk)) ;
});
}
Output
Start execution at 08/03/2022 23:03:20
Response of request:TextOutput
type of e.postData.contents -->string
type of JSON.parse(e.postData.contents) -->string
e.postData.contents -->{"Task": [{"Command": "Task.Assign","TaskID": "3"}]}
JSON.parse(e.postData.contents) -->[object Object]
Array.isArray(data[Task]) -->true
Task array length) -->1
tsk -->
JSON.stringify(tsk) -->
I have also tried the following but got error
setAppendDebug("tsk[Command] --> ", tsk[0]["Command"]) ; //error: TypeError: Cannot read property 'Command' of undefined
setAppendDebug("tsk.Command --> ", tsk[0].Command) ; //TypeError: Cannot read property 'Command' of undefined
That's bad advice. Webhook payloads are transmitted as a string, so you're stringifying a string. If that somehow works for you, then the payload probably wasn't built properly in the first place. Check out these results:
