Hello:

We have a web-based service for our clients that displays periodic alerts.  We'd like to send them an email whenever we post a new alert.

Ideally, we'd use the Campaigns API to do the following:

1. Update a Zoho list using names pulled from SQL server names list
   
2. Send an email to the updated list indicating that a new alert on our website is available.

Looking at the API docs, it doesn't appear that there is a clear way to do this.    The addlistsubscribersinbulk method seems to be what we need to update a list, but it seems to trigger an additional email to each user prompting them to confirm, which we do not want to happen, because they've already confirmed with us (they are our customers who have already opted-in).

We also don't want to create a "campaign" per se.  We just want to send a recurring email with the exact same message "A new alert has been posted. Go visit the website."  But the API appears to force the creation of a new campaign with no way to re-use a campaign.  You either have to create a new campaign or copy an old campaign, and there are domain and user restraints imposed on the API that don't exist when you perform the same actions from Zoho's front-end tool.  For example, we get permissions errors on the clonecampaign method stating, "Email is not verified."

Has anyone out there used this scenario successfully where you are updating your list from SQL and then triggering a recurring email using a template that never changes?  If so, how?

Thank you.