Connect SmartEmailing and SQL Server

Both apps 28SmartEmailing 17SQL Server 11

• Trigger
  New Contact

  Triggers when a new contact is added to your SmartEmailing account.

• Trigger
  Updated Contact

  Triggers when an existing contact is updated in SmartEmailing.

• Action
  Add Contact list

  Creates a new contact list in SmartEmailing.

• Action
  Add Custom field

  Creates a new contact custom field in SmartEmailing with the given name and type.

• Action
  Delete Contact

  Permanently deletes a contact and anonymizes its data (GDPR forget). This cannot be undone.

• Action
  Get Contact

  Returns a single contact by email address or ID, including contact list memberships and custom field values.

• Action
  Get Contact list

  Returns a single contact list by its ID with all its properties, such as name, sender details and engagement rates.

• Action
  List Contact lists

  Returns all contact lists in your SmartEmailing account.

• Action
  List Contacts

  Returns contacts in your SmartEmailing account, optionally filtered by email, name, company and other contact details, including their list memberships and custom field values.

• Action
  List Contacts in list

  Returns the contacts that belong to a contact list, with their details and list memberships.

• Action
  List Custom fields

  Returns the custom field definitions set up in your SmartEmailing account, optionally with their options.

• Action
  List Newsletters

  Returns your finished newsletters with their sender details, send times and open, click and unsubscribe counts.

• Action
  Send custom email

  Sends a SmartEmailing email or email template to one recipient, with optional subject, preheader and dynamic content overrides.

• Action
  Send transactional email

  Sends a transactional email (no unsubscribe link) to one recipient, either from a saved email/template or from a subject and body you supply.

• Action
  Unsubscribe Contact

  Unsubscribes a contact from a chosen contact list.

• Action
  Update Contact email address

  Changes a contact's email address in SmartEmailing, moving all of the contact's data to the new address.

• Action
  Update Contact list

  Updates an existing contact list's name, public name, sender name, sender email or reply-to address. Only the values you provide are changed.

• 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.