Connect SignalWire and SQL Server

Both apps 29SignalWire 18SQL Server 11

• Trigger
  New Phone Calls

  Triggers when a new phone call is placed or received in your SignalWire project.

• Trigger
  New Recordings

  Triggers when a new call recording is created in your SignalWire project.

• Trigger
  New Text Messages

  Triggers when a new text message arrives at one of your SignalWire numbers.

• Action
  Delete Message

  Deletes a message record from your project.

• Action
  Delete recording

  Deletes a call recording from your SignalWire project.

• Action
  Find Phone Numbers

  Returns the phone numbers your project owns, optionally filtered by number or name.

• Action
  Get Call

  Returns one phone call by its SID.

• Action
  Get Message

  Returns one text or multimedia message by its SID.

• Action
  Get recording

  Returns the details of a single call recording, such as its duration, status and the call it belongs to.

• Action
  Hang Up Call

  Ends an in-progress phone call.

• Action
  List calls

  Returns calls on your SignalWire project, optionally filtered by number, status or start/end time.

• Action
  List messages

  Returns the text and multimedia messages in your SignalWire project, optionally filtered by date, sender, recipient or status.

• Action
  List recordings

  Returns the saved voice recordings from your calls and conferences, newest first, optionally filtered by call, conference or creation date.

• Action
  Make Calls

  Places an outbound phone call that runs the call instructions at the URL you give.

• Action
  Send a Multimedia Message

  Sends an MMS message with a media attachment from one of your SignalWire numbers.

• Action
  Send a Text Message

  Sends an SMS text message from one of your SignalWire numbers.

• Action
  Update call

  Redirects an active call to new cXML instructions, cancels a queued call, or completes an in-progress call. Returns the updated call.

• Action
  Update phone number

  Updates the name and inbound call, SMS and fax routing of a phone number in your SignalWire project.

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