Implementing OAuth REST Connections for NetSuite in SSIS Processes
In NetSuite, we have introduced the option to work with REST Token-Based authentication to establish a connection with your NetSuite environment. This modern approach offers flexibility with access to objects and the actions to perform on them and is lightweight.
Automate Exporting and Emailing Power BI Reports with KingswaySoft
Power BI reports are a great way to get quick and detailed snapshots of data sources. In this blog post, we will discuss how to export reports in your preferred offline format (such as PDF) and send them to any email address required, all within a single data flow. Additionally, you will be able to dynamically set how frequently to send the report and to add or remove recipients receiving this email.
Working with Concur API to Close Batches and Retrieve Report Files using KingswaySoft Components
SAP Concur is a widely popular service for travel, expense, and invoice management, and there are many use cases in which you would need to access the endpoints to process a request and get the response back. One such business case would be finding and closing batches based on processed batch numbers, downloading a report, and storing the data in a database system. We will see how this can be done using KingswaySoft components.
Action Required for HubSpot Connections to Stay Compliant with Contacts Scope Updates
HubSpot has announced some recent security enhancements in their APIs which now provide more granular CRM scopes. With this change, you will need to update your HubSpot connections in order to stay compliant.
Working with Business Central/NAV REST API v2 in SSIS
This post will walk you through how to query the Dynamics Business Central/NAV REST API data by using the Premium OData Source component.
Working with Microsoft Graph API in SSIS using KingswaySoft Productivity Pack
In this blog post we will demonstrate how to use the Premium OData Source component to work with SharePoint site data through Microsoft Graph REST API.
Working with SharePoint Online through OData v4 Endpoint
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
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
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
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
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.
Working with Dynamics 365 WebAPI in your ETL Process
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
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.
How Better Bathrooms Uses SSIS Productivity Pack to Consume REST APIs in SSIS
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.
How to Work with RESTful Endpoints in your SSIS ETL Process
Connecting to an integrating with a REST API in SSIS can be a tricky process. In this blog post we will walk you through how our SSIS Productivity Pack can be used to simplify the development process. We will be working with ZenDesk as an example to demonstrate integration with a REST API feeding data in JSON format.