Hi all, I’m still in the process of getting familar with appsheet automation processes but I have been having difficulty getting one of them to work. It’s a webhook workflow that we have been developing for some time. We originally created this in test apps as a workflow, but was still in development when the automation function was deployed.
It seems as though each time I create and test the process it works perfectly, but I have tried deploying it 3 times now and it keeps breaking or just partially functions?
I don’t feel confident enough in the process to deploy it again. For example, I tried to complete the process this morning and received an error in the monitor app - pictured below.
And then tried again a few minutes later and the BOT worked as expected. See below two operations today.
I don’t want to deploy this BOT in live projects because it hasn’t proven to be stable?
Most of the time when it doesn’t work I don’t get any error feedback in the monitor app.
How can it go from working to broken on a day to day basis like this?
I will attach screenshots of the automation below if there is anything I’m doing incorrectly. I have had communication with support heavily during the creation process.
BOT:
Material Added:
BODY:
{
“Action”: “Add”,
“Properties”: {
“Locale”: “en-GB”,
“Location”: “48.220599, 16.239976”,
“Timezone”: “GMT Standard Time”
},
“Rows”: [
<<START: SELECT([Related Material Take Offs][Line Reference],IN([Line Reference],[Request Material]))>>
{
“Order No”:“0”,
“Line Reference”:“<<[Line Reference]>>”,
“Mech/Elec”:“<<[Mech/Elec]>>”,
“Requested Date”:“<<TODAY()>>”,
“Location Area”:“<<[Block]>>”,
“Request Type”:“Draw Off”,
“Sub-Area”:“<<[Level]>>”,
“Take Off Group”:“<<[Take Off Group]>>”,
“Product Group”:“<<[Product Group]>>”,
“Product Sub-Group”:“<<[Product Sub-Group]>>”,
“Product”:“<<[Product]>>”,
“Product Code”:“<<[Product Code]>>”,
“Qty Requested”:“<<IF(ISNOTBLANK([Required Qty]), [Required Qty], [Take Off Qty])>>”,
“Qty Ordered”:“<<IF(ISNOTBLANK([Required Qty]), [Required Qty], [Take Off Qty])>>”,
“Unit”:“<<[Unit]>>”,
“Requested By”:“<<[Requested By]>>”,
“Date Required”:“<<[Take Off Group].[Date Required]>>”,
“Requested Delivery Time”:“<<[Take Off Group].[Required Start Time]>>”
}
<>
]
}
Update Status:
BODY:
{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-GB”,
“Timezone”: “GMT Standard Time”
},
“Rows”: [
<<START: SELECT([Related Material Take Offs][Line Reference], IN([Line Reference],[_THISROW].[Request Material]))>>
{
“Line Reference”: “<<[Line Reference]>>”,
“Request Status”: “Requested”
}
<>
]
}
Reset Material List:
