Delete Mutiple rows via webhook and API

[FatLou]

I have Table A and Table B. Table B holds a reference Column to table A. When I delete a row in Table A I want to create an Action that then deletes all rows in Table B that referenced the deleted row in Table A.

below is how I filled out the workflow

Target Data: Table A
When this happens: Deletes_Only

If this is True:

Reaction: Webhook
Name: Action 1
Preset: Custom
URL: https://api.appsheet.com/api/v2/apps/*******/tables/Table B/Action

HTTP verb: Delete
HTTP Content: JSON

Body Template:

The goal here is to SELECT all of the rows from Table B where the value of the [Properties] column is equal to the value of ID from the row deleted in Table A.
{
“Action”: “Delete”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”
},
“Rows”: [
<<Start: Select(Table B[ID], [Properties] = [_THISROW].[ID])>>

{
  "ID": "<<[ID]>>"
}

<>
]
}

Below is the result in the Audit history. It seems to be returning the correct IDs but it is not deleting them from the table.

Row:
[
“19”,
“12vlwZir”,
“Will Test”,
“Wills Test”,
“”,
“”,
“”,
“”,
“”,
“”,
“”,
“Er93uGK5”,
“”,
“”,
“”,
“”,
“”,
“”,
“ZIUnmByV , 7MGTEfIY , QV1Bg624”,
“”
]
Properties:
{
“TableName”: “Properties”,
“tzOffset”: “240”,
“settings”: “{”_RowNumber":“0”,"_EMAIL":"","_NAME":"","_LOCATION":"",“Options Heading”:"",“Option 1”:"",“Option 2”:"",“Country Option”:"",“Language Option”:"",“Option 5”:"",“Option 6”:"",“Option 7”:"",“Option 8”:"",“Option 9”:"","_THISUSER":“onlyvalue”}",
“apiLevel”: “1”,
“isPreview”: “undefined”,
“checkCache”: “false”,
“locale”: “en-US”,
“location”: “null”,
“appTemplateVersion”: “1.000755”,
“localVersion”: “”,
“timestamp”: “”,
“requestStartTime”: “2019-07-16T23:36:36.153Z”,
“lastSyncTime”: “”,
“appStartTime”: “”,
“dataStamp”: “”,
“clientId”: “c5da2c8d-4e37-4bb8-b5e8-db46567c8949”,
“build”: “undefined”,
“requestId”: “95293962”,
“RowSize”: 67,
“AppTemplateName”: “******”,
“Operation”: “Delete row”,
“RecordType”: “Start”
}

×
Audit Log Details
Row:
[
“19”,
“12vlwZir”,
“Will Test”,
“Wills Test”,
“”,
“”,
“”,
“”,
“”,
“”,
“”,
“Er93uGK5”,
“”,
“”,
“”,
“”,
“”,
“”,
“ZIUnmByV , 7MGTEfIY , QV1Bg624”,
“”
]
Properties:
{
“TableName”: “Properties”,
“tzOffset”: “240”,
“settings”: “{”_RowNumber":“0”,"_EMAIL":"","_NAME":"","_LOCATION":"",“Options Heading”:"",“Option 1”:"",“Option 2”:"",“Country Option”:"",“Language Option”:"",“Option 5”:"",“Option 6”:"",“Option 7”:"",“Option 8”:"",“Option 9”:"","_THISUSER":“onlyvalue”}",
“apiLevel”: “1”,
“isPreview”: “undefined”,
“checkCache”: “false”,
“locale”: “en-US”,
“location”: “null”,
“appTemplateVersion”: “1.000755”,
“localVersion”: “”,
“timestamp”: “”,
“requestStartTime”: “2019-07-16T23:36:36.153Z”,
“lastSyncTime”: “”,
“appStartTime”: “”,
“dataStamp”: “”,
“clientId”: “c5da2c8d-4e37-4bb8-b5e8-db46567c8949”,
“build”: “undefined”,
“requestId”: “95293962”,
“RowSize”: 67,
“AppTemplateName”: “77009382-fb60-4c59-b103-5a2a5c9b8849”,
“Operation”: “Delete row”,
“RecordType”: “Start”
}