REST Source and Destination

The REST Source and Destination can be configured in just seconds to easily get data from, and write data to, web RESTful sources.



Feature Image

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!

Feature Highlights

  • Retrieve data from nearly any web or internal RESTful source using SSIS
  • Supports many types of private and public connections
  • Pre-configured options for common systems like ZenDesk, Google, GotoWebinar, etc.

REST SSIS Destination

Feature Image

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.

Feature Highlights

  • Write data to nearly any RESTful connections on the web or internal services
  • Supports many types of private and public connections
  • Pre-configured options for common systems like ZenDesk, Google, GotoWebinar, etc.

Testimonial What People Say About Task Factory

“Task Factory benefits our team by enabling us to work more efficiently. It has decreased our development time by bundling the complex day-to-day tasks. All we have to do is simply supply a few variables. It also allows us to connect to more Sources, including Salesforce, Facebook, Twitter and Rest Endpoints for custom API calls. And since it’s an add-in to Visual Studio, our current Code doesn’t have to be changed.”

Matt Cushing
Russell Soderling
DBA Inuvo Corporation

“At the University of Calgary, I can say with confidence that halfway into the conversion effort, using Task Factory has been one of our smartest and most cost-effective software acquisitions in recent memory.”

Gabriel Gray
Gabriel Gray
University of Calgary

Some Of Our Clients that Use Task Factory 96% of Fortune 100 Companies Trust Pragmatic Works

Articles & Tutorials

Using REST Source to Get Data from Google Analytics

We get it, you’ve got tons of data in external sources, such as Google Analytics, and it’s time consuming to dig through to get the data you need to make decisions for your business. Wouldn’t it be great to have the information you need gathered for you in one place?

Read More

Using Task Factory’s REST API Source to Connect to Zendesk

Learn how to connect to Zendesk's API web esrvice to pull data using the Task Factory Rest Source.

Read More

Using the Task Factory REST Source with GoToWebinar

See how to configure SSIS to load registration data from GoToWebinar.

Read More

Webinars & Videos


Introduction to the Rest Destination


REST Source with GoToWebinar


Configure Rest Destination Error Output


REST Source with Salesforce demo

Contains 65+ tasks, connection managers, sources and destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.

Per server
Per server
Accelerate SSIS today
Task Factory Pro Edition
Help Documentation
Download Data Sheet

Please reach out to us for a personal demo or if you have questions.

(904) 413-1911