Perform HTTP POST operation using SSIS REST API Task - Send data in JSON content type

HTTP POST in SSIS – Send data to Web API url

Introduction In our previous article we saw how to call REST API or SOAP Web Service in SSIS. In this article we will only focus how to perform HTTP POST in SSIS using RESTful approach. HTTP Protocol supports many methods also referred as verb (e.g. GET, PUT, POST, HEAD, DELETE). Based on this verb, target […]

How to read Twitter data in SSIS using REST API Call

Introduction In this article you will how to Read Twitter data in SSIS using SSIS JSON Source and SSIS REST API Web Service Task. You will also learn about latest OAuth 2.0 Protocol to simplify REST API access. Twitter REST API Authentication In order to fetch any data from twitter using OAuth REST API calls […]

Working with HTTP Cookies in SSIS

Introduction In this post you will learn how to Parse Cookies from Response and Pass Cookies to any Web Requests. SSIS PowerPack v1.8.2 Introduced new feature to send and receive cookies from HTTP Web Request/Response. We will use SSIS REST API Task to parse cookie values and then send cookies along with HTTP Web Request. Cookies […]

SSIS REST API Task - Response Header Mapping Grid

SSIS REST API Task – Mapping Response Header to Variable

In this post you will learn how to save Response header value to SSIS variable using SSIS REST API Task SSIS PowerPack v1.8.2 Introduced new feature for mapping Response Header to variable. When you click Test Request/Response button all response headers will be parsed into Response Header Grid with default [NOT-MAPPED] status. If you wish […]

Logo REST API

How to Call REST API in SSIS – Read JSON / XML / CSV

Introduction REST API is becoming more and more popular in Data Integration landscape. If you are SSIS Developer (not a coder) and stumbled upon a question what is REST API and “how to consume API inside SSIS package?” then you are at the right place :). We encourage you to read this article carefully and follow […]