Connect Jumpseller and Oracle Database

Both apps 35Jumpseller 23Oracle Database 12

• Trigger
  Customer Created

  Triggers when a new customer registers into the store.

• Trigger
  Customer Updated

  Triggers when a customer is updated.

• Trigger
  Order Paid

  Triggers when a new order is paid.

• Trigger
  Order Updated

  Triggers when an order status is updated (from an initial "pending payment" to either a "paid", "canceled" or "abandoned" status).

• Trigger
  Product Created

  Triggers when a new product is created.

• Trigger
  Product Updated

  Triggers when a product is updated.

• Action
  Add Category

  Create a new Category.

• Action
  Add Customer

  Adds a new customer to your Jumpseller store.

• Action
  Create Product

  Creates a Product

• Action
  Create Product Variant

  Creates a new Product Variant

• Action
  Delete Customer

  Delete an existing Customer.

• Action
  Delete Product

  Delete an existing Product.

• Action
  Find Customer From Email

  Finds a customer in your Jumpseller store by their email address.

• Action
  Find Product

  Finds a Jumpseller Product, returning the full product details (including its variants)

• Action
  Find Product From SKU

  Finds a product given a SKU, ID or Barcode

• Action
  Get Customer

  Retrieve a single Customer by id.

• Action
  Get Product

  Retrieve a single Product by id.

• Action
  List Categories

  Retrieve all Categories.

• Action
  List Customers

  Retrieve all Customers.

• Action
  List Products

  Retrieve all Products in the store.

• Action
  Update Customer

  Updates an existing customer in your Jumpseller store.

• Action
  Update Product

  Updates a Product

• Action
  Update Product by SKU

  Updates a product given a SKU

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