Microsoft SQL Server

Query and manage data in a Microsoft SQL Server Database

Component key: ms-sql-server

Description#

The MS SQL component makes a request to any Microsoft SQL Server database, then returns the response and rows affected. Instead of generating dynamic queries and sanitizing SQL yourself, you can pass in a generic query with @variableKey placeholders. For example, you can create a query that reads INSERT INTO users (name, email) VALUES (@name, @email), and for optional parameters you can create one with a key of name, and another with a key of email. Values provided for name and email are sanitized automatically.

Authorization Methods#

Microsoft SQL Server requires one of the following authorization methods:

Auth TypeKeyDescriptionFields
Basic AuthbasicBasic authorization using a username/password combination

Password |  password

Username |  username

The MS SQL Server username and password can be put directly into a basic auth credential, alongside the database host, port, and database name.

Actions#

Query#

Interact with a Microsoft SQL Server Database | key: query

InputKeyDefaultNotesExample

Database

string
/ Required
databasemsdb

Host

string
/ Required
host192.168.0.1

Parameters

data
paramsOptional parameters to insert into a query.

Port

string
/ Required
port14331433

Query

string
/ Required
queryFieldSELECT * FROM Customers WHERE customerId = @id