Connect CRM PipeRun and Oracle Database

Both apps 36CRM PipeRun 24Oracle Database 12

• Trigger
  Lost Deal

  Triggers when a PipeRun deal is marked as lost.

• Trigger
  New Activity

  Triggers when a new activity is created in PipeRun.

• Trigger
  New Company

  Triggers when a new company is created in PipeRun.

• Trigger
  New Deal

  Triggers when a new deal is created in PipeRun.

• Trigger
  New Items

  Triggers when a new product, service or MRR item is created in PipeRun.

• Trigger
  New Person

  Triggers when a new person (contact) is created in PipeRun.

• Trigger
  Updated Deal

  Triggers when a deal in PipeRun is updated.

• Trigger
  Won Deal

  Triggers when a PipeRun deal is marked as won.

• Action
  Add Deal

  Creates a new deal in a PipeRun pipeline stage.

• Action
  Add note

  Adds a note in PipeRun, optionally linked to a deal, company, person or call.

• Action
  Create Activity

  Creates a new activity (task, call, meeting) in PipeRun.

• Action
  Create Company

  Creates a new company in PipeRun.

• Action
  Create Item

  Creates a new product, service or recurring (MRR) item in PipeRun.

• Action
  Create Person

  Creates a new person (contact) in PipeRun.

• Action
  Create Proposal

  Creates a new proposal on a PipeRun deal.

• Action
  Find companies

  Searches companies in PipeRun by name, CNPJ, website, external code and other filters, returning the matching company records.

• Action
  Find deals

  Finds deals (opportunities) in PipeRun matching the filters you supply, such as title, hash, status, pipeline, stage, owner, company or person.

• Action
  Find people

  Searches people in PipeRun by name, CPF, company, job title or other filters and returns the matching people.

• Action
  Get deal

  Returns the details of a single deal (opportunity) by its ID, optionally with related items, people, companies, custom forms and users.

• Action
  Update activity

  Updates an existing activity in PipeRun, such as its title, status, owner, dates or linked people and companies.

• Action
  Update company

  Updates an existing company in PipeRun. Only the fields you fill in are changed.

• Action
  Update deal

  Updates an existing deal (opportunity) in PipeRun, changing only the fields you fill in, including its custom fields.

• Action
  Update item

  Updates a product, service or recurring (MRR) item in your PipeRun catalog.

• Action
  Update person

  Updates an existing person (contact) in PipeRun, including contact details, address, tags and custom fields.

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