Forum Discussion

Giulianna's avatar
Giulianna
Helper I
1 year ago

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

  • SharePoint.Files requires the Site URL, not the "current directory" .  You need to do the folder navigation in a subsequent step.

    • Giulianna's avatar
      Giulianna
      Helper I

      Even when I use the site url it does not work either.

      • lbendlin's avatar
        lbendlin
        Super User

        Please elaborate what "does not work" means. Do you get an error message?