get a list of PDF metadata

[caomayan]

Hi folks! I need to get metadata (created, size, item name etc.) for a bunch of PDF files on Shared drive, how can I achieve this? My plan is to get the childname from the first "Get Metadata", then loop the name into the second "Get Metadata", but it errors out. 

Thanks a lot!

[spencer_sa]

How I got it to work for me:
Pipeline. similiar to yours, although my first is looking up all files in a lakehouse.

ForEach Items property

2nd Get Metadata settings - note the .name

And the output

[spencer_sa]

Also note this works with GenII datalake connections too;

[caomayan]

Thanks so much, got it works!

Next, how can I get these fields into a lakehouse table? I am thinking notebook, but didn't find a way yet..

[spencer_sa · Accepted solution]

Feed them into a notebook as separate parameters, then either create a dataframe with the parameters and 'append' it to an existing table *or* dynamically generate a SQL INSERT statement with the wanted parameters being used