API request from BI report

[DionTN]

I want to integrate an API with my own data as input. 

I have this table and this API: 

https://api.flightstats.com/flex/flightstatus/rest/v2/json/flight/status/{vluchtnummer1}/{vluchtnumm...

How can i use the input of my day filter in this API and run this API for each row in the table?

[KNP]

Hi @DionTN,

Which API are you trying to use?

Would be helpful if you could post some of the Power Query code you have so far.

[jbwtp]

Hi @DionTN,

You can do this using something like Web.Content(), but this needs to be done in Power Query editor (on your screeshot you showing a visual in the report, so you may be thinking about DAX?). In PQ editor you can use Add Column to call API on each row. However, as @Daryl-Lynch-Bzy said, you will need to find the API call details from the API vendor/support.

Kind regards,

John

[Daryl-Lynch-Bzy]

Hi @DionTN - I am sorry but I don't think this community can help because your query is more specifically related to the api instruction.  Please refer to the API Developer instruction provided by FlightStats.