Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cbushey1
Creator III
Creator III

Rest Connector query encoding

Trying to pass a query parameter in the rest connector for qlikview. The name of the field has spaces in it, and I am not sure how to code the connector to accurately pull it back. 

Here is my current code:

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://api.census.gov/data/2010/dec/sf1?get%2P001001,NAME;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryParameters=for%2zip+code+tabulation+area:*;PaginationType=None;XUserId=YWBeaGC;XPassword=BeLIMaC;";

Here is what I know works, but I am not sure how to have the Qlik connector use this url:
https://api.census.gov/data/2010/dec/sf1?get=P001001,NAME&for=zip%20code%20tabulation%20area:*

Any thoughts on how to code the zip code tabulation area?

Labels (1)
1 Reply
agni_gold
Specialist III
Specialist III

you can load as web file in qliksense directly , and correct the data using purgechar function