Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fularirahul
Partner - Contributor
Partner - Contributor

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)
9 Replies
Jay_Brown
Support
Support

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.
fularirahul
Partner - Contributor
Partner - Contributor
Author

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

anchittiwari
Contributor
Contributor

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

Any update would be helpful.

donnadima
Contributor
Contributor

Were you able to get archer to connect to qlik sense?

please let me know

thank you,

donna

fularirahul
Partner - Contributor
Partner - Contributor
Author

Yes . I will share the details tomorrow.
LazyBanker
Partner - Contributor
Partner - Contributor

Hi @fularirahul, I may need to use a similar connection. Can you post what you found out from your troubleshooting? And how you were able to connect?

Thanks!

cnkrgz
Contributor
Contributor

I`m trying to connect QlikSense and Archer as well. I`d be glad if you guys who made it can share some information. Appreciate any input. 

Marc_Fontana
Employee
Employee

Hello, were you able to get this to connect with Qlik Sense?  Any new ideas on this one?

Thanks,

 

Marc

 

JohnSacco
Employee
Employee

Would be interested in the solution for how to connect as well if you can share