Webhook - error 400 Bad Request

AppSheet AppSheet Q&A
1

I think my webhook action is well created, but I get this error.

3X_5_7_57a02621766ae54c203d4779c92ba6fd590ba0b0.png
3X_5_7_57a02621766ae54c203d4779c92ba6fd590ba0b0.png3489×1294 316 KB

My webhook body

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”,
“Location”: “47.623098, -122.330184”,
“Timezone”: “Pacific Standard Time”
},
“Rows”: [
<<Start: FILTER(“Celo”, ([Key] = [key1]))>>
{
“Estado”: “Inseminada”

},
<<End>>

]
}

what am I missing?

2

@Roberto_Varela
You need to include the [KeyColumn] explicitly in the payload, that’s why you’re getting the HTML 400 :: Bad Request error:

{
	“Action”: “Edit”,
	“Properties”: {
		“Locale”: “en-US”,
		“Location”: “47.623098, -122.330184”,
		“Timezone”: “Pacific Standard Time”
	},
	“Rows”: [
		<<Start: FILTER(“Celo”, ([Key] = [key1]))>>
		{
			“KeyColumnName”: “<<[KeyColumnName]>>”,
			“Estado”: “Inseminada”
		},
		<<End>>
	]
}
1 Like
3

LeventK:

“KeyColumnName”: “<<[KeyColumnName]>>”,

it worked perfect, thanks for your help

1 Like
4

You’re welcome.