Skip to main content
Best answer

How do I delete all records in a Zapier Table?

  • October 1, 2024
  • 6 replies
  • 213 views

Gui Gonçalves

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).

Best answer by Troy TessaloneBest answer by Troy Tessalone

@Gui Gonçalves 

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

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Forum|alt.badge.img+14

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

Gui Gonçalves

@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.

 


Troy Tessalone
Forum|alt.badge.img+14

@Gui Gonçalves 

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

 


Gui Gonçalves

Here is:

 

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31341 replies
  • Answer
  • October 1, 2024

@Gui Gonçalves 

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

 


Gui Gonçalves

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

 

Thank you very much!