Connect Oracle Database and Relatel

Both apps 35Oracle Database 12Relatel 23

• 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
  New Call

  Triggers when a new call is made or received in Relatel.

• Trigger
  New message

  Triggered when a new message is sent or received in Relatel.

• Trigger
  New Smiley

  Triggers when a caller or chat visitor gives a new smiley (satisfaction rating) in Relatel.

• Trigger
  New voicemail

  Triggers when a new voicemail is left for an employee or reception.

• Action
  Add comment

  Adds a comment to a contact in Relatel, optionally notifying a colleague.

• Action
  Add contact

  Adds a new contact to your Relatel company and returns the new contact's id.

• Action
  Cloak Reception

  Sets which reception's number is shown as the caller ID on the authenticated employee's outgoing calls.

• Action
  Delete contact

  Deletes a contact from your Relatel organization and returns Relatel's confirmation message.

• Action
  Dial call

  Initiates a phone call: rings the authenticated employee's phone, then connects them to the given number.

• Action
  Do Not Disturb

  Turns Do Not Disturb on or off for the connected employee and returns the updated employee.

• Action
  Find contact by phone number

  Finds a Relatel contact by its phone number and returns the contact's details.

• Action
  Get contact

  Returns a single contact, including its phone number, name, email, tags and latest activity, by its contact ID.

• Action
  Get employee

  Returns one employee in your Relatel company by ID, including name, email, phone number, presence and do-not-disturb status.

• Action
  Join a Group

  Adds the authenticated employee to an employee group and returns the group's details after joining.

• Action
  Leave a Group

  Removes the authenticated employee from the chosen employee group and returns the group's details.

• Action
  List calls

  Returns calls in the Relatel account, optionally filtered by start time, end time, direction or the employee or reception that took the call.

• Action
  List contacts

  Returns the contacts in your Relatel account, optionally only those with a given phone number.

• Action
  List employee groups

  Returns all employee groups in your Relatel account, with each group's name, presence status and member employees.

• Action
  List employees

  Returns all employees in your Relatel company, including their phone numbers, presence and group memberships.

• Action
  List receptions

  Returns all receptions (phone lines/queues) in the Relatel account.

• Action
  List voicemails

  Returns the account's voicemails, optionally filtered by recording time, recipient or phone number. Returns up to 100 voicemails.

• Action
  Send SMS

  Sends an SMS to one or more phone numbers from your Relatel account or one of your receptions.

• Action
  Update contact

  Updates an existing contact's phone number, name, email, flag or tags, and returns the updated contact.

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