topic How to make variables in REST API dynamic in QlikView

topic How to make variables in REST API dynamic in QlikView https://community.qlik.com/t5/QlikView/How-to-make-variables-in-REST-API-dynamic/m-p/1289746#M403461 <HTML><HEAD></HEAD><BODY><P>Dear Community:</P><P></P><P>I am having problem with Census API. I am not able to pass a wildcard on the state: parameter with combination of district. I am trying to figure out how can I make the variable dynamic in order to pull all the states at the same time.</P><P></P><P>Any hint or help is greatly appreciated.</P><P></P><P>Thanks,B</P><P></P><P>API:<A href="https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_007E,B17024_008E,B17024_009E,B17024_010E,B17024_015E,B17024_016E,B17024_017E,B17024_018E,B17024_019E,B17024_020E,B17024_021E,B17024_022E,B17024_023E,B17024_028E,B17024_029E,B17024_030E,B17024_031E,B17024_032E,B17024_033E,B17024_034E,B17024_035E,B17024_036E&&for=school+district+(unified):*&in=state:06&key=" title="https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_007E,B17024_008E,B17024_009E,B17024_010E,B17024_015E,B17024_016E,B17024_017E,B17024_018E,B17024_019E,B17024_020E,B17024_021E,B17024_022E,B17024_023E,B17024_028E,B17024_029E,B17024_030E,B17024_031E,B17024_032E,B17024_033E,B17024_034E,B17024_035E,B17024_036E&&for=school+district+(unified):*&in=state:06&key=">https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_…</A></P></BODY></HTML> Wed, 01 Mar 2017 21:00:25 GMT pentaxadmin 2017-03-01T21:00:25Z How to make variables in REST API dynamic https://community.qlik.com/t5/QlikView/How-to-make-variables-in-REST-API-dynamic/m-p/1289746#M403461 <HTML><HEAD></HEAD><BODY><P>Dear Community:</P><P></P><P>I am having problem with Census API. I am not able to pass a wildcard on the state: parameter with combination of district. I am trying to figure out how can I make the variable dynamic in order to pull all the states at the same time.</P><P></P><P>Any hint or help is greatly appreciated.</P><P></P><P>Thanks,B</P><P></P><P>API:<A href="https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_007E,B17024_008E,B17024_009E,B17024_010E,B17024_015E,B17024_016E,B17024_017E,B17024_018E,B17024_019E,B17024_020E,B17024_021E,B17024_022E,B17024_023E,B17024_028E,B17024_029E,B17024_030E,B17024_031E,B17024_032E,B17024_033E,B17024_034E,B17024_035E,B17024_036E&&for=school+district+(unified):*&in=state:06&key=" title="https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_007E,B17024_008E,B17024_009E,B17024_010E,B17024_015E,B17024_016E,B17024_017E,B17024_018E,B17024_019E,B17024_020E,B17024_021E,B17024_022E,B17024_023E,B17024_028E,B17024_029E,B17024_030E,B17024_031E,B17024_032E,B17024_033E,B17024_034E,B17024_035E,B17024_036E&&for=school+district+(unified):*&in=state:06&key=">https://api.census.gov/data/2015/acs5?get=NAME,GEOID,B17024_002E,B17024_003E,B17024_004E,B17024_005E,B17024_006E,B17024_…</A></P></BODY></HTML> Wed, 01 Mar 2017 21:00:25 GMT https://community.qlik.com/t5/QlikView/How-to-make-variables-in-REST-API-dynamic/m-p/1289746#M403461 pentaxadmin 2017-03-01T21:00:25Z