Connect iContact and Oracle Database

Both apps 39iContact 27Oracle Database 12

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

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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.