Skip to main content

Is it possible delete all records in a Zapier Table using just one step in a zap?

If not, does anyone know a workaround?

 

I am using the table just as a auxiliar table and I´d like to delete all rows to confirm this table will be empty for the next turn (the next time the zap will be trigged).

Hi @Gui Gonçalves 

Use these Zap steps:

  • Action: Zapier Tables - Find Records
    • You’ll need a column with a common value to use for the lookup condition
  • Action: Looping - Create Loop from Line Items
  • Action: Zapier Tables - Delete Record

@Troy Tessalone thank you for the answer.

 

I tried as you said, but didn´t work.

1 - I put a step with the action Zapier Tables - Find Records using a column where the value is the same for all rows, (In this case the test returned OK with 4 elements (the lenght of my table in that moment)).

2 - I put the action Looping - Create a Loop from Line Itens, and as Value to Loop I choose “Record_Id” from the step above

3 - I put the Delete Record action, using as Record_Id the Record_Id I again. But I am receiving the 400 error: 

 

Maybe I´m doing something wrong.

 


@Gui Gonçalves 

For us to have info about the error, post screenshots showing how your Zap step is configured in the “Configure” section.

 


Here is:

 

 


@Gui Gonçalves 

You need to map a variable from the Looping step, not a variable from step 2.

 


@Troy Tessalone I mapped from the Looping step and worked fine.

 

Thank you very much!