Retrieve data from a REST endpoint using REST Source Component
The REST Source component is an SSIS source component that can be used to read/retrieve data from REST services and produce column data which can then be consumed by the downstream SSIS pipeline.
Supported services are listed below, click to view the configuration in detail:
- Act-On
- Acumatica
- ADP
- Asana
- Azure Application Insights
- Azure Tables
- Basecamp
- BigCommerce
- Contact Contact
- Copper
- eBay
- Elasticsearch
- Eventbrite
- Facebook Business
- Facebook Messenger
- FreshBooks
- Freshdesk
- GoToWebinar
- Infusionsoft
- Insightly
- Jira
- LinkedIn Business
- Magento
- MailChimp
- Mailgun
- Microsoft Teams
- MYOB
- PayPal
- Sage Business Cloud
- Salesforce Pardot
- ServiceNow
- Shopify
- Slack
- Smartsheet
- Square
- Stripe
- SugarCRM
- SurveyMonkey
- Teamwork
- Trello
- Twilio
- Twitter Business
- WordPress
- Wunderlist
- Xero
- Yammer
- Zendesk
- Zoho
- Zoom
- Zuora
Looking for an endpoint not listed above? See How to Work with RESTful Endpoints in your SSIS ETL Process.