Call a Webhook

Hi I am trying to call a webhook using a bot automation in appsheet. The purpose of this automation is to edit the column Available Stocks from the inventory table when a Stock Out log row is deleted 

Void Stocks Out
{
"Action": "Edit",
"Properties": {
"Locale": "en-US",


"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
{
"ID": "<<Filter("Inventory",([_thisrow].[ItemID]=[ID]))>>",
"Available Stocks": "<<Any(Select(Inventory[Available Stocks],[_thisrow].[ItemID]=[ID]))+[_thisrow].[QTY]>>"
}
]
}

This is the error I am getting 

rpoonawala_0-1703618596271.png

rpoonawala_1-1703619045284.png

 

 

1 0 85
0 REPLIES 0
Top Labels in this Space