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 →