Connect ChargeOver and Oracle Database

Both apps 33ChargeOver 21Oracle Database 12

• Trigger
  Contact Was Updated

  Triggers when a contact is updated in ChargeOver.

• Action
  Add item

  Create an item (product or discount).

• Action
  Add note

  Add a note to a customer, invoice, etc.

• Action
  Add Transaction

  records a payment, refund or credit against a customer (e.g. transaction_type=pay, gateway_method=check, amount) without charging a payment gateway. Creates a transaction record.

• Action
  Cancel a Subscription

  Cancel an existing subscription in ChargeOver.

• Action
  Create a Contact

  Create a new contact in ChargeOver.

• Action
  Create a Customer

  Create a new customer in ChargeOver.

• Action
  Create an Invoice

  Create a new Invoice in ChargeOver.

• Action
  Create a Subscription

  Create a new subscription in ChargeOver.

• Action
  Delete Item

  deletes an item (product/discount) by id.

• Action
  Find Contact

  Finds an existing contact by a specified field.

• Action
  Find Customer

  Finds an existing customer by a specified field.

• Action
  Find Item (Product, Discount)

  Finds an existing item (product, discount) by a specified field.

• Action
  Find Subscription

  Finds an existing subscription by a specified field.

• Action
  List Notes

  Lists the notes attached to a ChargeOver record (customer, invoice, subscription, contact), filtered by record type and record ID.

• Action
  Update a Customer

  Update a existing customer in ChargeOver.

• Action
  Update contact

  Update a user/contact.

• Action
  Update invoice

  Update an invoice.

• Action
  Update item

  Update an item.

• Action
  Update subscription

  Update a subscription (package).

• Action
  Void Transaction

  marks an existing transaction voided in ChargeOver (logs an externally-voided transaction; does not contact the gateway), changing its status.

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