So, fun fact: Most of the "title" attributes for the documents on my Sharepoint site are not only wrong, but also all the same. Consequently, I can't tell which file is which when I "getbytitle()" because apparently the true filename isn't delivered in the output for that.
I haven't found a lot of information on what's available in the API. Is there another call I can make to get actual file names?
Which API? From the "getbytitle()" I'm guessing the REST API.
"Title" is an optional property in SharePoint libraries. It is often populated by default from the metadata in the document, but can be set by the user.
To get a document by filename use the FileLeafRef property:
/sites/yourSite/_api/web/lists/getbytitle('Documents')/Items?$filter=FileLeafRef eq 'AdventureWorksBikes.xlsx'
https://(my_sharepoint_site)/_api/web/lists/getbytitle('Documents')/items?$skiptoken=Paged=TRUE&p_ID=1&$top=1000000 and the XML response does not contain "FileLeafReq" at all. I should see many "xlsx" files, but that string doesn't appear in the XML response either. To be clear, I'm making a somewhat unorthodox call from Python using the "requests" library.