Connect Call Loop 2.0 and SQL Server

Both apps 26Call Loop 2.0 15SQL Server 11

• Trigger
  Contact Added to List

  Triggers when a contact is added to the selected Call Loop list.

• Trigger
  Contact Created or Updated

  Triggers when a contact is created or updated in Call Loop.

• Action
  Add list

  Creates a new contact list in Call Loop and returns the created list.

• Action
  Create (Update) Contact

  Creates a contact, or updates the existing contact with the same phone number, and returns the saved contact.

• Action
  Delete contact

  Permanently deletes one or more contacts by ID and returns a confirmation with the number deleted.

• Action
  Find contacts by search term

  Returns the Call Loop contacts that match a search term, optionally narrowed by status and subscription state.

• Action
  Get contact

  Returns one Call Loop contact by its ID, including its status, subscription state, lists, custom field values and messaging activity. An error occurs if the contact is not found.

• Action
  Get message

  Returns a message's current delivery status and details, looked up by its ID or state UUID. An error occurs if the message is not found.

• Action
  List contacts

  Returns the contacts in your Call Loop organization, optionally filtered by status, search text or subscription state. Deleted contacts are not included.

• Action
  Send Ringless Voicemail

  Queues a ringless voicemail drop to a phone number using an audio file already in your Call Loop account. Returns the queued message and its delivery state.

• Action
  Send SMS / MMS Message

  Queues one SMS or MMS message to a phone number from a number on your Call Loop account, and returns the queued message with its status.

• Action
  Send Voice Broadcast

  Queues one outbound voice call to a phone number, playing an uploaded audio file on live answer, as a voicemail, or both. Returns the queued message and its status.

• Action
  Update contact

  Updates an existing Call Loop contact by ID, changing only the fields you fill in, and returns the saved contact.

• Action
  Update list

  Renames an existing contact list and returns the updated list.

• Action
  Update Opt-In Status

  Sets whether one contact is subscribed to text messages and to calls and ringless voicemail. No message is sent.

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