API Source can be used to read data from popular API Data Sources (see list here) using predefined Connector File without learning internals of API Calls. This component allows you make API calls and read API data as Flat Table.
In few clicks read data from Popular Online Services (e.g. Zendesk, OData, Zendesk, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint and growing… (see list here))
No need to learn Complex API Configurations / Pagination / Authentication details
Intuitive UI for easy step by step configuration without having API knowledge
Easily modify existing connector file based on your need.
Allows to create and use your own reusable connector file for custom API (or you can consider using our generic JSON Source or XML Source)
Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory