Python Get File Properties from SharePoint Using Office365 Rest Package Part 6

This is Part 6 to this multipart session.

Will be added a function to get a list of files with key properties for each file. I will show examples on how to do it.

Source code can be find on my GitHub account (view below).

Support my Channel

Book a 1 on 1 meeting with me at:

[KARINPAOLILITA]

Gracias por el contenido, muchas gracias

[joselrnzrodriguez]

Hi Lu,
qq, I am currently working on getting files from share point,
What you recommend if have 10 files modified, what approach can I take when a to trigger a job when a file is modified using python? I was thinking using modified date and name and store it into a table. But not sure if that is efficient. Any thoughts?

[ignaciogargiulo]

Hey.. when I get the time_last_modified property, I don't get the value that is under the column "Modified" in sharepoint. When a file is copied to a specific folder, the property time_last_modfied stores the date of that movement, instead of keeping the last time the file was modified. Is there a way to get the exact value that we see in sharepoint in the "Modified" column?

[PavanKumar-jcqn]

Nice demo. Helpful information. Can I get modified by property? Thanks

[darshanasawant]

Hey @codingwithlu, indeed a great tutorial !!!!. With respect to this tutorial, I wanted to know, do we have any attribute in the file properties which can render the file-link as well?

[jndesign]

Hey Lu, Thank a lot for these tutorials. I have learned a lot! I have downloads and uploads and lists working. I was wondering if you could go over the "moveto" option. It looks like it is pretty straight forward but I am having (newb) trouble. Moving a file within sharepoint instead of downloading and uploading would save some over downloading/deleting then uploading.

[koys]

Hi Lu - Hope your well - Could you possible explore to see if its possible to get hold of the names of the users that have accessed files within a Document Library?

I know in SharePoint if you enable SharePoint Viewer, when hovering over a file it shows the names of the people who have viewed the file along with time etc.. I need this data to be extracted from a sharepoint site into a dataframe for further analysis.

[cscegev]

is there any way to get the name of the person who last modified it?

[ionutsavin]

Hi Lu,
I really appreciate your videos, i had chance to follow from part1 all the videos related to SharePoint using Office365 API.
I have a question if you can give me a hint
about the file properties how can be taken the AuthorName (the one who did the last modification) and also the comments when that file was checked out and then checked in?
I can give you a screenshot for more details.
Thank you in advance

[lorenzocapitani]

Hi! Thanks for your videos; is there a way using the Office365 Rest package to modifiy exisiting sharepoint field properties? Thanks again!

[carlosandresgomezdaza]

Hi Lu, there is a way to modify column values of a library? I cant get the specific columns, im getting metadata from the file when i read the files in the library

[tucos]

hey lu, is there a method to get the creator of a file/folder?

[random_stuff_]

Hi Lu, I thank you for explaining clearly. In my sharepoint site I a folder from where I need to download files have other column names like translation, country, Doc Type, Doc format and many more approx 35 columns. From those I need some of the columns to be extracted for other functionality how can I access them can you help me on this.

[thaleslessacosta]

Hi Lu ! First of all thank you for the greate content !
I've been facing an error when using your code for sharepoint, more specificaly on "_get_files_list" function, because of the number of files in my folder (5000+), with surpasses the sharepoint limit.
I already used your code on a folder with less than 5000 files, and it worked like a charm.
Do you know how to get around it, without having to divide my files into many folders ?
I just want to get the filenames of all files in the folder.

[eerxbpb]

Can we extract the last accessed or viewed date of file ?

[TerminallyConfused]

Hi,

Great series.

I am trying to get the (author) principle name of some docs and have modified your code as follows. But the author and modified by are always coming up as "None". any idea why?

Thanks

def get_file_properties_from_folder_for_netdocs_import(self, folder_name):
files_list =
properties_list = []
for file in files_list:
file_dict = {
'file_name': file.name,
'author' : file.author.login_name,
'time_created': file.time_created,
'major_version': file.major_version,
'minor_version': file.minor_version,
'file_size': file.length,
'modifiedby' : file.modified_by.login_name,
'time_last_modified': file.time_last_modified
}





file_dict = {}
return properties_list