Connect Oracle Database and UpKeep

Both apps 45Oracle Database 12UpKeep 33

• 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
  New Purchase Order

  Triggers when a new purchase order is created.

• Trigger
  New Work Order

  Triggers when a new work order is created.

• Action
  Add Asset

  Create a new asset.

• Action
  Add Location

  Creates a new location in UpKeep.

• Action
  Add User

  Creates a new user in your UpKeep account.

• Action
  Add Vendor

  Create a new vendor.

• Action
  Create Purchase Order

  Creates a purchase order in UpKeep.

• Action
  Create Work Order

  Creates new work order.

• Action
  Delete Purchase Order

  Deletes a specific purchase order in UpKeep.

• Action
  Delete Work Order

  Deletes a specific work order in UpKeep.

• Action
  Find Asset

  Finds assets matching the given name, barcode, serial number, location, status, category or other criteria. Returns the first match plus the list of all matches on the first page of results.

• Action
  Find Location

  Returns the locations whose name matches the name you supply, optionally narrowed by parent location, creator, hierarchy level, custom field and created/updated dates.

• Action
  Find Part

  Finds parts in UpKeep by name.

• Action
  Find Vendor

  Returns the vendors whose business name matches the one supplied, with the first match broken out.

• Action
  Get Asset

  Gets a specific UpKeep asset by its ID, including its custom field values.

• Action
  Get Location

  Gets a specific UpKeep location by its ID.

• Action
  Get Part

  Gets a specific part from the UpKeep inventory by its ID.

• Action
  Get Purchase Order

  Gets a specific purchase order by its ID.

• Action
  Get User

  Gets a specific UpKeep user by ID.

• Action
  Get Vendor

  Gets a specific vendor by its ID.

• Action
  Get Work Order

  Retrieve a single work order by ID.

• Action
  List Assets

  Lists the assets in your UpKeep account, optionally filtered by name, barcode, serial number, location, status, category, assigned or creating user, downtime status, one custom field, and created/updated time ranges.

• Action
  List Locations

  Lists the locations in your UpKeep account, optionally filtered by name, creator, parent location, hierarchy level, custom field or created/updated date.

• Action
  List Purchase Orders

  Lists purchase orders in the UpKeep account, optionally filtered by status.

• Action
  List Vendors

  List/page all vendors.

• Action
  List Work Orders

  List/page all work orders with filters.

• Action
  Update Asset

  Updates the fields you supply on an existing UpKeep asset. Fields left blank are not changed.

• Action
  Update Location

  Updates an existing location in UpKeep. Only the fields you fill in are changed.

• Action
  Update Part

  Updates an existing part in UpKeep. Only the fields you fill in are changed.

• Action
  Update Purchase Order

  Updates an existing purchase order in UpKeep. Only the fields you fill in are changed.

• Action
  Update User

  Updates an existing UpKeep user. Only the fields you fill in are changed; blank fields are left as they are.

• Action
  Update Vendor

  Update fields on an existing vendor.

• Action
  Update Work Order

  Update fields on an existing work order.

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