dynamic rest api calls on demand

[phyten]

I am trying to get a dynamic, on demand rest api call.

my call looks like https://jira.foo.com/bar/rest/api/isses/key?expand=bla,blub
This api call should be called on demand where the only thing that would change is the key. (loading all the data would take forever)

So for example:
I am importing basic data via excel import and after filtering through my data I see an entry that I am interested in.
Now I  am able to enter the key or just click on the entry (the key is present in a column within the currently loaded data) and powerbi starts the query and the queried data is shown withing a visualization.

EDIT: I managed to create a function which queries the data that I want and processes it the way I want. Though I still need to go into the query editor in order to call the function or change the parameter with EditQueries -> EditParameters and enter the key by hand. Is there a way to just Click the wanted key/dataset within a table for example.

[Anonymous]

Hi  @phyten,

You can write a custom function to call the api, for example:

let 
    CallAPI = (URL as text, token as text) as any =>
let
    Source = Web.Contents(URL, [Query=[], Headers=[#"APIToken" = token]])
in
    Source
in
    CallAPI

Notice, custom function only work on desktop side.

Regards,

Xiaoxin Sheng

[Anonymous]

I think your only option just now is copy-pasting the key to a Query Parameter that is used in your REST call and then refreshing your data.

You can link a parameter to a Query - if you only have a small number of keys to choose from, you can make the keys appear in a selection list for the Query Parameter.

Alternately, can you bring in all the related data to Power BI up front, then filter via a slicer?