Calling REST API in SSIS with Basic Authentication / Userid-Password (BASE64 Authorization header)

Updated on March 19, 2025 by ZappySys

Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume / call REST API in SSIS check this article. HTTP Authorization Header […]

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

Updated on October 1, 2025 by ZappySys

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