Data loading from ServiceNow rest api to Azure SQL database

pankaj chaturvedi 86 Reputation points
2023-01-23T10:57:58.4733333+00:00

Hi Team,

I want to load the data from ServiceNow Rest API to Azure sql database table using ADF . Rest Api response is JSON type. How can I extract complete data from API and load into sql table. I have gone through some docs and got to know only 10,000 rows can only fetch at once, but I wanted to load complete if possible. Can you please help me out if some one has experience working with ServiceNow API. Many thanks.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,205 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.