Connect Oracle Database to Plentyone

Both apps 31Oracle Database 12Plentyone 19

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

• Action
  Add contact

  Creates a new contact (a person) in the plentyONE CRM.

• Action
  Add item

  Creates an item in plentyONE together with its main variation, linked to a category and a unit.

• Action
  Add order

  Creates an order (sales order, return, offer and other order types) in plentyONE with its items, addresses and contact relations.

• Action
  Add payment

  Creates a payment in plentyONE, for example an incoming payment received through a payment method.

• Action
  Add variation

  Creates a new variation of an existing item, optionally defined by attribute values and made visible in a store client.

• Action
  Find items by criteria

  Finds items updated on or after a given time, optionally including their variations.

• Action
  Get contact

  Returns a single contact (person) from the plentyONE CRM by its id.

• Action
  Get item

  Returns a single plentyONE item, including its global settings, free fields and main variation id.

• Action
  Get order

  Returns a single order by its id, including its amounts, properties, addresses and order items.

• Action
  Get payment

  Returns a single payment by its id, including amount, currency, payment method, status and properties.

• Action
  List categories

  Returns the categories set up in PlentyONE, optionally only those of one type such as item categories.

• Action
  List contacts

  Returns the contacts (people) saved in your PlentyONE system, with their contact options and linked accounts.

• Action
  List stock

  Returns the stock levels of variations across all warehouses.

• Action
  List variations

  Returns the variations of an item, including its main variation.

• Action
  List warehouses

  Returns all warehouses set up in your PlentyONE system.

• Action
  Update contact

  Updates an existing contact (person) in PlentyONE CRM. Only the fields you fill in are changed.

• Action
  Update item

  Updates the item-level settings of an existing plentyONE item, such as manufacturer, condition, flags and customs data.

• Action
  Update order

  Updates an existing plentyONE order, such as its status, owner, properties, dates, addresses or order items.

• Action
  Update variation

  Updates an existing variation of an item in plentyONE, such as its number, availability, dimensions, weight or order quantities.

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