SSIS API Source

SSIS API Source

SSIS API Source

API Source can be used to write data to popular API Data Services using predefined Connector File without learning internals of API Calls. This component also allows you to return API call response as Flat Table after you submit data.

Features

    • It is possible to create your own connector
    • Easy to use. You can use our configuration without having API knowledge
    • You can create a connector based on existing connections.
    • Support for Zendesk, OData, Zoho CRM, Google Sheets, Google Bigquery, Nativo, MVS and growing
SSIS Amazon SQS Source Connector - Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Create new API connection

Configure PostgreSQL destination Mapping settings

Supports the new ZS-API Connection

Choose [OData] from Popular Connectors dropdown and Click Continue

Configure PostgreSQL destination Mapping settings

Configure OData connection

Or select another connection on search online

Configure PostgreSQL destination Mapping settings

There will be more options to connect

How to read data from API Service

Configure PostgreSQL destination Mapping settings

Select the Connection, the Endpoint, and fill in the inputs it needs. Preview the data

Configure Columns Tab to review output columns

Configure PostgreSQL destination Mapping settings

Here you can uncheck unwanted columns from the output so they don’t appear downstream

Execute the package and verify data in the file (used in Trash Destination)

Configure PostgreSQL destination Mapping settings

Check the result on the new file

Download View All Tasks Like This