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 […]
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 […]
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
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
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 […]
What is JSONPath expression JSONPath expression is an expression language to filter JSON Data. Its similar concept to XPath expression in XML but has limited features compared to XPath. If you are extracting data from REST API Services using JSON Source Connector then you will quickly realize that it’s very important to extract nested data by […]
Introduction In this article we will learn how to use SSIS JSON Source Component to fetch JSON data from OData service and perform OData Pagination of large result. In OData specification data may come in JSON format or XML format. For XML format check this article. This article will cover mostly OData JSON API example. REST […]
Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume / call REST API in SSIS check this article. HTTP Authorization Header […]