Connect Oracle Database and Recharge

Both apps 52Oracle Database 12Recharge 40

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

  Triggers when a Recharge customer becomes active (gains an active subscription) or inactive (no active subscriptions left).

• Trigger
  New Address Created

  Triggers when a new address is added for a customer.

• Trigger
  New Cancelled Subscription

  Triggers when a subscription is cancelled.

• Trigger
  New Charge Created

  Triggers when a new charge is created in Recharge.

• Trigger
  New Customer

  Triggers when a new customer is added to your Recharge store.

• Trigger
  New Order

  Triggers when a new order is created in Recharge.

• Trigger
  New Subscription

  Triggers when a new subscription is created.

• Action
  Activate Subscription

  Reactivates a cancelled subscription.

• Action
  Cancel Subscription

  Cancels an active subscription with a reason.

• Action
  Change Next Charge Date

  Changes the next charge date of a subscription.

• Action
  Create Customer

  Creates a customer in Recharge and returns the new customer's ID.

• Action
  Create Discount Codes

  Creates a discount code in Recharge.

• Action
  Create One Time Charge

  Adds a one-time product to an address's upcoming charge.

• Action
  Delete Address

  Deletes a Recharge address that has no active subscriptions.

• Action
  Delete Customer

  Deletes a Recharge customer, which also cancels and deletes their subscriptions and addresses.

• Action
  Delete One Time Charge

  Deletes an unprocessed one-time product.

• Action
  Delete Order

  Deletes a queued (scheduled) order.

• Action
  Delete Subscription

  Permanently deletes a subscription.

• Action
  Find a Charge

  Returns one charge by ID, with its status, schedule and total.

• Action
  Find an Address

  Finds Recharge addresses by customer, address ID, discount, active status or date range.

• Action
  Find a Subscription

  Finds subscriptions matching a customer, address, product variant, status or ID, and returns the first match plus the full list.

• Action
  Find Customer

  Finds a Recharge customer by email or ecommerce customer ID.

• Action
  List Addresses

  Returns addresses, optionally for one customer.

• Action
  List Charges

  Returns charges, optionally filtered by customer or status.

• Action
  List Customers

  Returns a list of customers in your Recharge store.

• Action
  List One-Time Charges

  Returns one-time products, optionally for one customer or address.

• Action
  List Orders

  Returns orders, optionally filtered by customer or status.

• Action
  List Subscriptions

  Returns subscriptions, optionally filtered by customer or status.

• Action
  Process Charge

  Processes a queued charge immediately (Recharge Plus plan).

• Action
  Retrieve Address

  Returns one Recharge address by ID.

• Action
  Retrieve Customer

  Returns one Recharge customer by ID, with their name, email, phone and active subscription count.

• Action
  Retrieve Discount

  Returns one discount by ID.

• Action
  Retrieve One-Time Charge

  Returns one one-time product by ID.

• Action
  Retrieve Order

  Returns one Recharge order by ID, including its line items.

• Action
  Skip Charge

  Skips an upcoming charge.

• Action
  Unskip Charge

  Unskips a previously skipped charge.

• Action
  Update Address

  Updates a Recharge shipping address.

• Action
  Update Customer

  Updates a Recharge customer's name, email or phone.

• Action
  Update One-Time Charge

  Updates a one-time product's quantity, price or charge date.

• Action
  Update Order Line Items

  Replaces the line items on an existing Recharge order and returns the updated order.

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