Appsheet API error - 400 Bad Request

[elan_Bailey]

Hi all,

I’m back with what seems to be a recurring issue with an Update Webhook.
I’m getting a 400 bad request error.

This is an app that I cloned on November 6th so I had to:

1. Change the app id in the webhook
2. Create a new access key as my old ones expired on November 18
3. I also changed some column names to match updates in my data sources
   Other than that I left everything else the same

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”
},
“Rows”: [
<<Start: SELECT(Barriers[Barrier ID],([Source] = [_THISROW-1].[Reflection ID])) >>
{
“Barrier ID”: “<<[Barrier ID]>>”,
“Subject”: “<<[_THISROW-1].[Subject]>>”,
“Script”: “<<[_THISROW-1].[Script]>>”,
“Reaction”: “<<[_THISROW-1].[Reaction]>>”,
“Payoff”: “<<[_THISROW-1].[Payoff]>>”,
“Cost”: “<<[_THISROW-1].[Cost]>>”,
“Desire”: “<<[_THISROW-1].[Desire]>>”,
“Discovery”: “<<[_THISROW-1].[Discovery]>>”,
“Commitment”: “<<[_THISROW-1].[Commitment]>>”,
“Life Domain”: “<<[_THISROW-1].[Life Domain]>>”,
},
<< End >>
]
}

The error I’m getting in the log is:

Error:
"Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request. "
Properties:
{
“AppTemplateVersion”: “1.000041”,
“RuleName”: “Update Barriers”,
“EventType”: “Change”,
“InvokedBy”: “Update”,
“ServerName”: “INSTANCE-US-WES”,
“ServerRegion”: “us-west1-gcp-prod”,
“IgnoreSecurityFilters”: false,
“TableName”: “Check ins”,
“RuleTableName”: “Check ins”,
“OperationUpdateMode”: “UPDATES_ONLY”,
“EventMatch”: “Workflow event successfully matched”,
“Condition”: “”,
“MatchesCondition”: “True”,
“Exception”: "Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request. ",
“ActionResults”: “Created 1 ActionResults”,
“Action Type”: “Webhook”,
“Action Name”: “Update Barrier”,
“Url”: “https://api.appsheet.com/api/v2/apps/504801c8-ce35-47ca-8938-b99c8713ee0b/tables/Barriers/Action”,
“Verb”: “Post”,
“MimeType”: “application/json”,
“Headers”: “applicationAccessKey:V2-obscured for security reasons, _webhookActionDepth:0”,
“Payload”: “{“Action”: “Edit”,“Properties”: {“Locale”: “en-US”,“Location”: “47.623098, -122.330184”,“Timezone”: “Pacific Standard Time”},“Rows”: }”,
“AppTemplateName”: “504801c8-ce35-47ca-8938-b99c8713ee0b”,
“Operation”: “Workflow action”,
“Result”: “Failure”
}
OK