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

[mateo]

Hi @elan_Bailey,

Did you resolve this issue? I noticed something similar in one of my apps. Everything seems to be properly created. Just wondering whether you managed to fix that so maybe you could help me with my problem.

Cheers!

[Steve]

Please contact AppSheet Support for help with this.