Connect ShareFile and SQL Server

Both apps 30ShareFile 19SQL Server 11

• Trigger
  New Client

  Triggers when a new client user is added to the ShareFile account.

• Action
  Add group

  Creates a new distribution group in ShareFile, optionally shared and with initial member contacts.

• Action
  Add Note

  Creates a note inside a ShareFile folder with a title and optional text.

• Action
  Add share

  Creates a new Send share (sharing files) or Request share (asking recipients to upload into a folder) in ShareFile.

• Action
  Add URL

  Adds a web link (URL) item to a ShareFile folder.

• Action
  Add user

  Creates a new employee user in your ShareFile account and returns the new user.

• Action
  Copy item

  Copies a file or folder into another ShareFile folder.

• Action
  Create Client User

  Creates a new client user in your ShareFile account.

• Action
  Create Folder

  Creates a new folder inside a ShareFile parent folder and returns the new folder.

• Action
  Delete item

  Deletes a file or folder from ShareFile.

• Action
  Find items by name

  Searches ShareFile for files and folders whose name matches the text you enter, and returns the matching items.

• Action
  Get file download link

  Returns a temporary download link for a ShareFile file. For a folder, the link downloads a ZIP archive of its contents.

• Action
  Get item

  Returns a single ShareFile item (file, folder, note or link) by its id.

• Action
  Get user

  Returns a ShareFile user by ID or email address, or the connected user when neither is given.

• Action
  List folder children

  Returns the files, folders, notes and links directly inside a ShareFile folder.

• Action
  List groups

  Returns the distribution groups you have permission to view in your ShareFile account.

• Action
  List shares

  Returns the outstanding Send and Request shares created by the connected ShareFile user.

• Action
  List users

  Returns the employee users in your ShareFile account.

• Action
  Update item

  Updates a ShareFile file, folder, note or link: rename it, change its description or expiration date, or move it to another folder or zone.

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