Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
madan0717
Contributor
Contributor
‎2017-10-30 03:19 PM

ServiceNow Rest API

Hi All,

   I'm using ServiceNow Rest API to pull the data. I have 400k records in Incident table.It seems there is a limit on Data extraction from servicenow to QLIK. I'm getting only ~90k records.In order to pull all 400k records, I believe I have to create multiple connections. Did any one have ideas on how to handle multiple connections in QLIK by using ServiceNow REST API?.

Thanks,

Madan

2,139 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2018-01-17 04:39 AM

Hi Madan,

You can create multiple REST connections having different URLs  and also can use the concept of WITH Connection and pagination if applicable.

Some APIs have timeout in their servers . You can apply some Sleep function in your script to check that.

For more clarity , you can give your request file or screenshot.

1,761 Views
0 Likes
pavelmuller
Contributor
Contributor
‎2019-02-04 04:11 AM

Hi, 

I think that it is not a good idea to connect the reporting tool directly to a live ServiceNow instance. Not only it can affect the production environment but it will be simply too slow to download high volumes of data for each report execution.

The preferred way is to build an on-premise read-replica (i.e. a mirror database) and connect QlikSense to this local database. It will be much faster and your ServiceNow won't be affected.

You could use tools such as SnowMirror to extract the data from ServiceNow (or Salesforce).

http://www.snow-mirror.com/

Kind Regards,
Pavel

1,719 Views
0 Likes