Introduction In this post, you will learn how to read / write Zoho CRM data using SSIS (Drag and drop approach without any coding). We will use SSIS JSON/ REST API Source to extract data from Zoho API and use SSIS Web API Destination to write data to Zoho. We will look at step-by-step instructions to read Zoho CRM […]
Monthly Archives: February 2018
How to convert JSON to CSV File using SSIS
Introduction In this article, you will learn how to convert JSON to CSV File using SSIS. Sometimes you need to convert JSON file to a CSV, which resides in your local disk or somewhere on the Internet, be it a simple download link or a more sophisticated API call. Using ZappySys SSIS PowerPack together with […]
Read / Write Smartsheet data using SSIS REST API Call
Introduction In this post you will learn how to Read / write Smartsheet data using SSIS (Drag and drop approach without any coding). We will use SSIS JSON/ REST API Source to extract data from Smartsheet API and use SSIS Web API Destination to write data to Smartsheet. This approach is similar to our previous […]