Skip to main content

I have a Zap process which uses EasyFTP to populate a Zapier table every week from a CSV file.

It uses the Looping by Zapier step to create each record.

At the moment the Zap keeps adding more and more records.

I would like to be able to purge all of the records prior to importing the new ones but am unsure how.

Hi ​@RyanForsythe1979 

You will do a similar process.

Zap steps:

  1. Trigger: [APP] - [EVENT]
  2. Action: Tables - Find Records
    1. MAX: 1000
  3. Action: Looping - Create Loop from Line Items
  4. Action: Tables - Delete Record

 


Thanks for the reply Troy.

Does this need to be created as a separate Zap as I can only use the looping action once?

r


@RyanForsythe1979 

You can have the 1 main Zap trigger 2 other Zaps via webhook chaining: 

 

For the Zap that ADDS records, add a Delay step, so the other Zap can first fetch the records to delete.

Help for Delay: https://zapier.com/apps/delay/integrations#help


Hey ​@RyanForsythe1979, just checking in—did Troy’s replies help to point you in the right direction? 

Want to make sure you’re all set, so please keep us posted on how it’s going! 🙂


Hi ​@SamB. Yes, I got it working thanks. ​@Troy Tessalone thanks for your help.

I must admit that I couldn’t figure out how to setup the webhook so I just created 2 separate Zap runs. Works a treat :)


Thanks so much for confirming that, ​@RyanForsythe1979. I’m so pleased you found a way to get it working without using webhooks—nice work! 🙌

And a big shoutout to ​@Troy Tessalone for helping out here! 🤗