Connect Twilio and SQL Server

Both apps 26Twilio 15SQL Server 11

• Trigger
  New Call

  Polls for voice calls on your Twilio account.

• Trigger
  New Incoming Call

  Fires instantly when the selected Twilio phone number receives a call.

• Trigger
  New Message Received

  Polls for inbound SMS/MMS messages received by your Twilio account.

• Trigger
  New SMS received

  Fires instantly when the selected Twilio phone number receives an SMS/MMS. Activating the automation points the number's incoming-message webhook at this automation; deactivating clears it.

• Action
  Delete Message

  Deletes a message from your Twilio account's message logs.

• Action
  Find available phone numbers by criteria

  Returns up to 50 phone numbers available to buy in a country that match the specified criteria (area code, pattern, capabilities, location).

• Action
  Get Call

  Retrieves details of a single voice call by its Call SID.

• Action
  Get Message

  Retrieves a single SMS/MMS message by its Message SID.

• Action
  List Calls

  Lists voice calls on the account, optionally filtered by To, From, or status.

• Action
  List Messages

  Lists SMS/MMS messages on the account, optionally filtered by To, From, or date sent.

• Action
  List Phone Numbers

  Lists the Twilio phone numbers (incoming phone numbers) owned by your account.

• Action
  Lookup Phone Number

  Looks up details (carrier, line type, caller name) for a phone number via the Twilio Lookup v2 API.

• Action
  Schedule Message

  Schedules an SMS or MMS message to be sent later through one of your Messaging Services. A scheduled message can be canceled with Update Message until it is sent.

• Action
  Update Message

  Updates a Twilio Message: replaces or redacts its text, or cancels a scheduled message that has not been sent yet.

• Action
  Update Phone Number

  Update settings (voice/SMS URLs, friendly name) of an owned incoming phone number.

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