Connect Oracle Database and Plutio

Both apps 33Oracle Database 12Plutio 21

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

  Triggers when a new block (content, line items, signature area) is added to a contract, proposal or invoice.

• Trigger
  New Task

  Triggers when a new task is created in your Plutio workspace.

• Trigger
  New Task Board

  Triggers when a new task board is created in your Plutio workspace.

• Trigger
  New Task Group

  Triggers when a new task group is created in Plutio.

• Action
  Create a Task

  Creates a task on a project's task board in Plutio and returns the new task.

• Action
  Create Block

  Creates a block of content or line items on a Plutio contract, proposal or invoice and returns the created block.

• Action
  Create Invoice

  Creates a draft invoice in Plutio for a client person or company. Line items are added separately.

• Action
  Create Person

  Creates a new person (client, lead or team member) in your Plutio workspace and returns the created record.

• Action
  Create Project

  Creates a new project in your Plutio workspace, optionally linked to a client. Plutio gives it a default status and a first task board.

• Action
  Create Task Board

  Creates a new task board in Plutio, optionally inside a project.

• Action
  Create Task Group

  Creates a new task group (a column or section) on a Plutio task board and returns the created group.

• Action
  Delete Block

  Permanently deletes a block (a piece of content or line items) from a Plutio contract, proposal or invoice.

• Action
  Delete Invoice

  Permanently deletes an invoice from your Plutio workspace.

• Action
  Find Person

  Finds people in your Plutio workspace by email, name, role or an advanced query, and returns the first match plus all matches.

• Action
  Get Task

  Returns a single task by its id, including its custom field values.

• Action
  Move a Task

  Moves a task to a different task group, task board or project.

• Action
  Retrieve Block/Blocks

  Returns one block by its ID, or all the blocks (text, line items) that make up a contract, proposal or invoice.

• Action
  Retrieve Person/People

  Returns one person by id, or a list of people in your Plutio workspace filtered by role, status or an advanced query.

• Action
  Update a Task

  Updates an existing task in Plutio. Only the fields you fill in are changed; everything else stays the same.

• Action
  Update Invoice

  Updates an existing invoice's name, currency, due date, client or custom field values. Fields left blank stay as they are.

• Action
  Update Person

  Updates an existing person (client, lead or team member) in Plutio. Only the fields you fill in are changed.

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