IF Statement in Webhook

[Sarah_Keown]

Hi, I’m having trouble with a webhook and I think its due to the IF statements in the JSON text. I tested this previously and it appeared to work, I have tried this using Bot and Workflow and neither the log or monitor app is throwing an error. The app editor itself is not showing any error.

I can’t see anything wrong with the statements myself but maybe there is a specific way to reference expressions in the JSON text that I’m missing?

The whole JSON is pasted below:

{
"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]>>"
}
<<End>>
]
}