Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet 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
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
Solved! Go to Solution.
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.
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:
Or by using expressions:
@activity('Get Metadata1').output
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions
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.
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.
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 .
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 .
Hi @Bendelyon ,
Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.
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