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

ADO.NET Provider

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

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

Using API Key Authentication

Landbot uses token-based authentication. Obtain your agent token from Settings > Account in your Landbot account.

Set the following connection properties:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your Landbot agent token.

Sample Connection String

Profile=C:\profiles\Landbot.apip;AuthScheme=APIKey;APIKey=your_agent_token_here;

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

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

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

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