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

Setup integration Explore templates

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.

All Microsoft SQL Server's templates See other templates

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

    Execute query with data set return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Array [Object]
  • GET

    Execute query with scalar return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Object
    • Data operations
  • GET

    Delete items from table

    Parameters:

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

    Returns:

    • rowsAffected, Integer
  • GET

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

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

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

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

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

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

    Create new table

    Parameters:

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

    Returns:

    • tableMetadata, Object
    • success, Boolean
    • reason, String
  • GET

    Delete table

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • success, Boolean
    • reason, String
  • GET

    Returns table metadata by name

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • tableName, String
    • fieldsMetadata, Array [Object]
  • GET

    Get tables list for database

    Parameters:

    • Connection string, String

    Returns:

    • tablesMetadata, Array [Object]
    • databaseName, String
    • success, Boolean
    • reason, String
    • Stored procedures
  • GET

    Execute procedure and returns array of results

    Parameters:

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

    Returns:

    • isSuccess, Boolean
    • result, Object
  • GET

    Execute stored procedure with single return value

    Parameters:

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

    Returns:

    • isSuccess, Boolean
    • result, Object
  • GET

    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

ALL RIGHTS RESERVED. COPYRIGHT © 2017-2020 [Onlizer]