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

Get data from Zuora in SSIS using REST API

  SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) Meanwhile check following similar articles : Read Zendesk data in SSIS using REST API Get data from SurveyMonkey in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol Zuora REST API: […]

Read MongoDB data from array (extract nested sub documents)

Introduction In this post you will learn how to read MongoDB data from Array. We recently introduced new JSON Path expression feature in SSIS MongoDB Source Connector to extract nested information from MongoDB documents.   Read documents from Array in MongoDB By default SSIS MongoDB Source Connector doesn’t support extracting data using JSON Path expression. So if […]

Reading JSON Arrays from file / REST API

Introduction REST API is becoming more and more common and with that you will see explosion in use of JSON data format. One of the questions we get a lot is “How to extract or read array from JSON data file” or “How to read multiple arrays from JSON data“. Example : Store JSON document […]

How to get data from Facebook in SSIS using REST API

Introduction In this article you will learn how to get data from Facebook using Graph API (OAuth 2.0) using SSIS PowerPack REST api Connectors. Facebook provides rich set of REST API to access data. Their REST API is also known as Facebook Graph API and it uses OAuth 2.0 Authorization. Traditionally any REST API Integration scenarios […]

How to get data from Workday in SSIS using SOAP/REST API

Introduction In this article you will learn how to get data from WorkDay SOAP web service in few clicks using SSIS SOAP XML Source. All you need to know how to create SOAP Request correctly and provide Authorization (e.g. Userid, Password) inside your request (You can generate that easily using Free tools like SoapUI). Once you do […]

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

Get data from Google Maps in SSIS using REST API

Full article coming soon. Meanwhile check following similar articles : SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) Read Zendesk data in SSIS using REST API Read Twitter data in SSIS using REST API Task and JSON Source – OAuth2 Protocol Get data from SurveyMonkey in SSIS using REST […]

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

Get data from Marketo in SSIS using REST API

Full article coming soon. SSIS XML Source (FILE, SOAP, REST API Connector) SSIS JSON Source (File, REST Connector) 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 Marketo API Reference: Marketo REST API reference link

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

Get data from Mozends 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 Mozends API Reference: Mozends REST API reference link  

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 […]

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 […]