API request from BI report

DionTN · ‎08-17-2022

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 · ‎08-18-2022

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.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

jbwtp · ‎08-18-2022

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 · ‎08-18-2022

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.