Connect Oracle Database to Powerlink

Both apps 41Oracle Database 12Powerlink 29

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

• Action
  Add Account

  Creates a new account record in Fireberry (formerly Powerlink).

• Action
  Add Contact

  Create a new Contact record.

• Action
  Add Meeting

  Create a new meeting (activity) record in Fireberry.

• Action
  Add Opportunity

  Creates a new opportunity in Powerlink (Fireberry) linked to an account.

• Action
  Add Task

  Create a new Task record.

• Action
  Add Ticket

  Create a new support ticket record.

• Action
  Delete Account

  Deletes an account in Fireberry (Powerlink) by its ID.

• Action
  Delete Contact

  Delete a Contact record by id.

• Action
  Delete Meeting

  Deletes a meeting record in Powerlink (Fireberry).

• Action
  Delete Opportunity

  Delete an Opportunity record by id.

• Action
  Delete Task

  Delete a Task record by id.

• Action
  Delete Ticket

  Delete a support ticket by id.

• Action
  Get Account

  Retrieve a single Account record by id.

• Action
  Get Contact

  Retrieves a single Powerlink (Fireberry) contact by its ID, with all of its fields and values.

• Action
  Get Meeting

  Retrieve a single meeting record by id.

• Action
  Get Opportunity

  Retrieves a single opportunity by its ID, including all of its fields and values.

• Action
  Get Task

  Retrieve a single Task record by id.

• Action
  Get Ticket

  Retrieve a single support ticket by id.

• Action
  List Accounts

  Returns the accounts in your Fireberry (Powerlink) account, with all of their fields and values including custom fields.

• Action
  List Contacts

  Retrieve a list of Contact records.

• Action
  List Meetings

  Lists meetings in your Fireberry account, with all of their fields and values.

• Action
  List Tasks

  Lists tasks in your Fireberry (Powerlink) account, returning up to 50 tasks with all their fields.

• Action
  List Tickets

  Lists tickets (cases) in your Fireberry account, returning the first page of up to 50 records with all their fields.

• Action
  Update Account

  Update fields on an existing Account record by id.

• Action
  Update Contact

  Update fields on an existing Contact record by id.

• Action
  Update Meeting

  Update fields on an existing meeting record.

• Action
  Update Opportunity

  Update fields on an existing Opportunity record by id.

• Action
  Update Task

  Update fields on an existing Task record by id.

• Action
  Update Ticket

  Update fields on an existing support ticket.

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