Working with SharePoint Online through OData v4 Endpoint

29 June 2021
KingswaySoft Team

This post will give examples of how to query the SharePoint REST API data with filters and expanded properties, invoke functions using Premium OData Source component.


Proper Output Handling with KingswaySoft JSON Destination Component

28 April 2021
KingswaySoft Team

When working with REST API, a common scenario may arise where there could be additional information returned from the API response and user needs to process and handle, in some cases it is extremely value to save such results. The challenge is the response returned by the service call is different from service to service. This blog post will demonstrate how to configure KingswaySoft JSON Destination component to send out JSON formatted request and extract API response and associate the response back to the original input rows to provide the most accurate reporting and troubleshooting.


Performing File Upload Using HTTP Multipart Requests in SSIS

19 February 2021
KingswaySoft Team

In this blog post, we will discuss how to perform file upload using HTTP multipart/form-data format in SSIS without having to write a single line of code.


Paging REST requests in SSIS using KingswaySoft JSON Source Component

14 January 2021
Chen Huang

In this blog post, we will be going through some of the most common API pagination methods and demonstrate how to configure KingswaySoft JSON Source component to send out the paginated requests in SSIS.


Setting KingswaySoft Component Properties Dynamically

14 January 2020
Aswin Manmadhan

Parameterizing a component has many advantages over hardcoding the value. In this blog, we will see how parametrization can be done easily in KingswaySoft components.

 REST   SSIS 

Working with Dynamics 365 WebAPI in your ETL Process

27 February 2019
Daniel Cai

WebAPI is the latest web service interface for the CDS and Microsoft Dynamics 365 Customer Engagement platform. Working with WebAPI comes with a number of benefits. This blog post discusses how WebAPI can be used in your SSIS ETL process.


How to Work with Different OAuth 2.0 Grants in SSIS

01 June 2018
KingswaySoft Team

In this blog post we discuss how to work with OAuth 2.0 Password and Client Credentials grant types when working with web service endpoints in SSIS.

 REST   SSIS 

How Better Bathrooms Uses SSIS Productivity Pack to Consume REST APIs in SSIS

08 March 2018
KingswaySoft Team

In our recent case study we spoke with the team from Better Bathrooms to learn more about how they are using SSIS Productivity Pack in their data warehouse process to retrieve data from various REST APIs.