Discussion Board for collaboration related to QlikView App Development.
I was able to follow your logic with help from Qlik's Architect, but now I have another issue:
The loop goes through all states, but the output is only one state:01 that is specified in the connection string
for i= 01 TO 56
paramURL = 'https://api.census.gov/data/2015/acs5?get%2NAME,GEOID&for%2school+district+(unified):*&in%2state:$(i...mykeyxxx;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=xxx;XPassword=xxx;';
LIB CONNECT TO 'ABC';
FROM "root" FK "__FK_root" ArrayValueAlias "@Value")
FROM JSON (wrap on) "root" PK "__KEY_root"
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=$(paramURL)"
WITH CONNECTION (
LOAD [@Value] AS [@Value],
[__FK_root] AS [__KEY_root]
WHERE NOT IsNull([__FK_root]);
DROP TABLE RestConnectorMasterTable;
I have figured out what was the issue. I was mixing CUSTOM CONNECT TO with WITH CONNECTION
let paramURL = 'https://api.census.gov/data/2015/acs5?get=NAME,GEOID&for=school+district+(unified):*&in=state:$(i)&k...
[@Value] AS [@Value],
It it possible to store the Authorization token inside a variable that. I need to run the API inside a loop
and on each pass update the authorization token..
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://.mydomain/;timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWind... 'headers'%1Authorization%2Token token%%$(APIToken);PaginationType=None;XUserId=xxx;XPassword=99999;";
Is this possible?
Many thanks for any advice!
The API i have been told to use will only bring back 100 records at a time. I have been told to use 'Limit' and 'Offset' in my query parameters - nut cannot get this to work. Do I need any more information from the developers for this?
Thanks for any advice,
Hi ,I am looking for the solution to filter the data from rest connector.I have a query like belowSQL SELECT "id" as "id", "name" as "name_u1"FROM JSON (wrap on) "root" PK "__PK_root"; From name field I have to filter only Approved Data i.e., name= 'Approved'.Could you please help me to write the condition on API. I have tried query Parameters but no luck.Thanks in advance.