Forum Discussion
Data from multiple pdf files on sharepoint
l am trying to create a tool that extracts information from multiple pdf files from a folder on Sharepoint using
Source = SharePoint.Files(CurrentDirectory),
where my CurrentDirectory is the sharepoint website with the path to the subfolder I want to get my date from, however it shows me this error below:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request)
Details:
DataSourceKind=SharePoint
DataSourcePath=
SPRequestGuid=8fa061a1-d04d-a000-6acb-9cf255b6c7a4
Url=Documents/Labor Calculation Tool/_vti_bin/ListData.svc
------------------------------------------------------------
When I try to use Source = SharePoint.Contents(CurrentDirectory) instead with CurrentDirectory being the main folder, not subfolders, I have to use Helper Queries to be able to transform my binary data into table, which I dont want to because I would need to create too many helper queries which makes my tool extramely heavy and slow.
Can anyone help me fix the error using either Source = SharePoint.Contents(CurrentDirectory) or Source = SharePoint.Files(CurrentDirectory)
9 Replies
- lbendlinSuper User
SharePoint.Files requires the Site URL, not the "current directory" . You need to do the folder navigation in a subsequent step.