Connect Kustomer and Oracle Database

Both apps 39Kustomer 27Oracle Database 12

• Trigger
  Conversation Created

  Triggers when a new conversation is created in Kustomer.

• Trigger
  Conversation Updated

  Triggers when a Kustomer conversation is created or updated.

• Trigger
  Customer Created

  Triggers when a new customer is created in Kustomer.

• Trigger
  Customer Updated

  Triggers when a Kustomer customer is created or updated.

• Trigger
  Message Created

  Triggers when a new message is sent or received in Kustomer.

• Trigger
  Message Updated

  Triggers when a Kustomer message is created or updated.

• Action
  Add custom object

  Creates a new custom object (KObject) of the chosen custom object type in Kustomer.

• Action
  Add message

  Adds a message to an existing Kustomer conversation; the message belongs to the conversation's customer.

• Action
  Create Company

  Creates a company in Kustomer that customers can be linked to.

• Action
  Create Conversation

  Creates a new conversation for a Kustomer customer, with an optional name, status and tags.

• Action
  Create Customer

  Creates a new customer in Kustomer with a name, email, phone and optional external ID.

• Action
  Create Notes

  Adds an internal note to a Kustomer conversation. Notes are visible to agents only, not the customer.

• Action
  Create User

  Invites a new agent user to your Kustomer org by name and email.

• Action
  Delete Customer

  Deletes a Kustomer customer by ID.

• Action
  Find Conversation

  Finds a Kustomer conversation by the external ID your own system gave it.

• Action
  Find Customer

  Finds a Kustomer customer by email address and returns their ID, name and phone.

• Action
  Find custom objects by criteria

  Returns the custom objects (KObjects) of a chosen Klass, optionally only those after a given date, sorted and limited to selected fields.

• Action
  Find User

  Finds a Kustomer agent user by email address.

• Action
  Get Company

  Returns one Kustomer company by ID.

• Action
  Get Conversation

  Returns one Kustomer conversation by ID, with its subject, status, customer and timestamps.

• Action
  Get Customer

  Returns one Kustomer customer by ID, with name, emails, phones and timestamps.

• Action
  Get message

  Returns a single Kustomer message by its ID, including its attributes and related conversation and customer.

• Action
  Get user

  Returns a Kustomer user (agent) by their ID, including name, email and other profile attributes.

• Action
  List teams

  Returns the teams in your Kustomer organization, optionally filtered by role group or deleted status.

• Action
  Update company

  Updates an existing Kustomer company's name, external ID, emails, phones, tags and custom attributes.

• Action
  Update Conversation

  Updates a Kustomer conversation's subject or status. Only the fields you fill in are changed.

• Action
  Update Customer

  Updates an existing Kustomer customer's name, email, phone or external ID. Only the fields you fill in are changed.

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