Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Bendelyon
Helper I
Helper I

How to use the get metadata output json in a notebook

Hello everyones

I need to use the json output folder of a get metadata activity in a notebook.

 

How Can i do ?

 

Thanks for your help 

 

Ben

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Bendelyon ,

Thanks for using Fabric Community.
Did you tried checking this - Microsoft Spark Utilities (MSSparkUtils) for Fabric - Microsoft Fabric | Microsoft Learn

We can get the list of files present inside lakehouse using Code -

 

files = mssparkutils.fs.ls("path")

 


Please let me know if you have further queries.


View solution in original post

7 REPLIES 7
Expiscornovus
Super User
Super User

Hi @Bendelyon,

 

Do you want to reuse the output in another activity of your pipeline, if so what are you trying to do with the output? Can you share a bit more details about this?

 

Normally you should be able to reuse the output as dynamic content: 

https://learn.microsoft.com/en-us/fabric/data-factory/get-metadata-activity#using-the-get-metadata-a...

 

Or by using expressions:

@activity('Get Metadata1').output

 

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions

 



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

For more details

This IS ma schema 

 

Parent folder A1 

Child folder a

Csv

Parent folder A2

Child folder a

Csv

Parent folder A3

Child folder a

Csv

Etc 

...

 

My Idea IS to use 'get metadata' to get the name of the folder (A1, A2, A3) and make a python list in a notebook to iterate and consolidate the csv files.

 

Hope you could understand.

 

Anonymous
Not applicable

Hi @Bendelyon ,

Thanks for using Fabric Community.
Did you tried checking this - Microsoft Spark Utilities (MSSparkUtils) for Fabric - Microsoft Fabric | Microsoft Learn

We can get the list of files present inside lakehouse using Code -

 

files = mssparkutils.fs.ls("path")

 


Please let me know if you have further queries.


Anonymous
Not applicable

Hello @Bendelyon ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Anonymous
Not applicable

Hi @Bendelyon ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Anonymous
Not applicable

Hi @Bendelyon ,

Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.

Hi @Expiscornovus 

 

I want to use the @activity@activity('Get Metadata1').output.childitems to make a python list and reuse it in a notebook. 

The easier gonna be to use all of the activities in the same pipeline.

 

Do not know if i could do this ?

 

Thanks 

 

  • @activity('Get Metadata1').output

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.