Connect ProSMS.se and SQL Server

Both apps 31ProSMS.se 20SQL Server 11

• Trigger
  New Contact

  Triggers when a new contact is added to the account.

• Trigger
  New Group

  Triggers when a new contact group is created.

• Action
  Add Mobile Number to SMS Group

  Adds a phone number to an SMS group.

• Action
  Create Contact

  Creates a contact with a phone number and name, optionally placing it in a group.

• Action
  Create New Group

  Creates a new contact group.

• Action
  Delete Contact

  Deletes a contact by its ID or phone number.

• Action
  Delete Group

  Deletes a group. Only empty groups can be deleted.

• Action
  Delete Scheduled SMS

  Deletes future scheduled SMS messages that share a batch ID or your reference.

• Action
  Get Contact by ID

  Returns a contact and the groups it belongs to, by contact ID.

• Action
  Get Contact by Phone Number

  Returns a contact and the groups it belongs to, by phone number.

• Action
  Get Credit Balance

  Returns the account's remaining SMS credit balance.

• Action
  List Contacts

  Returns the account's contacts, a page at a time.

• Action
  List Groups

  Returns all contact groups with their member counts.

• Action
  List Sender Names

  Returns the sender names approved on the account.

• Action
  List SMS Log

  Returns sent and scheduled SMS messages from up to the last 3 months, filtered by receiver, dates, reference or batch.

• Action
  Remove Contact from Group

  Removes a phone number from a group without deleting the contact.

• Action
  Send Group SMS

  Sends an SMS to every contact in a group.

• Action
  Send SMS

  Sends an SMS to one recipient phone number from one of your approved sender names.

• Action
  Update Contact

  Updates a contact's name or phone number, found by its current phone number.

• Action
  Update Group

  Renames a group.

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