Split and Parse Through JSON Structures using KingswaySoft

30 September 2022
KingswaySoft Team

Having a JSON response that needs to be properly parsed is a very common use case. This can be an advanced JSON structure like arrays, key-value pairs, etc. Our KingswaySoft JSON components can easily parse through them using the various settings and options available. However, there could be cases in which a JSON design is such that it could have records that need to be handled separately. In this blog post, we will discuss such a case.


Using KingswaySoft to Send Emails with Attachments Dynamically

25 August 2022
KingswaySoft Team

Sometimes we need to attach files with specific conditions to one email and send it. In this blog post, we will show how you can quickly do it by using our components.


Extracting CRM Entity Metadata using Premium OData Components

29 July 2022
KingswaySoft Team

In this blog, we are trying to get the metadata information from Dynamics 365 CRM API and save the entities and attributes in different tables. This is useful in many use cases where you wish to get a list of all the present entities and their corresponding metadata as a part of your integration - especially for further parameterization plans.


Unzip and Read Files from Cloud Storage for Transparent ETL Processing

28 July 2022
KingswaySoft Team

In cases where you have a set of files compressed as a zipped folder in a cloud location, you might have requirements where you need to unzip these files first and then read them one by one to parse the data out to a destination database table or another set of files. To perform this manually wouldn't be as simple as it sounds. However, by using solutions provided by us, this can be easily automated.


Working with Concur API to Close Batches and Retrieve Report Files using KingswaySoft Components

28 June 2022
KingswaySoft Team

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.


Extracting CRM entity metadata using KingswaySoft JSON Components

30 May 2022
KingswaySoft Support

In this blog, we are trying to get the metadata information from Dynamics 365 CRM API and save the entities and attributes in different tables. This is useful in many use cases where you wish to get a list of all the entities that are present, and its corresponding metadata as a part of your integration - Especially for further parameterization plans.


Read and Load Data Files Iteratively from a Storage Location

13 April 2022
KingswaySoft Team

There are cases where we would need to retrieve a set of files from a storage location, which are dropped on the same day, and read them one by one, to then store them into a database table. We can easily achieve this using KingswaySoft components and the SSIS Foreach loop container.


Executing Snowflake Functions in SSIS ETL Processes

28 March 2022
KingswaySoft Team

The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions.


Archive

Tags