Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
Partner
Partner

Rest connection to RSA Archer

Hi Team,I am trying to establish the connection to RSA Archer  from qlikview to extract data , I am exploring the Rest connection , I got connection establish but its not supporting JSON. Please help on this to read data from RSA archer. 

Below is my custom connection string :

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;
url=http://Servername/apps/ArcherApp;
timeout=30;method=GET;
autoDetectResponseType=true;
keyGenerationStrategy=0;
authSchema=ntlm;
skipServerCertificateValidation=false;
useCertificate=No;
certificateStoreLocation=CurrentUser;
certificateStoreName=My;
queryParameters=Content-Type%2application/json;
queryHeaders=Authorization%2{%%3Authorization%%3:%%3Archer session-id%%2%%3 + $session_token,%%3X-Http-Method-Override%%3:%%3GET%%3,%%3Authorization%%3:%%3Archer session-id%%2%%3 + $session_token};
PaginationType=None;
allowResponseHeaders=false;
allowHttpsOnly=false;
XUserId=USERID;XPassword=PWD;";

error.jpg

Labels (1)
3 Replies
Support
Support

Re: Rest connection to RSA Archer

Hello @fularirahul , thanks for posting your issue!

Are you getting a JSON response from any other rest clients such as Postman or ARC or some other client?   Please test outside of Qlik, as the individual clients usually give debug information that could be helpful.  Once you get the response you seek, you can usually use modify this for use in QlikView or Qlik Sense.  

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Partner
Partner

Re: Rest connection to RSA Archer

Thank you , Will check with ARC rest client and will let you know.

anchittiwari
New Contributor

Re: Rest connection to RSA Archer

Hi, I am trying to connect Qlik to RSA Archer as well. Where you able to pull this off?

Any update would be helpful.