SSIS Salesforce API Task (Call REST/SOAP API)

SSIS Salesforce API Task can be used to call any Salesforce.com API (e.g. REST/SOAP) which can be in XML or JSON format. This task provides easy way to save response into file or variable.

Features

Support for calling any Salesforce REST API (RESTful API)
Support for calling any Salesforce SOAP API (XML API)
Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
Save response to variable or file
Filter JSON response using JSONPath to extract specific value inside response text
Filter XML response using XPath to extract specific value inside response text
Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc
Support for Testing UI
Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} )
Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Click here to see Salesforce related articles

In Visual Studio, drag and drop the ZS Salesforce API Task in the design surface

Drag and drop the ZS Salesforce API Task in the design surface

How to create Salesforce Storage Connection

SSIS Salesforce Connection Manager UI (Used with Salesforce Destination, Salesforce Destination, Salesforce API Task, JSON Source and XML Source)

SSIS Salesforce API Task – Call REST API Example (i.e JSON API)

SSIS Salesforce API Task – Call SOAP/XML API Example

SSIS Salesforce API Task – Response Settings (Save response content options)

Articles / Tutorials

Click here to see all articles for [SSIS Salesforce Source] category

SSIS PowerPack v2.9.5 released (Maintenance Release)

What’s New In this release we focused on fixing some bugs with Dynamics CRM SourceÂ , Dynamics CRM Destination and Reporting Services Task. Version 2.9.6.10621 [Jun 24, 2019] New Features/Improvements NEW:Â Excel Source – Add option to read from any sheet by number rather than hard coded table name (e.g. $4$ , $5$ … ) Bug fixes […]

How to export data from Salesforce to SQL Server using SSIS

Introduction Salesforce is a popular CRM tool which lets you manage your sales, contacts, products and other useful things. In this tutorial, you will learn how to export data from Salesforce to SQL ServerÂ using SSIS (part of SQL Server) and ZappySys PowerPack. In this article, we will extract Salesforce contacts and import them into a […]

References

Articles/Posts

Oracle CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install Oracle Drivers3.1 Sample Oracle ODBC Connection String3.2 Sample Oracle OLEDB Connection String4 Oracle CSV Export – Single table5 Oracle CSV Export – Multiple tables6 Oracle CSV Export – Multiple tables (using pattern)7 Oracle CSV Export – SQL Query8 Oracle CSV Export – Split […]

SQL Server Excel Export from Table or Query data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution3.1 Export Tables to CSV Using – ZappyShell Command Line Tools3.2 Export Tables to CSV Using – SSIS Export CSV File Task4 Download and Install ZappyShell Command Line Tools5 SQL Server Excel Export – Single table6 SQL Server Excel Export – Multiple tables7 SQL Server Excel Export – Multiple tables (using […]

SQL Server JSON Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 The problem3 Solution4 Export SQL Server data to JSON using SSIS PowerPack5 Export SQL Server data to JSON using ZappyShell Command line6 SQL Server JSON Export – Single table7 SQL Server JSON Export – Multiple tables8 SQL Server JSON Export – Multiple tables (using pattern)9 SQL Server JSON Export – SQL Query10 Using […]

SQL Server CSV Export from Table or Query Data

Posted: June 10, 2015

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install SQL Server Drivers3.1 Sample ADO.net Connection String (No driver needed)3.2 Sample ODBC Connection String (SQL Native Client Driver)3.3 Sample OLEDB Connection String (SQL Native Client Driver)4 SQL Server CSV Export – Single table5 SQL Server CSV Export – Multiple tables6 SQL Server CSV […]

MySQL CSV Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 Download and Install MySQL ODBC Driver3 Download and Install ZappyShell Command Line Tools4 MySQL CSV Export – Single table5 MySQL CSV Export – Multiple tables6 MySQL CSV Export – Multiple tables (using pattern)7 MySQL CSV Export – SQL Query8 MySQL CSV Export – Split Files8.1 MySQL CSV Export – Split By Row Count8.2 […]

MySQL Excel Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL Excel Export – Single table7 MySQL Excel Export – Multiple tables8 MySQL Excel Export – Multiple tables (using pattern)9 MySQL Excel Export – SQL Query10 MySQL Excel Export – Split Files and Tabs10.1 MySQL Excel Export […]

MySQL JSON Export from Table or Query result

Posted: June 5, 2015

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL JSON Export – Single table7 MySQL JSON Export – Multiple tables8 MySQL JSON Export – Multiple tables (using pattern)9 MySQL JSON Export – SQL Query10 Using Map File for nested MySQL JSON Export11 MySQL JSON Export […]