Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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