Rest Connector query encoding

cbushey1 — Tue, 28 Dec 2021 20:06:43 GMT

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?

Re: Rest Connector query encoding

agni_gold — Sat, 16 Nov 2019 17:36:11 GMT

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

topic Re: Rest Connector query encoding in Connectivity & Data Prep

Rest Connector query encoding

Re: Rest Connector query encoding