How to get data from MailChimp in SSIS with REST API

Introduction In this article you will learn how to automate/integrate MailChimp API calls inside SSIS without any coding efforts. Historically anytime you want to access API or Automate workflow you have to use SDKs or write custom script which can be very time consuming and expensive effort. If you are looking for drag and drop […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

How to create google API Project and Service account

This article is Moved to this location How to register Google OAuth Application (Get ClientID and ClientSecret)     Perform following steps to create new google service account Login here https://console.developers.google.com/ and create new project under which we will access APIs . In the Google APIs Console, under the API Access pane, create a client […]

How to get data from SurveyMonkey in SSIS with REST API

Introduction In this post we will see how to get data from SurveyMonkey in SSIS using their REST API. Interacting with REST API requires programming skill and if you are not Programmer you may face dead end. SSIS PowerPack JSON REST API Connector (for XML REST API check XML Source Connector) makes it super easy to consume […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Get data from FastSpring in SSIS using REST API

Full article coming soon. Meanwhile check following similar articles : Get data from Zendesk in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol FastSpring API Reference: FastSpring REST API reference link

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

Get data from TSheets in SSIS using REST API

Full article coming soon. Meanwhile check following similar articles : Read Zendesk data in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol TSheets API Reference: TSheets REST API reference link

Create new Zendesk REST API Access Token

Call Zendesk REST API in SSIS – Create Ticket

Introduction Zendesk is one the most popular customer service platforms available in the market today. Zendesk offers REST API so you can interact with their cloud based service programmatically (manage or read data). The problem is not every one is programmer and not everyone has time to learn how to write C# or JAVA code […]