Using Pushbullet API to send SMS messages in C #, PHP, Java or SQL Server (with CLR)

Views: 4.714 views

In this article

Reading Time: 8 minutes

Hello people,
Good afternoon!

In this post, I want to show you something new that I was able to develop this week and I found very cool, which is sending SMS messages from virtually any current programming language (C #, VB.NET, Java, PHP, etc.) and even , by the SQL Server database itself using SQL CLR (can also be done using xp_cmdshell).

This is especially useful for creating alerting and monitoring in production environments, where in case of any serious issues you can be notified, wherever you are, even if you are out of time with 3G or Wi-Fi.

You can use this to send an SMS to a company's business sector when a customer submits a quote request. If you have an online store, you can send torpedoes to your customers with status changes to an order, for example. The possibilities are many!

What is Pushbullet?

Pushbullet is a simple application with one main purpose: to transfer things from your smartphone to your computer and vice versa. You can send files and links to your phone, and get notifications from any smartphone associated with your PC account, such as when a friend checks in on Swarm, someone is calling you, or when your calendar reminds you about some compromise.

You can also send and receive SMS and reply to messages from WhatsApp, Facebook Messager, Hangouts, and others without touching your smartphone. It's easy: When someone sends a message via WhatsApp, an interactive notification will appear on your computer. Click Reply, type your message, and click Send.

Pushbullet also has some cool tricks, such as syncing the clipboard between devices, so you can cut text on your computer and paste it on your smartphone.

How does this solution work? How is the torpedo shipped?

The basic working of this functionality is as follows:

Through a programming language of your choice, you will send the request to the Pushbullet API, requesting the sending of SMS and informing the recipient number and the message.
The Pushbullet server will receive this request and direct you to the application associated with the device requested in your request.
The application of your selected mobile phone will receive the request from the server and use the SMS sending feature of your mobile phone.
SMS SMS successfully sent to recipient!

What are the requirements for this API to work?

Since the actual sending is from your mobile phone, messages sent by the API are available on your smartphone's SMS screen. In addition, you will need to have credits to send SMS as well as any regular SMS, or have a package with your mobile carrier that allows you to send these messages.

In my tests, I used my cell phone, where I have a Vivo 1 GB control plan and unlimited torpedoes for any carrier on any DDD, so that plan suits me perfectly. It even has some exclusive SMS packages that allow unlimited sending of messages for an even lower cost.

As you may have noticed, for this feature to work, the mobile device that will be responsible for sending the messages will always need to be on and have internet access.

What is the cost of this solution? Is there any shipping limit?

An important point to note is that the Pushbullet Free account only allows sending 500 pushes per month. To remove this limit and make it unlimited shipments, you will need to upgrade your Pushbullet account to the PRO version (https://www.pushbullet.com/pro) at a cost of $ 4,99 (dollars) per month or $ 3,33 (dollars) per month if you choose the annual plan. I find the value very fair and affordable.

I believe it is a very interesting solution and with a ZERO cost, for those who need a few shipments per month and already have a data pack with unlimited torpedo support in your phone.

Even if you have a need to send lots of SMS messages and you need to purchase a data packet with unlimited SMS + 1 GB internet 4G (actual 40 per month) and upgrade your Pushbullet account to PRO version (actual 10 per month) , the monthly cost for this solution is quite small (52 reais per month) and much lower than the business solutions that carriers and other companies offer in the market (and with a limit on the number of torpedoes sent).

I did a quick search on the internet and saw that some companies charge 100 reais per month to be able to send 1.000 torpedoes / month and some companies charge $ 0,16 per torpedo (500 torpedoes per month = 80 reais).

Creating your account and adding devices

To accomplish this activity, I will use the easy-to-use, well-documented Pushbullet API (https://docs.pushbullet.com/) to use to access all of these features using your favorite programming language.

The first step is to create your account on the app's website (https://www.pushbullet.com/). It supports integration with Facebook and Google, allowing the service to read your data from one of these two services and save you time by entering the registration data.

Once registered, add your mobile devices by downloading and installing the Pushbullet app on them. Once installed and logged in to Pushbullet through the app on your mobile phone, it will be added to your device list from your account.

Retrieving Access Token, User ID, and Device ID

Once you have created your account and added the devices, go to the Preferences screen (Settings - https://www.pushbullet.com/#settings) and in the “Access Tokens” section click on the “Create Access Tokens” button

After clicking the button, a code will be shown on your screen. Write down this code as it will be the passcode to authenticate the requests we will send.

Now that you have your Pushbullet account and you have your Access Token, we need to retrieve your user ID and the ID of your mobile device that will be used to send the messages.

To retrieve this information, I recommend downloading the cURL binary, available from this link (Windows) ou this link (Any OS) or the use of the extension Postman, Google Chrome (more convenient and better viewing results)

Once downloaded and installed (on Windows, copy the executable to the C: \ Windows directory), we will use cURL to retrieve our account ID using the command below:

curl --header "Access-Token: <seu_access_token>" https://api.pushbullet.com/v2/users/me -k

1	curl --header "Access-Token: <seu_access_token>" https://api.pushbullet.com/v2/users/me -k

or making the same request with Postman:

With that, write down the iden code returned. This is your user ID, as you can have multiple users associated with your account.

Now let's retrieve the ID of our mobile device, which will send the SMS, using the command below in cURL:

curl --header "Access-Token: <seu_access_token>" https://api.pushbullet.com/v2/devices -k

1	curl --header "Access-Token: <seu_access_token>" https://api.pushbullet.com/v2/devices -k

or by Postman:

Write down the iden code returned from your device. This is the device ID.

Developing SMS push solution with Pushbullet API

Now that we have the necessary ID's to send the SMS, we can start our SMS sending routine.

Solution written in C # programming language for use in SQL Server by CLR

Example:

Source code:

using System;
using System.Data.SqlTypes;
using System.IO;
using System.Net;
using System.Text;
using Bibliotecas.Model;

public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void stpEnvia_Torpedo(SqlString Nr_Numero, SqlString Ds_Mensagem)
    {


        if (Nr_Numero.IsNull)
            Retorno.Erro("Favor informar o número de telefone que irá receber a mensagem");

        if (Nr_Numero.Value.Length <= 9)
            Retorno.Erro("Favor informar o número de telefone com DDD");

        if (Ds_Mensagem.IsNull)
            Retorno.Erro("Favor informar a mensagem que será enviada");

        if (Ds_Mensagem.Value.Length > 160)
            Retorno.Erro("O tamanho máximo da mensagem a ser enviada por SMS é de 160 caracteres");



        try
        {

            
            const string AccessToken = "seu_access_token"; //https://www.pushbullet.com/#settings
            const string UserIdentity = "token_usuario"; //curl --header "Access-Token: access_token" https://api.pushbullet.com/v2/users/me
            const string DeviceIdentity = "token_do_dispositivo"; //curl--header "Access-Token: access_token" https://api.pushbullet.com/v2/devices


            var dsScript = @"{
    ""push"": {
        ""type"": ""messaging_extension_reply"",
        ""package_name"": ""com.pushbullet.android"",
        ""source_user_iden"": """ + UserIdentity + @""",
        ""target_device_iden"": """ + DeviceIdentity + @""", 
        ""conversation_iden"": """ + ((Nr_Numero.Value.Length <= 11) ? "+55" + Nr_Numero.Value : Nr_Numero.Value) + @""",
        ""message"": """ + Ds_Mensagem.Value.Replace('\\', '/') + @"""
    },""type"": ""push""
}";

            var request = (HttpWebRequest) WebRequest.Create("https://api.pushbullet.com/v2/ephemerals");
            
            request.Method = "POST";
            request.Headers.Add("Access-Token", AccessToken);
            request.UserAgent = "curl/7.37.0";
            request.ContentType = "application/json";

            var buffer = Encoding.GetEncoding("UTF-8").GetBytes(dsScript);
            using (var reqstr = request.GetRequestStream())
            {
                reqstr.Write(buffer, 0, buffer.Length);

                using (var response = request.GetResponse())
                {
                    var dataStream = response.GetResponseStream();

                    var reader = new StreamReader(dataStream);
                    var responseFromServer = reader.ReadToEnd();

                    if (responseFromServer == "{}")
                        Retorno.Mensagem(responseFromServer);
                    else
                        Retorno.Erro(responseFromServer);
                }

            }
            
        }
        catch (Exception e)
        {
            Retorno.Erro("Erro : " + e.Message);
        }
        
    }

}

using System;

using System.Data.SqlTypes;

using System.IO;

using System.Net;

using System.Text;

using Bibliotecas.Model;

public partial class StoredProcedures

{

[Microsoft.SqlServer.Server.SqlProcedure]

public static void stpEnvia_Torpedo(SqlString Nr_Numero, SqlString Ds_Mensagem)

{

if (Nr_Numero.IsNull)

Retorno.Erro("Favor informar o número de telefone que irá receber a mensagem");

if (Nr_Numero.Value.Length <= 9)

Retorno.Erro("Favor informar o número de telefone com DDD");

if (Ds_Mensagem.IsNull)

Retorno.Erro("Favor informar a mensagem que será enviada");

if (Ds_Mensagem.Value.Length > 160)

Retorno.Erro("O tamanho máximo da mensagem a ser enviada por SMS é de 160 caracteres");

try

{

const string AccessToken = "seu_access_token"; //https://www.pushbullet.com/#settings

const string UserIdentity = "token_usuario"; //curl --header "Access-Token: access_token" https://api.pushbullet.com/v2/users/me

const string DeviceIdentity = "token_do_dispositivo"; //curl--header "Access-Token: access_token" https://api.pushbullet.com/v2/devices

var dsScript = @"{

""push"": {

""type"": ""messaging_extension_reply"",

""package_name"": ""com.pushbullet.android"",

""source_user_iden"": """ + UserIdentity + @""",

""target_device_iden"": """ + DeviceIdentity + @""",

""conversation_iden"": """ + ((Nr_Numero.Value.Length <= 11) ? "+55" + Nr_Numero.Value : Nr_Numero.Value) + @""",

""message"": """ + Ds_Mensagem.Value.Replace('\\', '/') + @"""

},""type"": ""push""

}";

var request = (HttpWebRequest) WebRequest.Create("https://api.pushbullet.com/v2/ephemerals");

request.Method = "POST";

request.Headers.Add("Access-Token", AccessToken);

request.UserAgent = "curl/7.37.0";

request.ContentType = "application/json";

var buffer = Encoding.GetEncoding("UTF-8").GetBytes(dsScript);

using (var reqstr = request.GetRequestStream())

{

reqstr.Write(buffer, 0, buffer.Length);

using (var response = request.GetResponse())

{

var dataStream = response.GetResponseStream();

var reader = new StreamReader(dataStream);

var responseFromServer = reader.ReadToEnd();

if (responseFromServer == "{}")

Retorno.Mensagem(responseFromServer);

else

Retorno.Erro(responseFromServer);

}

catch (Exception e)

{

Retorno.Erro("Erro : " + e.Message);

}

In this script, I used the class ROI, which aims to send information messages and error messages to the database through the CLR. Your source code is available in the post. SQL Server - How to send warnings and error messages to the bank through CLR (C #).

Solution written in PHP Web programming language

Example:

Source code:

<?php

// Variáveis
$Nr_Numero = "+5527912345678";
$Ds_Mensagem = "Teste da API com o PHP";

$Nr_Numero = (strlen( $Nr_Numero ) <= 11) ? "+55" . $Nr_Numero : $Nr_Numero;
$Ds_Mensagem = str_replace( "\\", "/", $Ds_Mensagem );


// Parâmetros
$strUrl = "https://api.pushbullet.com/v2/ephemerals";
$AccessToken = "seu_access_token";
$UserIdentity = "seu_token_usuario";
$DeviceIdentity = "seu_token_dispositivo";


$requisicao = [
    'type' => 'push',
    'push' => [
        'type' => 'messaging_extension_reply',
        'package_name' => 'com.pushbullet.android',
        'source_user_iden' => $UserIdentity,
        'target_device_iden' => $DeviceIdentity,
        'conversation_iden' => $Nr_Numero,
        'message' => $Ds_Mensagem
    ]
];


$headers = array(
    "Content-type: application/json",
    "Access-Token: " . $AccessToken,
);


$ch = curl_init();


curl_setopt( $ch, CURLOPT_URL, $strUrl );

// Cabeçalhos e configurações
curl_setopt( $ch, CURLOPT_HEADER, 1 );
curl_setopt( $ch, CURLOPT_HTTPHEADER, $headers );
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1 );
curl_setopt( $ch, CURLOPT_USERAGENT, "curl/7.37.0" );
curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, TRUE );
curl_setopt( $ch, CURLOPT_MAXREDIRS, 2 );

// Desativa a verificaçõo de certificado SSL
curl_setopt( $ch, CURLOPT_SSL_VERIFYHOST, 0 );
curl_setopt( $ch, CURLOPT_SSL_VERIFYPEER, 0 );

// Envia os dados
curl_setopt( $ch, CURLOPT_POST, 1 );
curl_setopt( $ch, CURLOPT_POSTFIELDS, json_encode( $requisicao ) );


$retorno = curl_exec( $ch );
curl_close( $ch );

if ( substr( $retorno, -2 ) == "{}" )
{
    echo "Torpedo enviado com sucesso para o número " . $Nr_Numero;
}
else
{
    echo "Erro: " . $retorno;
}
?>

<?php

// Variáveis

$Nr_Numero = "+5527912345678";

$Ds_Mensagem = "Teste da API com o PHP";

$Nr_Numero = (strlen( $Nr_Numero ) <= 11) ? "+55" . $Nr_Numero : $Nr_Numero;

$Ds_Mensagem = str_replace( "\\", "/", $Ds_Mensagem );

// Parâmetros

$strUrl = "https://api.pushbullet.com/v2/ephemerals";

$AccessToken = "seu_access_token";

$UserIdentity = "seu_token_usuario";

$DeviceIdentity = "seu_token_dispositivo";

$requisicao = [

'type' => 'push',

'push' => [

'type' => 'messaging_extension_reply',

'package_name' => 'com.pushbullet.android',

'source_user_iden' => $UserIdentity,

'target_device_iden' => $DeviceIdentity,

'conversation_iden' => $Nr_Numero,

'message' => $Ds_Mensagem

]

];

$headers = array(

"Content-type: application/json",

"Access-Token: " . $AccessToken,

);

$ch = curl_init();

curl_setopt( $ch, CURLOPT_URL, $strUrl );

// Cabeçalhos e configurações

curl_setopt( $ch, CURLOPT_HEADER, 1 );

curl_setopt( $ch, CURLOPT_HTTPHEADER, $headers );

curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1 );

curl_setopt( $ch, CURLOPT_USERAGENT, "curl/7.37.0" );

curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, TRUE );

curl_setopt( $ch, CURLOPT_MAXREDIRS, 2 );

// Desativa a verificaçõo de certificado SSL

curl_setopt( $ch, CURLOPT_SSL_VERIFYHOST, 0 );

curl_setopt( $ch, CURLOPT_SSL_VERIFYPEER, 0 );

// Envia os dados

curl_setopt( $ch, CURLOPT_POST, 1 );

curl_setopt( $ch, CURLOPT_POSTFIELDS, json_encode( $requisicao ) );

$retorno = curl_exec( $ch );

curl_close( $ch );

if ( substr( $retorno, -2 ) == "{}" )

{

echo "Torpedo enviado com sucesso para o número " . $Nr_Numero;

}

else

{

echo "Erro: " . $retorno;

}

Generic solution using cURL.exe binary

After demonstrating examples using two different programming languages, I will demonstrate how to use cURL.exe itself, installed on your PC, to send SMS. You can choose your favorite programming language to submit your request, as I did in the examples above, or you can simply run cURL.exe binary from your programming language:

The default command to send SMS through cURL is this:

curl --header "Access-Token: seu_access_token" --header "Content-Type: application/json" --request POST -k --data-binary @"C:\Users\dirceu\Desktop\push_message.json" https://api.pushbullet.com/v2/ephemerals

1	curl --header "Access-Token: seu_access_token" --header "Content-Type: application/json" --request POST -k --data-binary @"C:\Users\dirceu\Desktop\push_message.json" https://api.pushbullet.com/v2/ephemerals

push_message.json

{
  "push": {
    "conversation_iden": "+5527912345678",
    "message": "Teste de Mensagem com cURL",
    "package_name": "com.pushbullet.android",
    "source_user_iden": "seu_token_usuario",
    "target_device_iden": "seu_token_dispositivo",
    "type": "messaging_extension_reply"
  },
  "type": "push"
}

{

"push": {

"conversation_iden": "+5527912345678",

"message": "Teste de Mensagem com cURL",

"package_name": "com.pushbullet.android",

"source_user_iden": "seu_token_usuario",

"target_device_iden": "seu_token_dispositivo",

"type": "messaging_extension_reply"

"type": "push"

}

In the cURL command I used an external file (push_message.json) to store the information for the request I am going to send. You can have your programming language create this file at run time, use the path of the newly created file in the –data-binary parameter and delete it after execution.

I believe this solution through cURL is very generic and can be used by any programming language that allows you to execute binary files on the server, be it C #, PHP, Java, Ruby, etc.

That's it folks!
I hope you enjoyed this post.

Any questions, leave here in the comments!

sql sql server send torpedo send sms php java c # clr .net csharp ruby curl command line code script snipplet script

Daniel Cunha Correa said:

1 February 2020 to 09: 52

Good morning Dirceu,

I have multiple databases linked to an application with multiple accesses, with the API all banks would be able to send sms. the question is whether I need to have multiple accounts to serve everyone?

DJALMA RORATO ANSELONI said:

24 October 2017 to 22: 29

Dirceu Boa Noite, I did everything according to your post, I am receiving the return “{}” from HttpWebRequest but the SMS is not triggered. I'm shooting directly from my C # application. Does this solution work only on the CLR?

Laércio Coelho said:

3 October 2016 to 18: 16

Good afternoon, Dirceu!

I was in similar need and your article was really a find!
I don't know if you had a problem, but I have a strange situation: in my machine, in a local bank, everything went well; However, when publishing the same CLR solution on other 2 different servers, when I execute the procedure it runs without stopping and only sends the message when I cancel its execution; and if I run it from a C # application in Visual Studio it gives a timeout error and doesn't send anything.
Do you know what could be causing this? Without wanting to abuse ...

albertochong said:

14 from 2016 from September to 14: 12

Good afternoon Dirceu,
I tried to test the example above and got the answer {} but the sms was not sent, I have to put the country code?

- Dirceu Resende said:
  
  14 from 2016 from September to 14: 18
  
  Alberto, good afternoon. The number must be in the format + 55DDDNumero.
  
Gustavo said:

12 from 2016 from September to 09: 07

Good morning, I'm trying to create the Return class as saying ”SQL Server - How to send warnings and error messages to the bank via the CLR (C #). ”But is giving an error in

using (var Connection = new SqlConnection (Server.Localhost))

could you help me

- Dirceu Resende said:
  
  12 from 2016 from September to 10: 20
  
  Gustavo, good morning.
  
  I edited the post and added the source code from the Server.cs file, which is used by the Return class.
  
  Thank you!

Other Languages

Subscribe to a blog by email

Blog Views

Power Alerts

Azure Banking Admin Course

SQL Server Security Course

My Certifications

Posts Archive

Categories

Recent Posts

Using the Pushbullet API to send SMS messages in C #, PHP, Java, or SQL Server (with CLR)

What is Pushbullet?

How does this solution work? How is the torpedo shipped?

What are the requirements for this API to work?

What is the cost of this solution? Is there any shipping limit?

Creating your account and adding devices

Retrieving Access Token, User ID, and Device ID

Developing SMS push solution with Pushbullet API

sql sql server send torpedo send sms php java c # clr .net csharp ruby curl command line code script snipplet script

You may also like ...

Comments

Leave a Comment Cancel reply

What is Pushbullet?

How does this solution work? How is the torpedo shipped?

What are the requirements for this API to work?

What is the cost of this solution? Is there any shipping limit?

Creating your account and adding devices

Retrieving Access Token, User ID, and Device ID

Developing SMS push solution with Pushbullet API

sql sql server send torpedo send sms php java c # clr .net csharp ruby ​​curl command line code script snipplet script

You may also like ...

How to query SQL Agent startup history in SQL Server

Protheus - Names and Descriptions of TOTVS ERP tables

SQL Server - When you should use ORDER BY in the query and when you should not use it at all!

Comments

Leave a Comment Cancel reply

sql sql server send torpedo send sms php java c # clr .net csharp ruby curl command line code script snipplet script