About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Unable to create basic if process

J

I am trying to retrieve all hostnames from Cloudflare’s SSL for SaaS, fetch all websites in cPanel via cPanel API, loop through all Cloudflare hostnames, and if the hostname isn’t in the cPanel API request response as a list of websites, delete the hostname. 

 

I am formatting both cPanel and Cloudflare API responses to line-items using text-to-line-items. 

 

However, the only continue if isn’t work:

 

 

Resulting in:

 

 

I can see that Zapier is detecting that none of the hostnames are in the output, however, as you can see:

 

 

actioncleaningaz.com is in the list of cPanel websites. 

 

I have put in three test records, that are in Cloudflare hostnames, but aren’t in cPanel website API response, but it isn’t detecting it, instead opting to say all hostnames aren’t in the cPanel website response.

 

How can I correct this?

13 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @jwhm 

Try changing the Filter operator to: Does not contain

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Same issue. 

Troy Tessalone
Userlevel 7
Badge +14

@jwhm 

Can you post screenshots with how the Formatter Step 5 is configured in EDIT mode along with the updated Filter step?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@jwhm 

Another approach would be to use a Code step to check a value against a list (array of items) or a string, then Filter based on the output.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

@jwhm

Can you post screenshots with how the Formatter Step 5 is configured in EDIT mode along with the updated Filter step?

 

J

 

J

 

J

 

Troy Tessalone
Userlevel 7
Badge +14

@jwhm 

Instead of the Formatter Step 5 that converts the text to line items, try mapping the variable output from step 4 to the right side Filter condition and use the operator (Does Not Contain).

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

 

Its is now saying none of the items match. I think this is a bug?

Troy Tessalone
Userlevel 7
Badge +14

@jwhm 

Reviewing your original Filter config: Hostname is not in OUTPUT list

The Hostname value being tested is: actioncleaningaz.com

The OUTPUT list data includes actioncleaningaz.com.

Therefore it makes sense the Filter would NOT have continued as indicated by the yellow warning because the OUTPUT list data did include the Hostname.

 

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

@jwhm

Reviewing your original Filter config: Hostname is not in OUTPUT list

The Hostname value being tested is: actioncleaningaz.com

The OUTPUT list data includes actioncleaningaz.com.

Therefore it makes sense the Filter would NOT have continued as indicated by the yellow warning because the OUTPUT list data did include the Hostname.

 

 

 

So, how can I make it so, if the hostname is not in the output, continue?

Troy Tessalone
Userlevel 7
Badge +14

@jwhm 

If you test with a Hostname variable value that is not in the list, then the Zap Filter would continue and show as green.

Try turning the Zap ON and testing live, then check the DATA IN/OUT for each Zap step to help you trace and troubleshoot: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions