Connect Oracle Database and Syncro

Both apps 27Oracle Database 12Syncro 15

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

  Triggers when a new customer is created in Syncro.

• Trigger
  New Invoice

  Triggers when a new invoice is created in Syncro.

• Trigger
  New RMM Alert

  Triggers when a new RMM alert is raised on a monitored asset in Syncro.

• Trigger
  Ticket Status Changed

  Triggers when a Syncro ticket moves to a different status.

• Action
  Create Appointment

  Creates an appointment in Syncro, optionally linked to a customer, ticket and technicians.

• Action
  Create Contact

  Creates a contact under an existing Syncro customer.

• Action
  Create Customer

  Creates a new customer in Syncro with contact details, address, and notification preferences.

• Action
  Create Estimate

  Creates an estimate for a customer in Syncro, optionally with line items.

• Action
  Create Lead

  Creates a new lead in Syncro with the contact details and optional ticket information you provide.

• Action
  Create Ticket

  Creates a ticket for a customer in Syncro.

• Action
  Create Ticket Timer Entry

  Logs a time entry against a Syncro ticket, recording when work started and ended (or how long it took) and any notes.

• Action
  Find Customer

  Finds customers by search text, email, name, business name or ID and returns the matching customers.

• Action
  Update Contact

  Updates an existing contact in Syncro, changing its name, address, email, phone and other details.

• Action
  Update Customer

  Updates an existing customer in Syncro. Only the fields you fill in are changed.

• Action
  Update Ticket

  Updates an existing Syncro ticket's subject, status, assignment, dates and other details. 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.