Connect Oracle Database and Terros

Both apps 38Oracle Database 12Terros 26

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

• Trigger
  List Calendar Events

  Triggers when a new calendar event appears in Terros.

• Trigger
  List Status Ids

  Triggers when a new disposition (account status) is added in Terros.

• Trigger
  List Tasks

  Triggers when a new task appears in Terros.

• Trigger
  List Workflow Action IDs

  Triggers when a new action is added to a Terros workflow.

• Trigger
  List Workflow IDs

  Triggers when a new workflow is added in Terros.

• Trigger
  List Workflow Stage IDs

  Triggers when a new stage is added to a Terros workflow.

• Trigger
  New Account

  Triggers when a new account is added in Terros.

• Trigger
  New User

  Triggers when a new user is added to your Terros company.

• Action
  Add meeting

  Creates a recurring team meeting in Terros with a schedule, reminders and optional check-in rules.

• Action
  Create/Update Account

  Creates a Terros account, or updates it when the account ID is given.

• Action
  Create User

  Adds a user to your Terros company.

• Action
  Delete Account

  Deletes an account (a homeowner or lead record) from Terros by its account ID.

• Action
  Delete Calendar Event

  Deletes a calendar event.

• Action
  Delete meeting

  Archives a meeting in Terros, or permanently deletes it when Archive is set to false.

• Action
  Delete task

  Removes one or more Terros tasks, archiving them by default or deleting them permanently.

• Action
  Delete User

  Removes a user from your Terros company.

• Action
  Find Account

  Finds a Terros account by account ID, external lead ID or source ID.

• Action
  Find User

  Finds users whose name or email matches the search text.

• Action
  Get task

  Returns a single Terros task by its ID, including its subject, status, owner and criteria.

• Action
  List Accounts

  Returns accounts, optionally filtered by user, workflow or search text.

• Action
  List Available Closers

  Lists closers and their open appointment times for a team or user.

• Action
  List Users

  Returns the users in your Terros company, optionally limited to one team.

• Action
  List Workflow IDs

  Returns the workflows you can see, with their IDs.

• Action
  Make Report

  Runs a KPI report for the chosen KPIs, grouped by user, team or another dimension.

• Action
  Update meeting

  Updates a Terros meeting, replacing its team, name, recurring schedule, reminders, check-in options, location and meeting link.

• Action
  Update User

  Updates a Terros user's name, email, phone or time zone.

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