The REST Source in Task Factory allows you to connect to almost any web service/cloud application that uses a REST API and bring 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 its support for Basic REST, OAuth1, and OAuth2 authentication, you can use REST Source to connect to and extract data from your accounts on platforms such as Zendesk, GoToWebinar, Survey Monkey, MailChimp, and more.
Feature highlights:
The REST Destination in SSIS makes it easy to create records quickly in a RESTful source. It's simple to configure, with many pre-built configuration files.
Common use cases include creating webinars in GoToWebinar, bulk creating tickets in Zendesk, or creating leads in HubSpot.
Feature highlights:
Task Factory
60+ high-performing SSIS components
Save time managing tedious data warehousing ETL tasks
Connect to dozens of data sources