|
||||
|
View All Tasks Like This | |||
Featured Articles
|
Sending data to your Web API using POST Method

SSIS REST API Task – Calling Web Service using POST Method, Pass Request Data, Custom Headers
Testing HTTP Request / Response

SSIS REST API Task – Testing HTTP Web Service using GET Method, Pass Custom Headers
Specify HTTP Response Settings (Save to File or Variable)

SSIS REST API Task – HTTP Response Save to File or Variable, Filter using XPATH or JSON PATH
API response validation

SSIS REST API Task – Testing HTTP Web Service using GET Method, Pass Custom Headers
Advanced options (support for TLS1.2)

SSIS REST API Task – Advanced settings (SSL/TLS version, Compression, Timeout)
SSIS Execution Log for REST API Task

SSIS REST API Task – Call Web Service Execution Log
Articles
Click here to see all articles for [SSIS REST API Task] category
How to read YouTube API data in SSIS (Videos, Channels, Playlists)Introduction In last few articles we saw how to read data from various Google Services. In this article we will see how to read YouTube API data in SSIS. This blog mainly focus on SSIS approach but steps mentioned to call Google APIs can be useful for any developer regardless which programming language or toolset […] |
Read Freshdesk data in SSIS – REST API CallIntroduction In this post we will learn how to read Freshdesk data in SSIS using ZappySys JSON / REST API Source. We will see how to authenticate, paginate / parse and load Freshdesk data into SQL Server Table in just few clicks. If you don’t use Freshdesk and considering using Zendesk instead then check our previous […] |
Understand HTTP Status Code and Fix Common Errors in REST APIIntroduction Any time you send HTTP Request according to HTTP Standard using tools like ZappySys REST API Drivers or SSIS Connectors you may receive web response along with HTTP Status Codes. Dealing with REST / SOAP API calls you may face errors and you may find it challenging to understand generic error message from server along with […] |
Read / Write Shopify data in SSIS (REST API)Introduction In our previous article, we saw how to call REST API in SSIS. Now in let’s use that knowledge and learn how to read/write Shopify data in SSIS. If you are not aware of Shopify then its one of the most popular eCommerce platforms out there for small shops who sell online. Shopify provides […] |
Read HTML Table in SSIS – Extract / Download Links / ImagesIntroduction In this post you will learn how to extract data from web pages using SSIS. In other words, read HTML Table in SSIS, then Loop through extracted links and finally download files. To achieve this scenario we will use SSIS HTML Source and REST API Task. Step-By-Step To achieve desired extraction from web pages […] |
SSIS Magento data Read / Write using REST API CallIntroduction In this post we will lean SSIS Magento data read / write operations. Magento is a very popular eCommerce platform and they offer JSON based REST APIÂ and XML based SOAP API. You can use either API based on your need to automate common integration needs. We recommend using REST API (JSON API) if possible […] |
How to read data from QuickBooks Online in SSISIntroduction QuickBooks Online is a well-known Cloud-based Accounting Software. In this post, you will learn how to implement QuickBooks Online API Integration with SQL Server or any other RDBMS (e.g. Oracle, MySQL, Postgresql) using SSIS in few clicks. We will use SSIS XML Source Connector to Read data from QuickBooks Online and Load into SQL Server / other targets (Using OAuth Connection). We […] |
Read Salesforce Marketing Cloud data in SSIS (ExactTarget API)Introduction In this post we will learn how to call Salesforce Marketing Cloud API using SSIS and load into SQL Server. We will show you use case of SSIS REST API Task and SSIS JSON Source Basically there are two steps to call Salesforce Marketing Cloud API Obtain ClientID and ClientSecret ( Check these steps ) Get Access Token by […] |
Read Visual Studio Team Services data in SSIS (TFS Online) â Call REST API / Load to SQL ServerIntroduction In this blog, we will learn How to read Visual Studio Team Services data in SSIS and load into SQL Server Table, along with few other topics such as. How to register an OAuth App for Visual studio Team Service – TFS Online (Team Foundation Server) REST API Call How to read all Issues data […] |
How to read Constant Contact data in SSIS â Call REST API / Load to SQL ServerIntroduction In this blog, we will learn How to read Constant Contact data in SSIS and load into SQL Server Table, along with few other topics such as how to generate an API Token using Mashery Developer Account for Constant Contact REST API Call, how to read all Contacts from Constant Contact with SSIS and […] |
See Also
- Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol
- SSIS JSON Source Connector
- SSIS Export JSON File Task
Articles/Posts

Oracle CSV Export from Table or Query Data
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
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
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
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
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
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
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 […]