Connect Amazon Redshift and iContact

Both apps 34Amazon Redshift 7iContact 27

• Trigger
  New Row

  Triggers when a new row is added to an Amazon Redshift table.

• Trigger
  Updated Row

  Triggers when a row in an Amazon Redshift table is added or changed, based on its updated-time column.

• Action
  Create Rows

  Adds a row to an Amazon Redshift table.

• Action
  Delete Rows

  Deletes the rows in an Amazon Redshift table that match a condition.

• Action
  Find Rows

  Finds rows in an Amazon Redshift table that match a condition.

• Action
  Query Database

  Runs one SQL statement on your Amazon Redshift database and returns any rows it produces.

• Action
  Update Rows

  Updates the rows in an Amazon Redshift table that match a condition.

• Trigger
  New contact

  Triggers when a new contact is added to an iContact client folder, optionally only contacts on a chosen list.

• Trigger
  New list

  Triggers when a new subscriber list is created in an iContact client folder.

• Action
  Add campaign

  Creates a new campaign (sending profile with sender name, sender email and CAN-SPAM mailing address) in an iContact client folder.

• Action
  Add custom field

  Creates a new custom field for contacts in an iContact client folder.

• Action
  Create Contact

  Create a new contact in an iContact client folder.

• Action
  Create List

  Create a new contact list in a client folder.

• Action
  Create Message

  Create a new email message in a client folder.

• Action
  Delete Contact

  Delete an iContact contact by contact ID.

• Action
  Delete list

  Deletes a subscriber list from an iContact client folder.

• Action
  Get Accounts

  List iContact accounts accessible to these credentials.

• Action
  Get campaign

  Returns one iContact campaign (its sending profile, from name and email, and mailing address) by its id.

• Action
  Get Client Folders

  List client folders within an iContact account.

• Action
  Get Contact

  Retrieve a single iContact contact by contact ID.

• Action
  Get list

  Returns one subscriber list from an iContact client folder, including its name, public name and description.

• Action
  Get message

  Returns one email message from an iContact client folder, including its subject, HTML and text bodies, and SpamCheck results.

• Action
  List Campaigns

  List sending campaigns (from-name/email profiles) in a client folder.

• Action
  List Contacts

  List contacts in a client folder, optionally filtered by email or status.

• Action
  List Custom Fields

  List custom fields defined in a client folder.

• Action
  List Lists

  Retrieve all contact lists in a client folder.

• Action
  List Messages

  List email messages in a client folder.

• Action
  List sends

  Returns every email send (pending, sending, released and cancelled) in an iContact client folder, including its message, target lists and segments, schedule, recipient count and status.

• Action
  List Subscriptions

  List subscriptions in a client folder, optionally filtered by contact or list.

• Action
  Send Message to List

  Schedule/send an existing message to one or more lists.

• Action
  Subscribe Contact to List

  Subscribe a contact to a list (creates a subscription).

• Action
  Unsubscribe Contact from List

  Remove a subscription, unsubscribing a contact from a list.

• Action
  Update Contact

  Update an existing iContact contact by contact ID.

• Action
  Update list

  Updates an existing iContact subscriber list's name, public name, description or owner-notification setting. Only the values you supply are changed.

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