Connect Pipefile and SQL Server

Both apps 22Pipefile 11SQL Server 11

• Trigger
  File Request Created

  Triggers when a file request is created.

• Action
  Add File Request From Template

  Create a new file request from an existing template for one recipient (name/email/phone), optionally on behalf of a team member via X-Pipefile-On-Behalf-Of.

• Action
  Create Contact

  Add to contacts

• Action
  Delete Contact

  Delete a contact by id. Returns 204 No Content on success.

• Action
  Get Contact

  Retrieve one contact by id.

• Action
  Get File Request

  Retrieve detailed information about one file request by id, including contents, items, files, and tracking events.

• Action
  List Contacts

  Retrieve a paginated list of contacts, filterable by name/email/phone partial match.

• Action
  List File Request Templates

  Retrieve the list of file request templates available for creating new file requests, with optional name search.

• Action
  Search File Requests

  Finds all file requests matching this search query (contact name, email, tags, etc).

• Action
  Send Request

  Create and send a new request

• Action
  Update Contact

  Update name/email/phone of an existing contact by id.

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