Connect SQL Server to Ortto

Both apps 25SQL Server 11Ortto 14

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

• Trigger
  Fields Updated

  Triggers when the specified field(s) of a record have been updated in your Ortto account.

• Trigger
  New Activity Occurred

  Triggers when a new Ortto activity occurs.

• Trigger
  New Record Created

  Triggers when a new record (contact or organization) has been added to your Ortto account.

• Trigger
  Tag Added/Removed

  Triggers when a tag has beed added to, or removed from, a record.

• Action
  Add Custom Field

  Create a new custom field on the person or organization schema in Ortto. Endpoint: POST /v1/custom-field/create. Vendor doc: https://help.ortto.com/developer/latest/api-reference/custom-field/

• Action
  Create Record

  Create a new record (person, organization), or update an existing record in your Ortto account.

• Action
  Delete Record

  Archive, restore, or permanently delete a person or organization record in Ortto. Endpoint: POST /v1/person/delete (and /v1/organization/delete for accounts). Vendor doc: https://help.ortto.com/a-260-archive-restore-and-delete-people-archive-restore-delete

• Action
  Get Record

  Fetches one or more people, or one or more accounts, by their Ortto ids, returning whichever fields you ask for.

• Action
  List Activities

  Retrieve the activity feed for a given contact in Ortto. Endpoint: POST /v1/person/activities/list (activity log for a contact ID). Vendor doc: https://help.ortto.com/a-773-retrieve-activity-feed-for-a-given-contact

• Action
  Opt Out From SMS

  Opt out a person from all SMS communications.

• Action
  Search or Create Records

  Search your Ortto data for a record based on the provided field or optionally create one if none is found.

• Action
  Tag/Untag Records

  Adds or removes tags on a person or an account in Ortto, matching the record by email address or account name.

• Action
  Unsubscribe a Person

  Unsubscribe a person from all emails.

• Action
  Update Audience Subscription

  Subscribe or unsubscribe a person to/from an Ortto audience. Endpoint: POST /v1/audience/subscribe. Vendor doc: https://help.ortto.com/developer/latest/api-reference/audiences/

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.