Connect Pics.io and SQL Server

Both apps 32Pics.io 21SQL Server 11

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

• 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 SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server 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 SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server 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.