Edit Value via Webhook

[FatLou]

I am trying to set a value to blank using a webhook. Basically if an option is deleted from Table A I want the value Group by in Table B to be set to empty. The webhook is filtering the data properly it just is not setting the value to empty (clearing the value).

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”,
},
“Rows”: [
<<Start: FILTER(“PropertyandTenantLeasingActivity”, AND(([Properties]=[_THISROW].[PropertyID]),[Group by]=[_THISROW].[Space or Category]))>>
{
“ID”: “<<[ID]>>”,
“Group by”:
},
<>
]
}

[Koichi_Tsuji]

Probably you need to rephrase the syntax slightly and it looks like this.

FatLou:

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”,
},
“Rows”: [
<<Start: FILTER(“PropertyandTenantLeasingActivity”, AND(([Properties]=[_THISROW].[PropertyID]),[Group by]=[_THISROW].[Space or Category]))>>
{
“ID”: “<<[ID]>>”,
“Group by”: " "
},
<< End >>
]
}

[FatLou]

That does not seem to work. I will keep at it. If you have any additional ideas let me know.

[Phil]

You have encountered a bug.
Neither the value “” or " " will clear the field value via the REST API.
Please submit a bug report.

[Phil]

I have developed a fix for the problem.
If testing goes well the change will be released on Tuesday March 17 in the afternoon Seattle time.

Once the fix is released you can specify “” for the field value in the Row data.

I have updated the documentation to explain how to clear a field’s value. See topic “Body” in this article https://help.appsheet.com/en/articles/1980023-updating-records-in-a-table

[FatLou]

Awesome,

Will this also clear a value even if the column has a valid_if statement that does not include a “” (blank) option?

[Phil]

The updated field value must satisfy the valid_if condition.
That includes a field value of “”.