How do I connect to an API in SSIS?

If you can't find an article in ZappySys Blog about specific API integration you are interested in, then read below how to proceed:

1. First of all, find your API's documentation. Look for a link named API or API docs or API documentation or Developers or alike. For Youtube API, the link would be https://developers.google.com/youtube/v3/docs/.
2. Find the way, how to authenticate to an API. Most APIs use OAuth. If that's the case, read our article about how to authenticate to an OAuth provider. If not then usually you will simply have to pass your personal API key in URL or in HTTP request headers.
3. Once you have authenticated to your API, you will have to make either a RESTful call to REST API or SOAP request if your API is actually a Web Service.
   1. To make a RESTful request: use REST API Task to call/write data to your API or use JSON Source to load data from it. You can read an article on how to load data from any API to SQL Server. Also for the sake of example take a look at the article which discusses how to load/post data using Office 365 API.
   2. To make a SOAP request: use REST API Task to call/write data and XML Source to read data from an API. Read more on how to make SOAP requests. You can also check an article on how to get data from Workday using SOAP requests.
4. Sometimes you may need to make URL dynamic. In other cases, you want to paginate through the results.
5. If you are looking at how to send data, check an article how to POST data to an API.
6. Finally, examine other articles regarding API Integration, maybe you will find an article which has something in common with your API: https://zappysys.com/blog/category/api-integration/. 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/