• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Creating/Updating contact from MySql query [ActiveCampaign]

888lorenzo

Member
Hello,
I'm trying to build a workflow as explained below:
  • at a specific time (Schedule by Pabbly) a MySQL query runs (MySQL : Custom Query)
  • the contacts retrieved by the query are added/updated to a specific listo of ActiveCampaign (ActiveCampaign : Create or Update Contact)
The problem: the query retrieves several contacts but only the first is added/updated in ActiveCampaign.

Is there a way to perform the action to all contacts?

Thanks in advance
Lorenzo
 

Supreme

Well-known member
Staff member
Hey @888lorenzo

You can use the Iterator action step after the " MySQL: Custom Query" action step which will add the data one by one, though need to capture the data in advance format by toggling the "Simple Response" whcih will get the data in JSON format and that data can be used on Iterator action step.

Though we have configured the same in your workflow and would request you to give it a try.

I hope this might help you out.

 
Top