AppSheet Call a WebHook

[JVT]

Hello ..

I successfully created a body using call a webhook to update multiple items. However the automation Is not executed successfully if I update only 1 items. Here's the my body expression:

{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Arabian Standard Time"
},
"Rows": [
{
"Item Code": "<<Any(Select(Sale[Item Code 1],[_Thisrow].[Item Code 1]=[Item Code 1]))>>",
"Available Stocks": "<<Any(Select(Sale[New Available Stocks Item 1],[Receipt No.]=Maxrow("Sale","_RowNumber")))>>"
}
]
}
"Rows": [
{
"Item Code": "<<Any(Select(Sale[Item Code 2],[_Thisrow].[Item Code 2]=[Item Code 2]))>>",
"Available Stocks": "<<Any(Select(Sale[New Available Stocks Item 2],[Receipt No.]=Maxrow("Sale","_RowNumber")))>>"
}
]
}
"Rows": [
{
"Item Code": "<<Any(Select(Sale[Item Code 3],[_Thisrow].[Item Code 3]=[Item Code 3]))>>",
"Available Stocks": "<<Any(Select(Sale[New Available Stocks Item 3],[Receipt No.]=Maxrow("Sale","_RowNumber")))>>"
}
]
}

That works if I update 3 items. If only 1 item it will not work. Any help or suggestions?

Thanks

[WillowMobileSys]

Have you tried checking the Monitor page to see if any error was reported when the Automation attempted to run?

You can get the Monitor page as shown below:

[ZediX]

Thank you, it helped me