Retrieve data from a REST endpoint using the 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 then can be consumed by the downstream SSIS pipeline.
Supported services are listed below, click to view the configuration in detail:
- Act-On
- Active Campaign
- Acumatica
- ADP
- Asana
- Auth0
- Azure Application Insights
- Azure Table
- Basecamp
- BigCommerce
- Bill.com
- Calendly
- Ceridian Dayforce
- Chargify
- Chargebee
- Clickup
- Contact Contact
- Copper
- Discord
- DocuSign
- Drift
- Dynamics 365 Customer Insights
- eBay
- Elasticsearch
- Eventbrite
- Expensify
- Facebook Business
- Facebook Messenger
- FreshBooks
- Freshdesk
- Freshsales
- GitHub
- Google Forms
- GoToWebinar
- Infusionsoft
- Insightly
- Jira
- Jotform
- LinkedIn Business
- Magento
- MailChimp
- Mailgun
- Mailjet
- Microsoft To Do
- Microsoft Teams
- MYOB
- Okta
- PayPal
- Pipedrive
- Power BI
- PrestaShop
- Quickbase
- Sage Business Cloud
- Salesforce Pardot
- SendGrid
- Sendinblue
- ServiceNow
- ShipStation
- Shopify
- Slack
- Smartsheet
- Snapchat Business
- Square
- Stripe
- SugarCRM
- SuiteCRM
- SurveyMonkey
- Teamwork
- TikTok Business
- Trello
- Twilio
- Twitter Business
- Typeform
- WordPress
- Wunderlist
- Xero
- Yammer
- YouTube Analytics
- Zendesk
- Zoho Books
- Zoho
- Zoho Desk
- Zoom
- Zuora
Looking for an endpoint not listed above? See How to Work with RESTful Endpoints in your SSIS ETL Process.