Retrieve data from a REST endpoint using the REST Source Component
The REST Source Component facilitates the reading and retrieval of data from REST services and produces column data, which can then be consumed by the downstream SSIS pipeline.
Supported services are listed below; click to view the configuration details:
- Act-On
- Active Campaign
- Acumatica
- ADP
- Airtable
- Asana
- Auth0
- Authorize.Net
- Azure Application Insights
- Azure Table
- BambooHR
- Basecamp
- BigCommerce
- Bill.com
- Blackbaud
- Brevo (Sendinblue)
- Calendly
- Ceridian Dayforce
- Chargify
- Chargebee
- Clickup
- Contact Contact
- Copper
- Crelate
- Discord
- DocuSign
- Drift
- Duo Security
- Dynamics 365 Customer Insights
- eBay
- Elasticsearch
- Emarsys
- Emfluence
- Eventbrite
- Expensify
- Extensiv (3PL Central)
- Facebook Business
- Facebook Messenger
- FreshBooks
- Freshdesk
- Freshsales
- Freshservice
- GetResponse
- GitHub
- Google Calendar
- Google Classroom
- Google Cloud Monitoring
- Google Dataplex
- Google Forms
- Google Maps
- Google People
- Google Search Console
- Google Tag Manager
- GoToWebinar
- Infusionsoft
- Insightly
- Jira
- Jotform
- LinkedIn Business
- Magento
- MailChimp
- Mailgun
- Mailjet
- Microsoft Planner
- Microsoft To Do
- Microsoft Teams
- MYOB
- Okta
- OneLogin
- Open Accounting
- OpenAI
- Paycor
- PayPal
- Ping Identity
- Pipedrive
- Power BI
- PrestaShop
- Qualtrics
- Quickbase
- RingCentral
- Replicon
- Sage Business Cloud
- Salesforce Pardot
- SendGrid
- ServiceNow
- ShipStation
- Shopify
- Slack
- Smartsheet
- Snapchat Business
- Square
- Stripe
- SugarCRM
- SuiteCRM
- SurveyMonkey
- Teamwork
- TikTok Business
- Trello
- Twilio
- Twitter Business
- Typeform
- Webex
- WordPress
- Wrike
- Xero
- Yammer
- YouTube Analytics
- Zendesk
- Zoho Books
- Zoho CRM
- Zoho Desk
- Zoho Expense
- Zoho Invoice
- Zoho Sheet
- Zoom
- Zuora
Looking for an endpoint not listed above? See How to Work with RESTful Endpoints in your SSIS ETL Process.