Microsoft SQL Server

Unleash the power of your data—on-premises, in the cloud, or at the edge—and reveal insights to transform your business.

Integrate the Microsoft SQL Server API with the Twilio API

Setup the Microsoft SQL Server API trigger to run a workflow which integrates with the Twilio API. Pipedream's integration platform allows you to integrate Microsoft SQL Server and Twilio remarkably fast. Free for developers.

Send SMS with Twilio API on New Column from Microsoft SQL Server API
Microsoft SQL Server + Twilio
 
Try it
Send SMS with Twilio API on New Or Updated Row from Microsoft SQL Server API
Microsoft SQL Server + Twilio
 
Try it
Make a Phone Call with Twilio API on New Column from Microsoft SQL Server API
Microsoft SQL Server + Twilio
 
Try it
Make a Phone Call with Twilio API on New Or Updated Row from Microsoft SQL Server API
Microsoft SQL Server + Twilio
 
Try it
Send MMS with Twilio API on New Column from Microsoft SQL Server API
Microsoft SQL Server + Twilio
 
Try it
New Column from the Microsoft SQL Server API

Triggers when a new column is added to a table. See the documentation

 
Try it
New Or Updated Row from the Microsoft SQL Server API

Triggers when a new row is added or an existing row is updated. See the documentation

 
Try it
New Incoming SMS (Instant) from the Twilio API

Emit new event every time an SMS is sent to the phone number set. Configures a webhook in Twilio, tied to an incoming phone number.

 
Try it
New Call (Instant) from the Twilio API

Emit new event each time a call to the phone number is completed. Configures a webhook in Twilio, tied to a phone number.

 
Try it
New Phone Number from the Twilio API

Emit new event when you add a new phone number to your account

 
Try it
Execute Query with the Microsoft SQL Server API

Executes a SQL query and returns the results. See the documentation

 
Try it
Send SMS with the Twilio API

Send a simple text-only SMS. See the docs for more information

 
Try it
Insert Row with the Microsoft SQL Server API

Inserts a new row in a table. See the documentation

 
Try it
Make a Phone Call with the Twilio API

Make a phone call, passing text that Twilio will speak to the recipient of the call. See the docs for more information

 
Try it
Send MMS with the Twilio API

Send an SMS with text and media files. See the docs for more information

 
Try it

Overview of Microsoft SQL Server

With the Microsoft SQL Server API on Pipedream, you can automate your database operations and create powerful integrations. This API allows you to execute queries, manage databases, and trigger actions based on data changes. Implementing workflows that react to database events, manipulate data, or synchronize SQL Server data with other services, becomes effortless with Pipedream's serverless platform.

Connect Microsoft SQL Server

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
import sql from "mssql"
export default defineComponent({
  props: {
    microsoft_sql_server: {
      type: "app",
      app: "microsoft_sql_server",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database } = this.microsoft_sql_server.$auth
    const conn_str = `Server=${host},${port};Database=${database};User Id=${username};Password=${password};Encrypt=true`;
    await sql.connect(conn_str);
    return await sql.query`SELECT GETDATE()`
  },
})

Overview of Twilio

With the Twilio API, you can build telephone applications that make and receive
phone calls, as well astext messaging applications that send and receive text
messages.

Some examples of applications you could build include:

  • A phone call application that allows you to make and receive phone calls over
    the internet
  • A text messaging application that allows you to send and receive text
    messages over the internet
  • A voicemail application that allows you to leave and receive voicemails over
    the internet

Connect Twilio

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    twilio: {
      type: "app",
      app: "twilio",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.twilio.com/2010-04-01/Accounts.json`,
      auth: {
        username: `${this.twilio.$auth.AccountSid}`,
        password: `${this.twilio.$auth.AuthToken}`,
      },
    })
  },
})

Community Posts

How Our Family Uses SMS and Smart Picture Frames to Connect During Remote Holidays
How Our Family Uses SMS and Smart Picture Frames to Connect During Remote Holidays
Two days before Thanksgiving, I decided to put together a simple way for our family to share pictures, because we couldn’t be together in person. The idea: smart photo frames that everyone could text pictures to. Here’s how I got it working. tldr; A Pipedream workflow parses SMS messages sent to a Twilio phone number, extracting the pictures and then using SendGrid to email them to the dedicated email addresses used by our Pix-Star photo frames.