I am using Pipedrive as my CRM System, and I use a lot of PowerShell Scripts to automate all things related to my Customers.
In this Blog Post, I want to show you how to connect your PowerShell to Pipedrive API and invoke the first Web Request.
API Details
To connect our PowerShell Script to the Pipedrive API, we need the following Information. Please follow the Pipedrive Doc for more Details
- API Key: How to find the API token (readme.io)
- Domain Name: How to get the company domain (readme.io)
First PowerShell Script
With this Information we can start with our first PowerShell Script to get a list of our Contacts from Pipedrive.
$PipeDrive_APIKey="3e3c33c3a3d3333dcd333ab3c333333c33b33fc"
$Pipedrive_domain="company"
$Pipedrive_BaseURL="https://$Pipedrive_domain.pipedrive.com/v1/"With this Information above, we are ready to start to make a Rest call to get all our Contacts.
To get a list of all Persons, we refer to this Post: Pipedrive API v1 Reference
So we need to build our URL and trigger a GET Call
Our URL should look like the following: “https://company.pipedrive.com/v1/persons?start=0&api_token=3e3c33c3a3d3333dcd333ab3c333333c33b33fc”
$Url=$Pipedrive_BaseURL+"persons?start=0&api_token=$PipeDriveAPI"
$Result=Invoke-RestMethod -uri $URL -Method GET To see the Result, run $Result.data
To get the whole Script and a lot more in the future, see me Pipedrive-PowerShell GitHub Repository.
Seidlm/PIPEDRIVE-PowerShell: Control your Pipedrive CRM with PowerShell (github.com)
TEST Pipedrive: https://www.pipedrive.com/taf/au2mator1266620
Michael Seidl aka Techguy (au2mate everything)
