Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to integrate an API with my own data as input.
I have this table and this API:
How can i use the input of my day filter in this API and run this API for each row in the table?
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! |
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
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.