Skip to main content
Best answer

How do I delete all records in a Zapier Table?

  • October 1, 2024
  • 6 replies
  • 212 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 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
  • 31305 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!