Connect Oracle Database and Pics.io

Both apps 33Oracle Database 12Pics.io 21

• 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
  Assets Added to Collection

  Triggers when an asset is added to the selected Pics.io collection (including its nested collections).

• Trigger
  Assets Color Changed

  Triggers when the color label on an asset in your Pics.io library is set or changed.

• Trigger
  Assets Flag Changed

  Triggers when an asset's flag changes to flagged, unflagged or rejected in your Pics.io library.

• Trigger
  Assets Metadata Changed

  Triggers when an asset's metadata (title, description, keywords, custom fields and other details) is changed in Pics.io.

• Trigger
  Assets Moved to Collection

  Triggers when assets are moved into the chosen collection (or any collection inside it).

• Trigger
  Assets Raiting Changed

  Triggers when an asset's star rating is changed in your Pics.io library.

• Trigger
  Metadata Processing Completed

  Triggers when Pics.io finishes processing an asset's file metadata, including when metadata is reprocessed for an existing asset.

• Trigger
  New Asset

  Triggers when a new asset is added to your Pics.io library, optionally limited to a collection, inbox, lightboard, type or other filters.

• Trigger
  New Collection

  Triggers when a new collection is created directly inside the collection you choose (pick the root to watch top-level collections).

• Trigger
  New Comment

  Triggers when a new comment is added to an asset in your Pics.io library.

• Action
  Add assets to collection

  Adds one or more Pics.io assets to a collection, or moves them into it so they leave their other collections.

• Action
  Add keyword

  Creates a new keyword in the Pics.io keyword tree, optionally nested under a parent keyword.

• Action
  Create Collection

  Creates a new collection in Pics.io, optionally nested inside an existing parent collection.

• Action
  Delete collection

  Deletes a collection from your Pics.io library.

• Action
  Find assets

  Returns the assets in your Pics.io library that match a text search and optional filters such as collection, type, flag, rating, color or creation date.

• Action
  Find collections

  Returns the collections whose name or description contains the text you search for.

• Action
  Find keywords

  Returns the keywords in your Pics.io account whose name matches the search text.

• Action
  Get assets

  Returns the full details of one or more Pics.io assets by their IDs.

• Action
  List custom fields

  Returns every custom field defined in your Pics.io workspace, including each field's title, type, visibility and allowed options.

• Action
  Update asset

  Updates an existing Pics.io asset by ID — its file name, title, description, rating, flag and color label — and returns the updated asset. Fields left blank are not changed.

• Action
  Update custom field values on assets

  Sets the value of one custom field on one or more Pics.io assets at once.

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