What is the recommended approach to connect and interact with a Microsoft Fabric Lakehouse from an Azure Logic App?

Question

What is the recommended approach to connect and interact with a Microsoft Fabric Lakehouse from an Azure Logic App?

Akshay Patel 150

In my current workflow, Azure Logic Apps is configured to trigger when a file is added to a Box folder. It then copies the file and stores it in an Azure Data Lake Storage (ADLS) location.

As part of our migration to Microsoft Fabric, we need to modify this workflow so that the file is stored in a Lakehouse instead of ADLS. What is the best way to achieve this integration between Azure Logic Apps and Microsoft Fabric Lakehouse? Are there any connectors or APIs that can be used for this purpose?

Praveen Kumar Gudipudi 190 Reputation points Microsoft External Staff Moderator

2025-05-06T20:00:45.4433333+00:00

Akshay Patel ,

Have you tried with HTTP connector (rest api) to store file in Lake house.

Please check rest API documentation https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api.

Please configure HTTP connector with proper headers and authentication to access lake house.

If you need further assistance, please feel free to reach out us.
Akshay Patel 150 Reputation points

2025-05-07T05:42:34.51+00:00

@Praveen Kumar Gudipudi Thank you for your valuable response.
For example, I need to get a list of files available in the Lakehouse (Files > Data) folder. Based on that, could you please assist me with the following:

Where can I find the API endpoint?

How can I call it from a Logic App?
Praveen Kumar Gudipudi 190 Reputation points Microsoft External Staff Moderator

2025-05-07T17:41:18.6433333+00:00

Akshay Patel ,

To list files, you should use an endpoint similar to this

https://onelake.dfs.fabric.microsoft.com/{workspaceId}/{lakehouseId}.lakehouse/Files?resource=filesy...

You’ll need to include the appropriate authentication headers, typically using a bearer token obtained for the ‘storage’ scope.

use this approach and see

import requests

workspace_id = "your_workspace_id"

lakehouse_id = "your_lakehouse_id"

token = mssparkutils.credentials.getToken("storage")

url = f"https://onelake.dfs.fabric.microsoft.com/{workspace_id}/{lakehouse_id}.lakehouse/Files?resource=file..."

headers = {"Authorization": f"Bearer {token}"}

response = requests.get(url, headers=headers)

files = response.json()

Also, please refer this document
https://community.fabric.microsoft.com/t5/Data-Engineering/Listing-files-using-REST-API-in-Lakehouse/m-p/4383610

Please check with above API and let me know with an update.
Akshay Patel 150 Reputation points

2025-05-08T12:11:20.61+00:00

Thanks @Praveen Kumar Gudipudi
Thank you for taking the time to respond to my question regarding the integration of Azure Logic Apps with Microsoft Fabric Lakehouse. I really appreciate your guidance and insights your response helped clarify the direction.

1 answer

Your answer

Praveen Kumar Gudipudi 190 Reputation points Microsoft External Staff Moderator

2025-05-06T20:00:45.4433333+00:00

Akshay Patel ,

Have you tried with HTTP connector (rest api) to store file in Lake house.

Please check rest API documentation https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api.

Please configure HTTP connector with proper headers and authentication to access lake house.

If you need further assistance, please feel free to reach out us.
Akshay Patel 150 Reputation points

2025-05-07T05:42:34.51+00:00

@Praveen Kumar Gudipudi Thank you for your valuable response.
For example, I need to get a list of files available in the Lakehouse (Files > Data) folder. Based on that, could you please assist me with the following:

Where can I find the API endpoint?

How can I call it from a Logic App?
Praveen Kumar Gudipudi 190 Reputation points Microsoft External Staff Moderator

2025-05-07T17:41:18.6433333+00:00

Akshay Patel ,

To list files, you should use an endpoint similar to this

https://onelake.dfs.fabric.microsoft.com/{workspaceId}/{lakehouseId}.lakehouse/Files?resource=filesy...

You’ll need to include the appropriate authentication headers, typically using a bearer token obtained for the ‘storage’ scope.

use this approach and see

import requests

workspace_id = "your_workspace_id"

lakehouse_id = "your_lakehouse_id"

token = mssparkutils.credentials.getToken("storage")

url = f"https://onelake.dfs.fabric.microsoft.com/{workspace_id}/{lakehouse_id}.lakehouse/Files?resource=file..."

headers = {"Authorization": f"Bearer {token}"}

response = requests.get(url, headers=headers)

files = response.json()

Also, please refer this document
https://community.fabric.microsoft.com/t5/Data-Engineering/Listing-files-using-REST-API-in-Lakehouse/m-p/4383610

Please check with above API and let me know with an update.
Akshay Patel 150 Reputation points

2025-05-08T12:11:20.61+00:00

Thanks @Praveen Kumar Gudipudi
Thank you for taking the time to respond to my question regarding the integration of Azure Logic Apps with Microsoft Fabric Lakehouse. I really appreciate your guidance and insights your response helped clarify the direction.

Answer 1

Akshay Patel ,

Have you tried with HTTP connector (rest api) to store file in Lake house.

Please check rest API documentation https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api.

Please configure HTTP connector with proper headers and authentication to access lake house.

User's image

To list files, you should use an endpoint similar to this

https://onelake.dfs.fabric.microsoft.com/{workspaceId}/{lakehouseId}.lakehouse/Files?resource=filesy...

You’ll need to include the appropriate authentication headers, typically using a bearer token obtained for the ‘storage’ scope.

use this approach and see

import requests

workspace_id = "your_workspace_id"

lakehouse_id = "your_lakehouse_id"

token = mssparkutils.credentials.getToken("storage")

url = f"https://onelake.dfs.fabric.microsoft.com/{workspace_id}/{lakehouse_id}.lakehouse/Files?resource=file..."

headers = {"Authorization": f"Bearer {token}"}

response = requests.get(url, headers=headers)

files = response.json()

Also, please refer this document https://community.fabric.microsoft.com/t5/Data-Engineering/Listing-files-using-REST-API-in-Lakehouse/m-p/4383610

If this answer was helpful, please click "Accept the answer" and mark Yes, as this can help other community members.

If you have any other questions or are still experiencing issues, feel free to ask in the "comments" section, and I'd be happy to help.

Share via

What is the recommended approach to connect and interact with a Microsoft Fabric Lakehouse from an Azure Logic App?

1 answer

Your answer