I want delete automatically rows that contain older dates than current date when the user add data. I used workflow but doesn’t work, is my first time with webhooks and i try follow the documentation but i don’t know what I’m doing wrong.
In audit log i get “400 Bad Request”
{
"Action": "Delete",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: Filter(Torneos, [Fecha] <= NOW())>>
{
"Nombre del torneo": "<<[Nombre del torneo]>>",
"Descripción": "<<[Descripción]>>",
"Juego": "<<[Juego]>>",
"Fecha": "<<[Fecha]>>",
"Localización": "<<[Localización]>>",
"Organiza": "<<[Organiza]>>",
"Modalidad": "<<[Modalidad]>>",
"Entrada": "<<[Entrada]>>",
"Premiación": "<<[Premiación]>>",
"Info e inscripciones": "<<[Info e inscripciones]>>",
"Image": "<<[Image]>>"
},
<<End>>
]
}
Solved! Go to Solution.
In the webhook payload, you only need to specify the key column as a parameter.
{
"Action": "Delete",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: Filter(Torneos, [Fecha] <= NOW())>>
{
"KeyColumnName": "<<[KeyColumnName]>>"
},
<<End>>
]
}
In the webhook payload, you only need to specify the key column as a parameter.
{
"Action": "Delete",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: Filter(Torneos, [Fecha] <= NOW())>>
{
"KeyColumnName": "<<[KeyColumnName]>>"
},
<<End>>
]
}
Thank you, its works
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |