Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to API calls but need some help with what I am working on. I am using the rest connector in Qliksense
I am able to successfully make a connection to grab a small set of data that includes the 'IDs' for a list of reports. This data is in .json
I am also able to successfully make a connection on a separate call where it gives me detailed information on a specific report (this data is in csv), but I have to include the id in the URL request for the connection. (https:/testurl.com/api/v1/scenario/ac19342-A06c-4c65-84d5-2b39ff28d4c7/full_csv)
This is probably a loaded question but how do I take the IDs from the first API call and have them each run through the second API call to get detailed information on all of the reports?
Hopefully that made some sense. Thanks!
This app (https://community.qlik.com/t5/Qlik-Monitoring-Administration/Sense-App-Metadata-Analyzer/gpm-p/15921...) does similar things. You're welcome to inspect the script, but the key elements are in the get_apps and app_metadata sections of the load script. In get_apps, it pulls a list of all apps and sets a flag (AppReloadedInJune2018Plus). The flag likely isn't needed in your use case. But with that list of apps, each app's metadata is iterated over in app_metadata. The bit that you'll likely also want to do is to use WITH CONNECTION in the REST Connector call like the above app does so that you can re-write the URL.
Hope that helps.