topic ServiceNow Rest API in App Development

ServiceNow Rest API

madan0717 — Mon, 30 Oct 2017 19:19:56 GMT

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

Re: ServiceNow Rest API

Anonymous — Wed, 17 Jan 2018 09:39:20 GMT

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.

Re: ServiceNow Rest API

pavelmuller — Mon, 04 Feb 2019 09:11:37 GMT

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