Connect Hyros and Oracle Database

Both apps 37Hyros 25Oracle Database 12

• Trigger
  New Call

  Triggers when a new call is recorded in HYROS.

• Trigger
  New Lead

  Triggers when a new lead is created in HYROS.

• Trigger
  New Sale

  Triggers when a new sale is recorded in HYROS.

• Trigger
  New Sale Attributed

  Triggers when a new sale is recorded and attributed in Hyros.

• Trigger
  New Subscription

  Triggers when a new subscription is recorded in HYROS.

• Action
  Delete Call

  Deletes a call.

• Action
  Delete Sale

  Deletes a sale.

• Action
  Find Lead Clicks

  Returns the tracked clicks of a lead.

• Action
  Find Leads

  Finds leads by ID, email or creation date.

• Action
  Find Sales

  Finds sales by ID, email, lead, product tag or date.

• Action
  Find Subscriptions

  Finds subscriptions by ID, email, lead, product tag, status or date.

• Action
  Get Ad Accounts Attribution Report

  Returns sales, revenue, cost and other attribution figures per ad account.

• Action
  Get Ads Attribution Report

  Returns sales, revenue, cost and other attribution figures per ad, ad set or campaign.

• Action
  Get Lead Journey

  Returns the attribution journey of one or more leads: their sales and the sources that led to them.

• Action
  Get User Info

  Returns the profile of the account the API key belongs to.

• Action
  List Ads

  Returns the ads HYROS tracks for an ad platform.

• Action
  List Domains

  Returns the domains configured in the account.

• Action
  List Keywords

  Returns the keywords of a Google ad group.

• Action
  List Lead Stages

  Returns the lead stages in the account.

• Action
  List Sources

  Returns the traffic sources in the account.

• Action
  List Tags

  Returns every tag in the account.

• Action
  Refund Order

  Refunds an order and updates the income of its lead.

• Action
  Retrieve Calls

  Finds calls by ID, email, lead, product tag, qualification or date.

• Action
  Update Call

  Updates the name, state or qualification of calls.

• Action
  Update Sale

  Marks sales as refunded or recurring.

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