Integrate REST APIs into your SSIS Packages

Introduction

This article provides a comprehensive guide on utilizing various HTTP methods, authentication techniques, and downloading files like images, music, or zip files using SSIS.

Prerequisites

Video tutorial

Steps

HTTP Methods

GET Method

POST Method

  • Sends data to the server to create a new resource.
  • Example:

DELETE Method

PUT Method

  • Updates or replaces an existing resource on the server.
  • Example:
    • URL: https://httpbin.org/put
    • Method: PUT
    • Body: {"name": "new name," "lastname": "new last name", "age":35}

PATCH Method

  • Updates an existing resource on the server partially.
  • Example:

Auth Methods

Basic Authentication

Digest Authentication

Bearer Authentication

OAuth Methods

  • Detailed information is available in our article here.

Download Files

To download an image:

Conclusion

This article covers various HTTP methods, authentication mechanisms, and file downloads using SSIS. For further assistance or inquiries, contact our support team via chat on our website or through email at support@zappysys.com.

References

  • Examples from this page
  • OAuth examples here