Contents [hide]
1 Introduction
2 Prerequisites
3 REST API Concepts
4 Configure SSIS JSON Source to Read from REST API or local File
4.1 Configure Connection – Pass credentials
4.1.1 Configure HTTP Connection
4.1.2 Configure OAuth Connection
4.2 Example of JSON/REST API Source
5 Loading data from REST API to SQL Server
6 POST Data to ServiceNow API (Insert, Update or Delete)
7 Common Errors
7.1 Truncation related error
7.2 … Read More →