Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Best answer

Connect a custom API to Zapier

retvaripeter

Hi Folks,

 

Could please help me with this case?:

 

1) I would like to get a color database from this site:

$.ajax({  url: "//stage-api.benjaminmoore.com/api/{YOURAPIKEY}/color/GetPaletteByCode",  data: "code=AFF&colorData=true&countryCode=en-us",  dataType: "jsonp",  jsonpCallback: "CallbackFunction",  error: function (xhr) {    // your error code here  }});

 

2) Get the object and send it to Webflow CMS

 

Is it possible to do this with Zapier? In that case what would be the steps? The second part seems to be easier, but I don’t know how to connect the link above to Zapier, because it’s not the usual auth. 

I wonder if you could help with the first step: connect the database to Zapier above🥹

 

Many thanks in advance,

 

Peter

Best answer by Troy Tessalone

@retvaripeter

From the help article: https://zapier.com/apps/looping/help

 

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.

7 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @retvaripeter 

Good question.

Try using the Webhook app to make the API request: https://zapier.com/apps/webhook/help

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

Hello @Troy Tessalone ,

 

You’re such a rock star :) Thanks for all the information! 😍☺️ Actually I’ve successfully finished with the first part (Postman helped me as well to get a working URL) -which I think its harder.

However I’m having trouble with the built in webflow integration feature. I hope you can point me to the right direction:

 

1) I made a GET request after the trigger successfully (get the colors I wanted)

 

 

2) I’ve made a collection in Webflow called Color with the same fields as the response above.

 

My goal is to fill up the collection with the API response (colors) above

 

3) In Zapier I attached some required field to the collection:

 

 

4) However it seems like I can create only 1 item in CMS with this step, but I would like to create all the color elements in the CMS collection “color” in Webflow

 

5) That is why I’m getting this error msg: 

 

Do you know how to create/add more than 1 CMS item to Webflow? Because inside the response object it has 3500 colors. In that case I need to create 3500 items inside the collection. Not one.

 

Many many thanks in advance,

 

Cheers,

 

Peter Retvari

Troy Tessalone
Forum|alt.badge.img+14

@retvaripeter 

You can use the Looping app to iterate thru each array line item that is returned from the API.

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

Wow, cool. Thank you. And with the Looping App I can add a step to create an item in Webflow color collection, right?

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31611 replies
  • Answer
  • June 12, 2023

@retvaripeter

From the help article: https://zapier.com/apps/looping/help

 

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

Thanks again! I’m going to test it and get back to the topic to help other with the same question. Cheers

retvaripeter

Dear Troy,

Just tested it and when I test the loop inside edit mode it’s working (of course runs only 1 iteration - what we can see in the help section of the Looping app) - you can see that the line item with Webflow is inside the loop.

 

 

, however after I published and set a button to it with a Zap webook (which is the trigger) I got this error:

 

 

I also set the limit to 500 iterations. Do not know why it happened exactly.

Terms & Conditions