Automate ZeroBounce 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 ZeroBounce.

ADO.NET Provider

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

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

Using API Key Authentication

ZeroBounce uses API key authentication. To obtain an API key:

1. Log in to your ZeroBounce account at https://app.zerobounce.net
2. Navigate to the API tab in your account dashboard
3. Copy the API key displayed on the page

After obtaining your API key, set the following connection properties:

• AuthScheme: Set this to APIKey.

• APIKey: Set this to your ZeroBounce API key.

Example Connection String

Profile=C:\profiles\ZeroBounce.apip;AuthScheme=APIKey;ProfileSettings="APIKey=your_api_key";

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 ZeroBounce:

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

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

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