SSIS API Source - Read data from popular API Data Sources using predefined Connector File

If your connector is not listed as API Connector in the above page then try using our universal JSON Source, XML Source or CSV Source Components below

SSIS API Source
=========================================
API Source can be used to read data from popular API Data Sources using predefined Connector File without learning the internals of API Calls. This component allows you to make API calls and read API data as a Flat Table.

Features
==========================================
* In a few clicks read data from Popular Online Services (e.g. Zendesk, OData, Zendesk, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint, and growing…)
* 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 files 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

Related Searches:
===========================================
Make API call using Predefined Connector File
Reading data from API Source and load into target
Make API call using SSIS API Source
Create API Connector
How to read data from API Service

[JohnRiches]

@zappySys How do I read "Person or Group" fields?

[mario-t]

Thanks much, looks soooo easy. Do I need to use AP Destination component to upload files from W FileShare to SharePoint folder ?