Connect ActiveCampaign and SQL Server

Both apps 114ActiveCampaign 103SQL Server 11

• Trigger
  Contact unsubscribed from list

  Fires instantly when a contact unsubscribes from a list. Self-registers an ActiveCampaign webhook for the 'unsubscribe' event.

• Trigger
  Deal task completed

  Fires instantly when a deal task is completed.

• Trigger
  Email opened

  Fires instantly when a contact opens an email. Self-registering ActiveCampaign webhook on the 'open' event.

• Trigger
  Link clicked in email

  Fires instantly when a contact clicks a link in an email. Self-registers an ActiveCampaign webhook for the click event.

• Trigger
  New contact

  Polling trigger. Fires when a new contact is created, newest first.

• Trigger
  New contact added to list

  Triggers when a new contact is added to a list.

• Trigger
  New deal

  Polling trigger. Fires when a new deal is created, newest first.

• Trigger
  New deal task

  Fires instantly when a new deal task is created.

• Trigger
  New list

  Polling trigger. Fires when a new list is created, newest first.

• Trigger
  New note

  Triggered when a new note is created.

• Trigger
  New or updated contact

  Polling trigger. Fires when a contact is created or updated, by most-recent update.

• Trigger
  New or updated deal

  Triggers on a new or updated deal.

• Trigger
  New or updated deal (instant)

  Triggers when a new deal is created or an existing deal is updated.

• Trigger
  New tag

  Polling trigger. Fires when a new tag is created, newest first.

• Trigger
  New task

  Triggered when a new task is created.

• Trigger
  Tag added to contact

  Triggers when a tag is added to a contact.

• Trigger
  Tag removed from contact

  Fires instantly when a tag is removed from a contact.

• Trigger
  Two-way sync new or updated contacts

  A trigger for two-way syncing new and updated contacts, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping.

• Trigger
  Two-way sync new or updated deals

  A trigger for two-way syncing new and updated deals, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping.

• Action
  Add account

  Adds a new account (organization).

• Action
  Add contact

  Adds a new contact.

• Action
  Add contact to automation

  Adds a contact to an automation by contact ID and automation ID.

• Action
  Add contact to list

  Subscribes a contact to a list (status 1) or unsubscribes (status 2) via contactLists.

• Action
  Add contact via mapped list

  Adds (upserts) a contact with mapped fields and the target list id. Ports the dev v1 subscriber_add op to the AC v3 contact/sync endpoint.

• Action
  Add custom contact object record

  Adds a record for the specified contact custom object to the specified contact.

• Action
  Add deal

  Adds a new deal.

• Action
  Add deal via mappings

  Adds a new deal, accepting pipeline and stage by name (mapped) plus standard deal fields.

• Action
  Add list

  Creates a new list.

• Action
  Add note to contact

  Adds a note to a contact.

• Action
  Add or update contact by email

  Adds a new contact, or updates the existing contact if the email already exists (sync endpoint).

• Action
  Add tag

  Creates a new tag.

• Action
  Add tag to contact

  Adds an existing tag to a contact by tag ID and contact ID.

• Action
  Add task

  Adds a new task in ActiveCampaign

• Action
  Bulk import contacts

  Import many contacts in one call with tags/list membership.

• Action
  Clear contact custom field value

  Clears (empties) the value of the specified custom field for the specified contact.

• Action
  Create abandoned cart

  Creates an abandoned cart record via the Deep Data e-commerce integration (ecomOrders with abandonedDate).

• Action
  Create account association

  Creates an account association with a contact ID.

• Action
  Create a deal note

  Add a note to a deal.

• Action
  Create a deal stage

  Creates a new deal stage in the specified pipeline.

• Action
  Create a deal stage by mapped pipeline

  Creates a new deal stage in the mapped pipeline.

• Action
  Create an ecommerce customer

  Create a Deep Data ecommerce customer linking a contact to a store.

• Action
  Create an ecommerce order

  Create a Deep Data ecommerce order record.

• Action
  Create a note

  Create a free-text note attached to a CRM object.

• Action
  Create an SMS broadcast

  Create a new SMS broadcast message to a recipient list.

• Action
  Create a pipeline

  Creates a new pipeline (deal group) in ActiveCampaign.

• Action
  Create a secondary contact

  Associate an additional contact with a deal.

• Action
  Create or update custom-object record

  Upsert a custom-object (schema) record.

• Action
  Delete contact

  Deletes a contact by ID.

• Action
  Delete custom contact object record

  Deletes a record from the specified custom contact object.

• Action
  Delete deal

  Deletes an existing deal.

• Action
  Delete deal stage

  Deletes an existing deal stage.

• Action
  Delete list

  Deletes a list by ID.

• Action
  Delete note

  Delete a note by ID.

• Action
  Delete tag

  Deletes a tag by ID.

• Action
  Delete task

  Deletes a task by ID in ActiveCampaign

• Action
  Duplicate campaign

  Duplicates an ActiveCampaign campaign by ID

• Action
  Edit campaign

  Edits an existing campaign in ActiveCampaign

• Action
  Find account by name

  Finds an existing account by name. Returns matching accounts.

• Action
  Find contact by custom field

  Finds an existing contact by the value of a custom field. Provide the custom field's numeric ID and the value to search for.

• Action
  Find contacts by custom field

  Finds contacts by the selected custom field. May return zero, one, or multiple contact IDs. Use the "Get contact" action to fetch a contact's details.

• Action
  Find deal by title

  Finds an existing deal by title. An error occurs if a single exact match is not found.

• Action
  Find user by email

  Finds an existing user by email. An error occurs if a matching user is not found.

• Action
  Get account

  Returns account info for the specified account ID.

• Action
  Get all deal stages from specified pipeline

  Get all deal stages belonging to a pipeline, looked up by pipeline name. Returns each stage's title (Stage name) and id (Stage ID).

• Action
  Get automation

  Fetches an automation by ID. An error occurs if the automation is not found.

• Action
  Get campaign

  Retrieves a single campaign from ActiveCampaign by its ID.

• Action
  Get contact

  Get contact by ID. An error occurs if the contact is not found.

• Action
  Get contact by email

  Returns full contact details for the specified email address. An error occurs if the contact is not found.

• Action
  Get contact's deals

  Returns all deals associated with the specified contact.

• Action
  Get contact's lists

  Returns all lists the specified contact belongs to.

• Action
  Get contact's tags

  Returns all tags associated with the specified contact.

• Action
  Get deal

  Returns deal info for the specified deal ID.

• Action
  Get form

  Retrieve a single ActiveCampaign form by its ID.

• Action
  Get list

  Returns a single contact list by its id, including its name, sender information and subscriber counts.

• Action
  Get note

  Retrieve a single note by its ID.

• Action
  Get score

  Retrieve a single lead/contact scoring rule by its ID.

• Action
  Get segment

  Retrieve a single ActiveCampaign segment by ID.

• Action
  Get tag

  Fetches a tag by ID. An error occurs if the tag is not found.

• Action
  Get task

  Retrieves a task by ID from ActiveCampaign

• Action
  List all campaigns

  List email campaigns.

• Action
  List all pipelines

  List deal pipelines.

• Action
  List all scores

  List the account's lead/contact scoring rules.

• Action
  List all stages

  List deal pipeline stages.

• Action
  List all tasks

  List CRM tasks.

• Action
  List automations

  Returns a paginated list of all automations.

• Action
  List contacts

  Returns a paginated list of all contacts.

• Action
  List custom contact object records

  Returns a paginated list of all records for the specified custom contact object.

• Action
  List deals

  Returns a paginated list of all deals.

• Action
  List lists

  Returns a paginated list of all contact lists.

• Action
  List tags

  Returns a paginated list of all tags.

• Action
  Move deal to another stage

  Move a deal to a different pipeline stage.

• Action
  Remove contact from automation

  Removes a contact from an automation by deleting the contact automation record.

• Action
  Remove contact from list

  Removes a contact from the specified list.

• Action
  Remove tag from contact

  Removes a tag from a contact by the contactTag association ID.

• Action
  Remove tags from contact

  Removes the provided tags (by name, comma-separated) from a contact identified by email or contact ID.

• Action
  Set automation status

  Enables or disables an automation. Set status to '1' to enable or '0' to disable.

• Action
  Set custom field value for contact

  Create or update a contact's custom field value.

• Action
  Set deal currency custom field value

  Set the value for a deal's custom field of the "currency" type

• Action
  Update account

  Updates the specified account.

• Action
  Update contact

  Updates an existing contact having the specified ID.

• Action
  Update deal

  Updates an existing deal.

• Action
  Update tag

  Updates an existing tag.

• Action
  Update task

  Updates a task by ID in ActiveCampaign

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.