topic Re: Configuration settings for a REST connection from Qlik to ServiceNow in Integration, Extension & APIs

Configuration settings for a REST connection from Qlik to ServiceNow

MishaM — Thu, 16 Jun 2022 12:51:50 GMT

Hi,

Could someone please assist me with setting up a REST connection from Qlik to ServiceNow? I am trying to connect to ServiceNow to primarily access saved reports from various tables like the incident table. I do have ServiceNow service account credentials.

Thank you!

Re: Configuration settings for a REST connection from Qlik to ServiceNow

Andrew_Roy — Tue, 21 Jun 2022 21:20:17 GMT

Please refer to the following QCS Help page for configuration assistance with a REST connection to ServiceNow using offset pagination:

https://help.qlik.com/en-US/cloud-services/Subsystems/REST_Connector_help/Content/Connectors_REST/Create-REST-connection/Pagination-scenarios.htm

Note also that there is a Cloud automation connector for ServiceNow:

https://help.qlik.com/en-US/cloud-services/Subsystems/Sense_QlikAutomation/Content/Sense_QlikAutomation/connector-blocks/connectors-list.htm

Re: Configuration settings for a REST connection from Qlik to ServiceNow

MishaM — Mon, 27 Jun 2022 19:46:33 GMT

I did the configurations listed on the QCS help page, but I still wasn't able to get any reports to load into Qlik. When I try 'Select Data to Load' from the data connection, I get an error:

"Cannot parse data in the selected response type. Check the "Response Type" parameter value. Xml parsing error: An error occurred while parsing EntityName. Line 146, position 28."

The response type was XML when I got the error above.

When I change the response type to CSV and check the options on the left, fields appear, but none of them are in the report I'm trying to load.

Is there a specific URL format or anything else I need to enter to get the data to load?