Task Factory

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.



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

“We got Task Factory mostly because of Pragmatic Works reputation for the service they provide and the specific need of a secure SFTP task.”

Matt Cushing
Matt Cushing
Loews 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

Our Clients 96% of fortune 100 companies trust pragmatic works:

Our StatsSome of our cool facts

  • 200x
    More frequent deployments
  • 24x
    Faster recovery from failures
  • 3x
    Lower change failure rate
  • 2555x
    Shorter lead times

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

Using SSIS REST Source to Get the Reports You Need from Litmos

Pragmatic Works has done a series of blogs and videos discussing how our Task Factory REST Source can help you easily get the data you need from web services, such as Salesforce, GoToWebinar and Google Analytics. Here, we want to show how REST Source help our Training Director, Devin Knight, with Litmos. Read More

Get Your Data to and from Salesforce with our REST Components

Everyone in business is looking to save time in their day and make it easier to work with the data they need to make decisions. REST Source is a component inside our Pragmatic Works’ Task Factory Suite which will automate the process of connecting to Web Services to pull information down into your SQL platform. Read More

Export Data from SurveyMonkey Using REST Source

If you use Survey Monkey, are you looking for an easier way to get and utilize that information for your business? Survey Monkey is a great tool for getting useful information and keeping in touch with clients. The problem is, getting the data out of SurveyMonkey can be a tedious, manual process. With REST Source, you can easily pull down the information you need from Survey Monkey, and incorporate it with the other platforms you use.Read More

Webinars & Videos

Introduction to the Rest Destination
REST Source with GoToWebinar
Configure Rest Destination Error Output
REST Source with Salesforce demo
Accelerate SSIS today
Task Factory Pro Edition
Help Documentation
Download Data Sheet

Please reach out to us to schedule a free demo or for additional information.

Task Factory
Call Us At: (904) 413-1911

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