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 Work with Salesforce Bulk API

26 September 2022
KingswaySoft Team

If you have a large number of records, you need to read and the process is taking longer than anticipated you may benefit from using Salesforce’s Bulk API. Salesforce Bulk API benefits you when you have many records (Salesforce states data operations with 2000+ records make a good candidate) in the Salesforce system and these records are being read synchronously. Today we will look at the features in Salesforce Bulk API and how KingswaySoft components make Bulk jobs easier.


Archiving and Deleting Dynamics CRM/CE Audit Logs for Efficient Space Management

26 August 2022
KingswaySoft Team

Audit logs take up a lot of space in your CRM/CE instance, and there are cases where you would want to have a way to archive the audit logs and have them removed from the system after archiving, to reclaim the space in an automatic manner. Using KingswaySoft, this can be easily achieved.


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.


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.


Download Document Version History from SharePoint in SSIS

27 June 2022
KingswaySoft Team

SharePoint Document Library supports version histories, so you can store and track different versions of each document file within the library as changes are made to the file. Such version control infrastructure provides many unique benefits. For instance, if something went wrong with one of the files because of a recent accidental/unintended change, you can easily restore it to a prior version as needed. Also, in your ETL development, you might often run into the requirements that you need to extract all previous versions of a file. In this blog post, we will show how to achieve this using our SharePoint Source component to download document library file versions and using the Premium File System Destination component (offered in SSIS Productivity Pack) to save them to a local file system in SSIS.


Working with NetSuite Custom Fields using KingswaySoft SSIS Components

31 May 2022
KingswaySoft Team

NetSuite Custom fields are fields that you can add to records and transactions which can be used to save some additional information. This provides quite some flexibility when working with the NetSuite application if we have some special business requirements which cannot be accomplished using those out-of-box fields. Once added, those fields require some special attention in order to use use them in SSIS ETL data flows. In this blog post, we will show you how this can be done easily by using KingswaySoft components.


Action Required for HubSpot Connections to Stay Compliant with Contacts Scope Updates

28 April 2022
KingswaySoft Team

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.


Archive

Tags