Data from multiple pdf files on sharepoint

[Giulianna]

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)

[lbendlin]

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

[Giulianna]

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

[lbendlin]

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

[lbendlin]

when asked to specify the Site URL you should only use

https://sidel.sharepoint.com/sites/SPMNAMContinuousImprovement

[Giulianna]

When I use this URL 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. Do you know any  way around it?

[lbendlin]

No. This is the correct way to do it. You only need a single helper query and you can craft that one yourself.  No need to use the default option offered via the "Combine binaries"  button.

[Giulianna]

Can you help me crafting it? I am not sure how to create one myself that will convert the binary data to table

[lbendlin]

would you be able to post two sample PDF files and indicate what you want to extract from it?