Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400)

[vigaude]

I can't understand which is my mistake in this task, can someone help me?

I want create a bot that every day update a list of row with the correct prices for each row and change the date (only for the row with [FORNITORE]="95e4513a":

{
"Action": "Edit",
"Properties": {
"Locale": "it-IT",
"Location": "47.623098, -122.330184",
"Timezone": "Central Europe Standard Time"
},
"Rows": [
<<START: SELECT( LISTINI ACQUISTO[ID],([FORNITORE]="95e4513a"))>>
{
"ID":"<<[id]>>",
"P": "<<IF([PRODOTTO].[prezzo medio di acquisto]>0,
[PRODOTTO].[prezzo medio di acquisto]/23,[PRODOTTO].[Costo max:]/23)>>",
"DATA": "<<TODAY()>>"

},
<<END>>
]
}

When I try it doesn't work and the error is:

Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.

I have check online and the error can be:

1. 400 Bad Request
   a. The Application Access Key is missing.  (non possible is automatically set by appsheet )
   b. The AppId is missing. (non possible is automatically set by appsheet)
   c. The Post body contains invalid data.

so I think that the problem is "c" The Post body contains invalid data but I can't understand what is the problem.....

thanks for help

[WillowMobileSys]

Did you figure out this issue?

[mSalv]

Any news regarding this issue?

[sak]

I've encountered this same "400 Bad request" error and I've spent several hours trying to figure out what I did wrong. What I've found out is that if I set "Preset" as Appsheet API, my email needs to be the owner of the destination app (being an editor is not enough). Otherwise, I need to set the "Preset" to Custom and config the task according to this https://support.google.com/appsheet/answer/10105398?hl=en. Hope this helps.

[sak]

Another cause for the "400 Bad request" error is destination table's key column. If it's virtual column (for example, "_ComputedKey") then I'd get the "400 Bad request" error.