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

ADO.NET Provider

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

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

Browserless uses HTTP API token authentication. Your Browserless API token is sent as the token query parameter on every request. You can generate or view your token in the Browserless dashboard at https://account.browserless.io/.

Using ApiKey Authentication

After setting the following connection properties, you are ready to connect:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your Browserless API token.

Example connection string:

Profile=C:\profiles\Browserless.apip;AuthScheme=APIKey;ProfileSettings="ApiKey=your_api_token";

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

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

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

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