Connect Oracle Database to Cirkus

Both apps 23Oracle Database 12Cirkus 11

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

  Creates a new booking in Cirkus, optionally scheduling people or resources on it and linking it to projects, subprojects and tasks.

• Action
  Add company

  Creates a new company in a Cirkus workspace.

• Action
  Add contact

  Creates a new contact in a Cirkus workspace, optionally linked to a company.

• Action
  Create Calendar Event

  Adds a calendar event to a Cirkus booking, scheduling a person or resource for a given activity between a start and end time.

• Action
  Create Project

  Creates a new project in a Cirkus workspace, optionally linked to a company, contact or project template.

• Action
  Delete project

  Deletes a Cirkus project.

• Action
  Get project

  Returns a Cirkus project by its ID, including its dates, owner, linked company and contact, task counts and custom field values.

• Action
  Update booking

  Updates an existing Cirkus booking — its name, description, color, schedule status, booked events, linked projects and tasks, and custom fields. Fields left blank are not changed.

• Action
  Update company

  Updates an existing company in Cirkus — its name, description, active status, template link and custom field values. Fields left blank are not changed.

• Action
  Update contact

  Updates an existing contact in Cirkus, such as its name, email, phone, company or active status, and returns the updated contact.

• Action
  Update Project

  Updates an existing Cirkus project, such as its name, dates, owner, linked company or contact, status and custom fields. Fields left blank keep their current values.

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