I have two apps and through Appsheet API , I’m copy some values from one app to another.
Basically I’m copying a Parent record with childs rows. One action triggers 3 webhook calls .
like these:
The first and second webhooks call works perfect, but the last one I can’t make it work!
I discovered that the TABLE that I want to add a record is the problem, If I change to any other table in the app is working perfect.
I tried everything! need help please!!!
The bodys of the HTTP request :
{
“Action”: “Add”,
“Properties”: {
“Locale”: “es-AR”,
“Timezone”: “Argentina Standard Time”
},
“Rows”: [
{
“ID”: ‘<<[ID]>>’,
“ID OBRA”: ‘<<[NUMERO OBRA]>>’,
“NOMBRE OBRA”: ‘<<[NOMBRE OBRA]>>’,
“ASESOR”: ‘<<[ASESOR]>>’,
“RESPONSABLE”: ‘<<[RESPONSABLE]>>’,
“TELEFONO RESPONSABLE”:‘<<[TELEFONO RESPONSABLE]>>’,
“EMAIL RESPONSABLE”:‘<<[ EMAIL RESPONSABLE]>>’,
“ESTADO”:“PENDIENTE APROBACION”,
“FECHA ESTADO”:‘<<TODAY()>>’,
“DIRECCION OBRA”:‘<<[DIRECCION]>>’,
“LATLONG”:‘<<[LAT LONG]>>’
}
]
}
{
“Action”: “Add”,
“Properties”: {
“Locale”: “es-AR”,
“Timezone”: “Argentina Standard Time”
},
“Rows”: [
<START:SELECT(Planos[ID],[OBRA]=[_THISROW].[ID])>
{
“ID”: ‘<<[ID]>>’,
“OBRA”: ‘<<[OBRA]>>’,
“PLANO”: ‘<<[PLANO]>>’,
“PLANTA”: ‘<<[PLANTA]>>’
}
<>
]
}
{
“Action”: “Add”,
“Properties”: {
“Locale”: “es-AR”,
“Timezone”: “Argentina Standard Time”
},
“Rows”: [
{
“ID PUERTA” : ‘<<[ID]>>’
}
]
}
The last body I just wrote something really simple just to try writing something to the table but I’m getting the error: Failed: Webhook HTTP request failed with exception The remote server returned an error: (400) Bad Request.