![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-logo.png\"){kind=logo}
<\/a>Pipedrive is a popular CRM platform used by sales teams to manage deals, leads, contacts, activities, and pipelines. It offers REST APIs that let you access CRM data programmatically. Many organisations extract Pipedrive data into SQL Server for operational reporting, sales dashboards, and analytics.<\/p>\nIn this tutorial, you will learn how to connect Pipedrive APIs to SQL Server Integration Services (SSIS) using ZappySys SSIS PowerPack. This approach helps you build repeatable ETL pipelines without writing custom API integration code.<\/p>\n
<\/p>\n
Prerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is available.<\/li>\n
- A Pipedrive account with API access.<\/li>\n
- A valid Pipedrive API token.<\/li>\n
- ZappySys SSIS PowerPack<\/a> is installed on your machine.<\/li>\n<\/ol>\n
<\/p>\n
Steps<\/h2>\nGenerate Pipedrive API Token<\/h3>\n\n- Sign in to your Pipedrive account.<\/li>\n
- Go to Personal Preferences<\/strong> > API<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-Personal-token.png\")
<\/a>Pipedrive – Personal token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n\n- In your SSIS package, navigate to the Variables section and create the following variables: PersonalToken<\/strong> (String) \u2014 Enter the Personal Token from the previous step.<\/li>\n
- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source<\/li>\n
- Set the API URL with the variable. Example to extract deals:\n
https:\/\/api.pipedrive.com\/v1\/deals?api_token={{User::PersonalToken}}<\/pre>\n<\/li>\n - Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-JSON-source-configuration.png\")
<\/a>Pipedrive – JSON source configuration<\/p><\/div><\/li>\n<\/ol>\n
Use Other Pipedrive Endpoints (Optional)<\/h3>\n
You can reuse the same SSIS package pattern with other Pipedrive endpoints:<\/p>\n
\n- Persons:<\/strong>
https:\/\/api.pipedrive.com\/v1\/persons?api_token={your_api_token}<\/code><\/li>\n- Organizations:<\/strong>
https:\/\/api.pipedrive.com\/v1\/organizations?api_token={your_api_token}<\/code><\/li>\n- Activities:<\/strong>
https:\/\/api.pipedrive.com\/v1\/activities?api_token={your_api_token}<\/code><\/li>\n- Leads:<\/strong>
https:\/\/api.pipedrive.com\/v1\/leads?api_token={your_api_token}<\/code><\/li>\n- Pipelines:<\/strong>
https:\/\/api.pipedrive.com\/v1\/pipelines?api_token={your_api_token}<\/code><\/li>\n<\/ul>\n<\/p>\n
Configure Destination Component<\/h3>\n\n- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\")
<\/a>Pipedrive\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that Pipedrive\u00a0 rows have been loaded into your SQL Server table.\n
<\/p>\n
Steps<\/h2>\nGenerate Pipedrive API Token<\/h3>\n\n- Sign in to your Pipedrive account.<\/li>\n
- Go to Personal Preferences<\/strong> > API<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n<\/a>
Pipedrive – Personal token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n\n- In your SSIS package, navigate to the Variables section and create the following variables: PersonalToken<\/strong> (String) \u2014 Enter the Personal Token from the previous step.<\/li>\n
- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n<\/a>
Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source<\/li>\n
- Set the API URL with the variable. Example to extract deals:\n
https:\/\/api.pipedrive.com\/v1\/deals?api_token={{User::PersonalToken}}<\/pre>\n<\/li>\n - Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n<\/a>
Pipedrive – JSON source configuration<\/p><\/div><\/li>\n<\/ol>\n
Use Other Pipedrive Endpoints (Optional)<\/h3>\n
You can reuse the same SSIS package pattern with other Pipedrive endpoints:<\/p>\n
\n- Persons:<\/strong>
https:\/\/api.pipedrive.com\/v1\/persons?api_token={your_api_token}<\/code><\/li>\n- Organizations:<\/strong>
https:\/\/api.pipedrive.com\/v1\/organizations?api_token={your_api_token}<\/code><\/li>\n- Activities:<\/strong>
https:\/\/api.pipedrive.com\/v1\/activities?api_token={your_api_token}<\/code><\/li>\n- Leads:<\/strong>
https:\/\/api.pipedrive.com\/v1\/leads?api_token={your_api_token}<\/code><\/li>\n- Pipelines:<\/strong>
https:\/\/api.pipedrive.com\/v1\/pipelines?api_token={your_api_token}<\/code><\/li>\n<\/ul>\n<\/p>\n
Configure Destination Component<\/h3>\n\n- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n<\/a>
Pipedrive\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that Pipedrive\u00a0 rows have been loaded into your SQL Server table.\n
- \n
- Sign in to your Pipedrive account.<\/li>\n
- Go to Personal Preferences<\/strong> > API<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n
<\/a>Pipedrive – Personal token<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n
- \n
- In your SSIS package, navigate to the Variables section and create the following variables: PersonalToken<\/strong> (String) \u2014 Enter the Personal Token from the previous step.<\/li>\n
- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
<\/a>Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source<\/li>\n
- Set the API URL with the variable. Example to extract deals:\n
https:\/\/api.pipedrive.com\/v1\/deals?api_token={{User::PersonalToken}}<\/pre>\n<\/li>\n- Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
<\/a>Pipedrive – JSON source configuration<\/p><\/div><\/li>\n<\/ol>\n
Use Other Pipedrive Endpoints (Optional)<\/h3>\n
You can reuse the same SSIS package pattern with other Pipedrive endpoints:<\/p>\n
- \n
- Persons:<\/strong>
https:\/\/api.pipedrive.com\/v1\/persons?api_token={your_api_token}<\/code><\/li>\n- Organizations:<\/strong>
https:\/\/api.pipedrive.com\/v1\/organizations?api_token={your_api_token}<\/code><\/li>\n- Activities:<\/strong>
https:\/\/api.pipedrive.com\/v1\/activities?api_token={your_api_token}<\/code><\/li>\n- Leads:<\/strong>
https:\/\/api.pipedrive.com\/v1\/leads?api_token={your_api_token}<\/code><\/li>\n- Pipelines:<\/strong>
https:\/\/api.pipedrive.com\/v1\/pipelines?api_token={your_api_token}<\/code><\/li>\n<\/ul>\n<\/p>\n
Configure Destination Component<\/h3>\n
- \n
- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n
<\/a>Pipedrive\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that Pipedrive\u00a0 rows have been loaded into your SQL Server table.\n
- Organizations:<\/strong>
- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
- Copy your API token and store it securely.\n