Today, a lot of data is in SAAS solutions in the cloud. Like SalesForce, Exact Online and Dynamics 365. To import this data using Azure Data Factory you need to connect to the data via a Web API (Web Service). This can be challenging if you have never done this before.

In this session I will show you step by step what to do and what pitfalls to avoid. The following topics will be covered:
- Introduction to Web APIs: JSON/XML data format, REST API + ODATA
- Paging: often you can't get all the data at once and you have to call the Web API several times, page by page.
- Variables and ForEach activity in Data Factory
- Incremental Refresh: since fetching all data can be very slow via a Web API, it is better to only load new data.
- Authentication using API Token or OAuth (Access Token)