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.

[Jeantdias]

Pessoal... Criei um app para fazer registro de fotos - Mas para garantir a melhor qualidade dos arquivos fiz de um jeito que é possivel fazer upload da imagem pegando as imagem do arquivo da câmera. Mas no iphone 15 comecei a ter problemas para subir as fotos. Depois de quebrar muito a cabeça descobri que o app não suportava imagens com arquivos acima de 2k que não fossem da extenção " JPEG"... Alterei algumas configurações no iphone e consegui consertar o problema... 

O app devolvia um erro abaixo... 

"Media type \u0027(null)\u0027 is not supported:  [*/*]"

Não tem nada a ver com o assunto acima, mas precisa postar isso pra caso alguem procure na internet kkkk... Desculpa ai...

[Instituto_San_1]

Hi

I am getting a similar error from a File Field, and I can t figure out if the user is trying to upload an image instead a pdf file, or a large not supported image:

Message: Unable to add row to table 'Solicitud de Reinscripcion'. → Unable to save image → { "error": { "code": 400, "message": "Media type \u0027(null)\u0027 is not supported. Valid media types: [*/*]", "errors": [{ "message": "Media type \u0027(null)\u0027 is not supported. Valid media types: [*/*]", "domain": "global", "reason": "badContent" }] } }

Support team asks for a recorded action which I am not able to provide.

any ideas?

Thank you

Claudio