SSIS REST SOURCE
The REST Source in Task Factory allows you to connect to almost any web service / cloud application that utilizes a REST API and bring that data right into your data flow.
The component can handle both XML and JSON data being returned from the Rest endpoints which means it supports both legacy (XML based) and newly created (with JSON) REST endpoints.
With it's support for Basic Rest, OAuth1 and OAuth2 authentication, the Rest Source you can connect to and extract data from your accounts on platforms such as ZenDesk, GoToWebinar, Survey Monkey, MailChimp and many more!
Want to see the rest source in action? Watch the video above!