Microsoft SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Using Microsoft SQL Server?

Easy connect Microsoft SQL Server with other services: CRM, webinars, email campaigns, calls, chat bots, Google Sheets, and other 150+ services

Connect Microsoft SQL Server with other services in few minutes

Easy integrate Microsoft SQL Server and connect realtime online data sync with other services: Pipedrive, WebinarJam, GetResponse, Google Sheets, SMS or voice calls, messengers and many more.

Templates for Microsoft SQL Server integration

It is much easier to configure Microsoft SQL Server's connection to other services using ready-made script templates. You can also create a new custom workflow using our visual constructor.

Microsoft SQL Server's triggers and actions

Operations triggers
  • Activate event after item deleted from table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object
  • Activate event after new item inserted in table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object
  • Activate event after existed item update in table

    Parameters:

      • Database connection string, String
      • Table name, String

    Returns:

    • tableName, String
    • item, Object
Custom query
  • Execute query with data set return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Array [Object]
  • Execute query with scalar return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Object
  • Data operations
  • Delete items from table

    Parameters:

    • Connection string, String
    • Table name, String
    • Filter, String

    Returns:

    • rowsAffected, Integer
  • Insert items into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean

    Returns:

    • rowsAffected, Integer
  • Insert single row into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Item to insert, Object
      • Enable identity insert, Boolean
      • Identity field name, String
      • Result format, Integer

    Returns:

    • updatedObject, Object
    • rowsAffected, Integer
  • Save items into table (using INSERT or UPDATE)

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean
      • Compare by fields, Array [String]

    Returns:

    • rowsAffected, Integer
  • Select data from table

    Parameters:

      • Connection string, String
      • Table name, String
      • Fields, String
      • Filter, String
      • Sort by, String
      • Result format, Integer

    Returns:

    • data, Array [Object]
    • count, Integer
  • Update items in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Update functions (e.g. Count=Count+2, Name='Test'), String
      • Filter, String

    Returns:

    • rowsAffected, Integer
  • Update single row in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Identity field name, String
      • Item to update, Object
      • Result format, Integer

    Returns:

    • updatedItem, Object
  • Database management
  • Create new table

    Parameters:

      • Connection string, String
        • Table name, String
        • Fields description, Array [Object]

    Returns:

    • tableMetadata, Object
    • success, Boolean
    • reason, String
  • Delete table

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • success, Boolean
    • reason, String
  • Returns table metadata by name

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • tableName, String
    • fieldsMetadata, Array [Object]
  • Get tables list for database

    Parameters:

    • Connection string, String

    Returns:

    • tablesMetadata, Array [Object]
    • databaseName, String
    • success, Boolean
    • reason, String
  • Stored procedures
  • Execute procedure and returns array of results

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure with single return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure without return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
 

Start your journey in world of limitless automation for free

You can test all features for free during 30-days trial period, no credit card required