The REST Source in Task Factory allows you to connect to almost any web service/cloud application that utilizes a REST API and to 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 its support for Basic REST, OAuth1 and OAuth2 authentication, with 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!
The REST Destination in SSIS makes it easy to create records quickly in a RESTful source. It's simple to configure in seconds with many pre-built configuration files.
Some common use cases might be to create webinars in GoToWebinar, bulk create tickets in ZenDesk or create leads in HubSpot.