Tips for calling API from data flow? · Learn Microsoft Fabric

May '24 (edited) • Technical

Tips for calling API from data flow?

I need to put some data into my data warehouse, but using Web API in data flow is not possible since I need to do an authentication request with a JSON body to get a JWT token to do requests, but Web API won't allow me to do a request with a body.

So Get Data -> Web API is obviously not usable.

What usable methods are there?

I have been able to call the API and fetch data in a Power Automate Flow, and could very well store the JSON data in a file and read the file in the data flow, but this is too much of a workaround for my taste :)

7 comments