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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!