Included in SSIS PowerPack

SSIS API Source

Read data from popular APIs as a flat table using a predefined connector file, without learning the internals of API calls.

API Source reads data from popular API services (Zendesk, OData, Zoho CRM, Google Sheets, BigQuery, Jira, SharePoint and more) using a predefined connector file, without learning the internals of API calls. Pick an endpoint, preview the data and load it downstream as a flat table.

Download Free Trial Buy Now

The trial includes API Source and every other PowerPack component

Watch the tutorialHelp & Docs
API Source in action
SSIS API Source - Create API Connection
Create the API connection from a predefined connector

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What API Source can do

API Source reads data from popular API services using a predefined connector file, without learning the internals of API calls, and returns it as a flat table.

Prebuilt API connectors

Read data from popular online services in a few clicks using a predefined connector file.

  • Zendesk, OData, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint and more
  • Works with 50+ Enterprise API connectors (SharePoint, Outlook Mail, Jira, HubSpot, Google Sheets and more)

Browse the connector list

No API internals to learn

Read API data as a flat table without learning complex API configuration, pagination or authentication details.

  • Intuitive UI for step-by-step configuration without API knowledge

API Source help

Endpoint picker & preview

Select the connection and the endpoint, fill in the inputs it needs, then preview the data.

  • Choose an endpoint (e.g. Read Orders) from the dropdown
  • Columns tab: uncheck columns you don’t want downstream

See the screenshots

Flexible connection setup

Create the API Connection Manager from the component UI or from the Connection Manager panel.

  • Choose from the popular connectors list
  • Search online and download a connector file, or use a local file
  • Enter Direct Config XML (embedded text)

API Connection Manager help

Custom & editable connectors

Easily modify an existing connector file, or create and use your own reusable connector file for a custom API.

API Source help

Dynamic parameters

Override the selected endpoint’s default parameter values and make them dynamic at runtime.

  • Parameters overrides values defined in the API template
  • Use the ZappySys Placeholder Engine or SSIS Expressions

Parameterization guide

Graceful error handling

Choose when the component should continue instead of failing on an HTTP error.

  • ContinueOnUrlNotFoundError for 404 (URL not found)
  • Continue on specific status codes (e.g. 404|405) or response text
  • ConsumeResponseOnError returns content even when an error occurs

Component properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

Row limit, error output & logging

Limit how many rows are fetched and capture bad rows during execution.

  • MaxRows (0 = unlimited)
  • Error output with RedirectRow on errors or truncation
  • LoggingMode (Normal to Debugging) and PrefixTimestamp

Component properties

See all features
  • Read data from popular online services (Zendesk, OData, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint and more) in a few clicks
  • Works with 50+ Enterprise API connectors using predefined connector files
  • No need to learn complex API configuration, pagination or authentication details
  • Reads API data as a flat table
  • Intuitive UI for step-by-step configuration without API knowledge
  • Pick an endpoint from a dropdown and preview the data
  • Create connections from the popular connector list, an online search, a local connector file or embedded config XML
  • Easily modify an existing connector file, or create your own reusable connector file for a custom API
  • Override endpoint parameters with the Placeholder Engine or SSIS Expressions
  • Continue on 404, specific status codes or response text, and optionally consume the response on error
  • MaxRows to limit how many rows are fetched
  • Error output to redirect bad rows on error or truncation
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix

  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the API Source page and help file, with the screens you will see in SSDT.

Create the API connection from the source UI.

Double-click API Source and click New to create the connection. You can also right-click the Connection Managers panel, choose New Connection and add the ZS-API Connection Manager. Click Test Connection, then OK.

  • One API connection works with both API Source and API Destination
  • Create it from the component UI (recommended) or the Connection Managers panel
SSIS API Source - Create API Connection

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the API Source product page. Step through them, or open any shot at full size.

API Source – Drag and Drop

API Source – Drag and Drop

Articles

Worked examples that use API Source.

GuideUpload files to Google DriveConfigure the Google Drive connector in API Source, with user or service account OAuth, to upload local files.zappysys.com blogRead articleGuideUpload files to SharePoint OnlineUse the SharePoint Online connector in API Source to upload files.zappysys.com blogRead articleGuideDownload files from OneDriveUse the OneDrive connector in API Source to download files.zappysys.com blogRead article

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop API Source on the canvas.

What is API Source?

API Source is an SSIS Data Flow source that reads data from popular API services using a predefined connector file, without learning the internals of API calls such as pagination or authentication. You pick an endpoint, preview the data, and it outputs the API data as a flat table.

Which APIs can it read from?

Any service with an API connector file: popular connectors such as Zendesk, OData, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS and SharePoint, connectors found with Search Online, a local connector file, or Direct Config XML. You can modify an existing connector file or create your own reusable one for a custom API (or use the generic JSON Source or XML Source). Browse the connector list.

Which edition includes API Source?

API Source and the ZappySys API Connector Library it uses are included in the Enterprise Edition of SSIS PowerPack. The 30-day trial includes every component. See compare editions.

How do I pass dynamic values to an endpoint?

Endpoint parameters override the defaults defined in the connector. Make them dynamic with the ZappySys Placeholder Engine (for example SSIS variables) or with SSIS Expressions; see the parameterization guide.

What happens when the API returns an error?

By default the component fails. You can continue on a 404 (URL not found), on any error, on specific status codes (for example 404|405) or when a substring is found in the response, and ConsumeResponseOnError returns the content even when an error occurs. An error output with RedirectRow captures bad rows on error or truncation.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag API Source onto the Data Flow.

Read data from popular APIs as a flat table using a predefined connector file, without learning the internals of API calls.

  • Data Flow Source in SSISAPI Source appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.
Download Free TrialView Pricing

Open Help FileBrowse all SSIS PowerPack tasks

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

+1-800-444-5602Contact supportSSIS PowerPack overview

1 / 9