Hi everyone,
I am trying to parse the response of an AppSheet bot in my GAS web hook on POST, however, I am not getting much of luck.
I am sending the following JSON to my GAS webhook on POST, it gives me the correct Task ID.
{
"Task": [
<<Start: SELECT(Task[Task ID], [Task ID] = [_THISROW].[TASK ID] )>>
{
"Command": "Task.Assign",
"TaskID": "<<[Task ID]>>"
},
<<End>>
]
}
my GAS code is as follows
function doPost(e) {
var returnMessage = cNO_TEXT ;
var strMessage = "Start execution at " + Utilities.formatDate(new Date(), "GMT+8", "dd/MM/yyyy HH:MM:SS");
var data = JSON.parse(e.postData.contents)["Task"] ;
// do some internal switching and call the appropriate function
}
{"Task":{"Command":"Task.Assign","TaskID":"3"}}
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |