Variable allowed in the "Get Data" Web feature, returned by a slicer or another means?

[CactusJackAZ]

I'm doing API calls to get data.  In the GET function of the API calls I need to put the application ID.  I would like to make this a variable that is linked to the slicer value the engineer selects.

The slicer will have a list of Applications the engineer can select, ideally it will return a numberic value to a GET function and then initiate the call which will then populate the other data sets and display the information related to that Application on various tables.

Here's the GET function, the 20 is an example of a value I would like the slicer to update

https://servername:port/controller/alerting/rest/v1/applications/20/health-rules

[Anonymous]

Hi @CactusJackAZ ,

What specifically are you trying to accomplish? Is it possible to incorporate some screenshot information and describe it? It would be easier for me to answer your question more accurately.

Best regards,

Adamk Kong

[CactusJackAZ · Accepted solution]

Hello Adam, excellent suggestion about describing my goal.

My end goal is to allow a user to select a specific Application and get information specific to that Application on the Power BI Dashboard.

A slicer does this task well if Power BI has all the data already. 

The issue is that the information we want to obtain requires various API calls using the information the user selected.  The API calls have the Application in the URL.  Not sure if there is some functionality that will allow me to pass an argument to the API calls and then initiate the call.

Maybe a user can pick a selection in the slicer and have that value pass to something like a curl command allowing Power BI to get the information. 

It would be nice to have the ability to download all the information for each Application so Power BI has it and then when selecting the value in the slicer it produces the data.  Yet I do not see a clean way to download the data.  I’m sure I can do various curl commands in a loop on Linux to extract the info.  Then clean the data up a bit and upload to a MySQL DB or even an excel spreadsheet so Power BI can consume it… but that would be quite messy.