Delete "older" rows with webhook

Gaxer
New Member

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 Solved
0 2 240
1 ACCEPTED 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>>
   ]
}

View solution in original post

2 REPLIES 2

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

Top Labels in this Space