Forum Discussion
Connecting to SharePoint Folder error
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
Hi,
I had something similar.
I was getting the information through, but then at every refresh I would get the notification of an error. Then the error table was empty.
Inspired by your solution, I simply changed the ApiVersion from 15 to 14, using the "Advanced Editor" and it now works without error.
It might be some bug in the API, not sure how to flag it, since there is no error code, only the fact that an error occurred.