Connect Sirv and SQL Server

Both apps 45Sirv 34SQL Server 11

• Trigger
  New File

  Triggers when a new file appears in a folder of your Sirv account, and hands on that file's name, type, size and dimensions.

• Trigger
  New Tagged File

  Triggered when a new file carrying the chosen tag appears in your Sirv account.

• Action
  Add Advanced Watermark

  Builds the Sirv image URL that shows one of your images with a watermark laid over it, using the position, size, opacity and rotation you choose.

• Action
  Add Canvas or Border

  Puts a coloured canvas and/or border around a Sirv image and returns the new image URL. Nothing is re-uploaded — the original file is untouched.

• Action
  Add Tags to File

  Adds meta tags to a file in your Sirv account.

• Action
  Apply Color Effects

  Adjusts the colours of a Sirv image — hue, saturation, lightness, tint, tone and levels — and returns the new image URL. The original file is untouched.

• Action
  Convert Spin to Video

  Turns a 360 spin stored in your Sirv account into an MP4 video and returns the path of the video that was created.

• Action
  Convert Video to Spin

  Converts a video in your Sirv account into a 360-degree spin and returns the spin that was created.

• Action
  Copy File

  Copies a file in your Sirv account to another path, leaving the original in place.

• Action
  Create Folder

  Creates an empty folder in your Sirv account at the path you give.

• Action
  Create Thumbnail

  Builds the Sirv image URL that serves a resized, optionally cropped thumbnail of one of your images.

• Action
  Delete File

  Deletes a file, or an empty folder, from your Sirv account.

• Action
  Delete file tags

  Removes one or more tags from a file in your Sirv account.

• Action
  Download File

  Downloads a file from your Sirv account and returns its contents.

• Action
  Fetch File From URL

  Pulls a file from a web address straight into your Sirv account, saving it at the path you choose, and reports whether the fetch succeeded.

• Action
  Find File

  Searches the files in your Sirv account by name, folder, type, size, tags, description or date, and returns the matching files.

• Action
  Get API Limits

  Returns your Sirv API rate limits and how much of each you have used.

• Action
  Get batch delete job

  Returns the progress and results of a batch delete job you started earlier.

• Action
  Get CDN URL

  Returns the public web address of a file in your Sirv account.

• Action
  Get File Info

  Returns the details Sirv holds on one file — its type, size, dates and image information.

• Action
  Get File Metadata

  Returns everything Sirv stores about a file: its title, description, tags, product details and any other metadata held against it.

• Action
  Get File Tags

  Returns the tags attached to a file in your Sirv account.

• Action
  Get product metadata

  Returns the product information stored on a file in your Sirv account.

• Action
  Get Storage Info

  Returns how much storage your Sirv account is using and how much it is allowed.

• Action
  Get Usage Report

  Returns how much your Sirv account has served — the number of file requests and the bytes transferred, broken down by day.

• Action
  Get ZIP Job

  Returns the progress and results of a zip job, including the archive it produced.

• Action
  List Folder Contents

  Lists the files and sub-folders inside a folder of your Sirv account, with each item's name, size, type and when it was last changed.

• Action
  Make API Call

  Makes any Sirv API call you specify, for endpoints that do not yet have their own action. You supply the method, the path and any data; the connected account's credentials are applied for you.

• Action
  Rename or Move File

  Renames a file or folder, or moves it to another folder, by giving its new path.

• Action
  Set File Metadata

  Sets the title, description, tags and product details held against a file in your Sirv account. Anything left blank is left as it is.

• Action
  Set Product Metadata

  Attaches product details — code, name, brand and categories — to a file in your Sirv account.

• Action
  Update account

  Changes your Sirv account settings — file minification and where missing files are fetched from. Only the settings you fill in are sent; the rest are left as they are.

• Action
  Upload File

  Uploads a file to your Sirv account from a web address.

• Action
  Zip Files

  Starts a job that packs the files and folders you name into a single zip in your Sirv account, and returns the job so you can check when it is ready.

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