Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

REST Connector: How can I include a parameter within the URL?

I'm trying to hit a URL for CDC data, example URL as follows: http://ephtracking.cdc.gov/apigateway/GetData/v1/587/All/0/All/0/json

The issue is that the URL structure is set up to embed measure IDs within the URL, for example http://ephtracking.cdc.gov/apigateway/GetData/v1/{MEASURE}/All/0/All/0/json 

Is there a way to set up the data loading to pass a series of values within for MEASURE within the data load editor or do I have to hand code them?

Thanks

Tags (1)
1 Reply
Employee
Employee

Re: REST Connector: How can I include a parameter within the URL?

Hi David,

Have you looked into the WITH CONNECTION statement as described here: Select REST data ‒ Qlik Connectors ?

You can dynamically craft the URL using variables in the script and use the WITH CONNECTION statement similar to:

...

FROM "Something"

WITH CONNECTION (

URL "$(vMyVariable)"

)

Hope that helps

Best,

Bjorn

Community Browser