Clear all rows of a table

[Matteo_Menghett]

Hello,

I would like periodically clear my app database (erase all rows). I thought it could be possible with a webhook using as HTTP verb Delete but I am struggling making it done. The JSON body I use is:
{
“Action”: “Delete”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”,
},
“Rows”: [
<<Start: SELECT(TableToDelete[Key],true)>>
{
"Key":"<<[Key]>>",
}
<>
]
}

Does anybody knows where I am wrong?

Thank you.

[Phil]

HI Matteo,

That looks like it should work.

What do you see in the Audit History?
You should be able to see the HTTP body created by the template for your webhook.
You should also be able to see the REST API results.