Connect Myphoner to SQL Server

Both apps 36Myphoner 25SQL Server 11

• Trigger
  Archived Lead

  Triggers when a lead is archived (marked 'archive').

• Trigger
  Call Back

  Triggers when a lead is marked for 'call back'.

• Trigger
  Lead updated (instant)

  Fires when a lead's information is updated by an agent (webhook event: lead_updated).

• Trigger
  Lost Lead

  Triggers when a lead is lost (marked 'loser').

• Trigger
  New call (instant)

  Fires when a new call is conducted (webhook event: new_call).

• Trigger
  New call recording (instant)

  Fires when a new call recording becomes available (webhook event: new_recording).

• Trigger
  New comment (instant)

  Fires when a new comment is created for a lead (webhook event: new_comment).

• Trigger
  New lead (instant)

  Fires when a new lead is created in Myphoner (webhook event: lead_created).

• Trigger
  New Winner

  Triggers when a lead is won.

• Trigger
  Text message received (instant)

  Fires when a text message is received from a lead (webhook event: inbound_text).

• Trigger
  Text message sent (instant)

  Fires when a text message is sent to a lead (webhook event: text).

• Action
  Archive a lead

  Archives a lead in Myphoner, optionally recording a comment and archive category, or scheduling the lead to come back for a call later.

• Action
  Create a list

  Creates a new lead list in Myphoner, optionally defining its columns.

• Action
  Create Lead

  Creates a lead in a Myphoner list. The lead's fields are the columns defined on the chosen list.

• Action
  Find Lead

  Searches Myphoner for a lead matching your text and returns the first match, optionally limited to certain lists.

• Action
  Get a lead

  Returns one Myphoner lead by its ID, including every column defined on the lead's list.

• Action
  Get a list

  Returns one Myphoner list by its ID, with its name, lead count and the categories configured for each lead state.

• Action
  List leads

  Returns a page of leads from a Myphoner list, newest-updated first when you ask for that order.

• Action
  List lists

  Returns every lead list in the Myphoner account, with each list's name, ID and lead count.

• Action
  Mark Lead as Loser

  Marks a Myphoner lead as lost, optionally recording a comment and loser category or scheduling it to come back for a call later.

• Action
  Mark Lead as Winner

  Marks a Myphoner lead as won, optionally recording a comment and winner category or scheduling it to come back for a call later.

• Action
  Mark Lead for Call Back

  Schedules a Myphoner lead for a call back, optionally recording a comment and category and setting when the lead should come back.

• Action
  Move a lead to another list

  Moves a Myphoner lead into a different list, optionally releasing it back to the calling queue.

• Action
  Search for Lead

  Searches Myphoner leads for your text and returns every match, optionally limited to certain lists.

• Action
  Update Lead

  Updates a lead in Myphoner. Only the fields you fill in are changed; the lead's fields are the columns defined on its list.

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