topic REST Connector: How can I include a parameter within the URL? in Connectivity & Data Prep

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

Tue, 11 Oct 2016 21:02:02 GMT

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

Bjorn_Wedbratt — Wed, 12 Oct 2016 10:33:46 GMT

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