Connect Ontraport to Oracle Database

Both apps 31Ontraport 19Oracle Database 12

• Trigger
  New Contact

  Polling trigger: fires for each newly created contact, newest first (sorted by creation date).

• Trigger
  New or Updated Contact

  Polling trigger: fires when a contact is created or modified, sorted by date last modified.

• Trigger
  New Task

  Polling trigger: fires for each newly created task (objectID 1), newest first.

• Trigger
  New Transaction

  Polling trigger: fires for each newly created transaction (objectID 46), newest first.

• Trigger
  Two-way sync new or updated contact

  A trigger for two-way syncing new and updated contacts, with enhanced on-the-fly mapping. Polls Ontraport Contacts sorted by date-last-modified descending; fires for each new or updated contact.

• Action
  Create Object

  Create a record of any Ontraport object type. Provide objectID and a JSON of fields. Note: Ontraport DROP (dropdown) custom fields fail OPEN — sending a value that is not one of the field's defined options returns HTTP 200 and silently discards it, leaving the field unset. Verify a dropdown value landed by reading the record back.

• Action
  Create or Update Contact

  Create a new contact, or merge into an existing one matched by email (Ontraport saveorupdate). Note: Ontraport DROP (dropdown) custom fields fail OPEN — sending a value that is not one of the field's defined options returns HTTP 200 and silently discards it, leaving the prior value in place. Verify a dropdown value landed by reading the record back.

• Action
  Create Task

  Create a Task object (objectID 1) in Ontraport.

• Action
  Delete Contact

  Delete a contact by its Ontraport ID.

• Action
  Delete Object

  Delete a record of any object type by objectID and id.

• Action
  Find Contact by Email

  Find a contact by exact email match. Returns the first matching record.

• Action
  Find contact by field (Go only has Find Contact by Email — covers email lookup only, not arbitrary field)

  Returns the details for a contact if the specified field matches the specified value. Throws an error if zero or multiple match.

• Action
  Get Contact

  Retrieve a single contact by its Ontraport ID.

• Action
  Get Object

  Retrieve a single record of any object type by objectID and id.

• Action
  List Contacts

  List contacts with optional search, range, and sort.

• Action
  List Objects

  List records of any object type with optional search and range.

• Action
  Remove Tag from Contact

  Remove a tag from one or more contacts.

• Action
  Tag Contact

  Add a tag to one or more contacts.

• Action
  Update Object

  Update a record of any Ontraport object type by ID. Note: Ontraport DROP (dropdown) custom fields fail OPEN — sending a value that is not one of the field's defined options returns HTTP 200 and silently discards it, leaving the prior value in place. Verify a dropdown value landed by reading the record back.

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