Automate Pushbullet Integration Tasks from PowerShell

The CData API Driver for ADO.NET is a standard ADO.NET Provider that make it easy to accomplish data cleansing, normalization, backup, and other integration tasks by enabling real-time access to Pushbullet.

ADO.NET Provider

The ADO.NET Provider provides a SQL interface for Pushbullet; this tutorial shows how to use the Provider to retrieve Pushbullet data.

Once you have acquired the necessary connection properties, accessing Pushbullet data in PowerShell can be enabled in three steps.

Using API Key Authentication

Pushbullet uses token-based authentication (Access Token). To obtain an Access Token:

1. Log in to your Pushbullet account at https://www.pushbullet.com
2. Navigate to Settings > Account
3. Click "Create Access Token"
4. Copy the generated token

After obtaining your Access Token, set the following connection properties:

• AuthScheme: Set this to APIKey.

Set the following in the ProfileSettings connection property:

• APIKey: Set this to your Pushbullet Access Token.

Example Connection String

Profile=C:\profiles\Pushbullet.apip;ProfileSettings='APIKey=your_access_token;';AuthScheme=APIKey;

Connecting to Pushbullet

Once the authentication is configured, you can connect to Pushbullet and query data from any of the available tables such as Users, Pushes, Devices, Chats, Subscriptions, and Channels.

1. Load the provider's assembly:

   [Reflection.Assembly]::LoadFile("C:\Program Files\CData\CData API Driver for ADO.NET\lib\System.Data.CData.API.dll")
    

2. Connect to Pushbullet:

    
   $conn= New-Object System.Data.CData.API.APIConnection("Profile=C:\profiles\Pushbullet.apip;ProfileSettings='APIKey=your_access_token;';AuthScheme=APIKey;")
   $conn.Open()
   

3. Instantiate the APIDataAdapter, execute an SQL query, and output the results:

   $sql="SELECT , from Users"
   
   $da= New-Object System.Data.CData.API.APIDataAdapter($sql, $conn)
   $dt= New-Object System.Data.DataTable
   $da.Fill($dt)
   
   $dt.Rows | foreach {
   	Write-Host $_. $_.
   }
    

CodeProject