topic Re: SharePoint Metadata connector Issue in Connectivity & Data Prep

SharePoint Metadata connector Issue

sajkhan — Tue, 24 Dec 2024 16:27:56 GMT

Hello All,

I'm trying to get all the files metadata from SharePoint folder but getting below error:

Invalid argument. (Connector error: No rows returned.)

LOAD
*
;
SELECT FileLeafRef, Created
FROM ListFiles
WITH PROPERTIES (
subSite='sites/A195',
folder='sites/A195/DELSYSAS_DATA/Shared Documents/USER_CONTRIBUTE/MWWWT/SIGNOFF/',
maxResults='100'
);

Please let me know what could be the issue, the user account has access to this path and there are files available in this path.

Re: SharePoint Metadata connector Issue

diegozecchini — Fri, 03 Jan 2025 12:46:51 GMT

Hi! This error often indicates a problem with how the Qlik SharePoint connector is configured or with how the query is being interpreted.

Did you verify the user account being used for the connection has sufficient permissions to access?

The SharePoint site (sites/A195)
The folder (DELSYSAS_DATA/Shared Documents/USER_CONTRIBUTE/MWWWT/SIGNOFF)

Test the user access manually in SharePoint to confirm the files are visible.

The folder path in the WITH PROPERTIES clause should be relative to the site collection root and match SharePoint's folder hierarchy.

folder='Shared Documents/USER_CONTRIBUTE/MWWWT/SIGNOFF/'
You might not need the full path if the subSite property is correctly pointing to sites/A195.

Finally, you can also test the connection separately to ensure the connector is working. For example, try retrieving metadata from a different folder or site.
Confirm that the ListFiles function supports the exact parameters and file structure you're querying.

Re: SharePoint Metadata connector Issue

sajkhan — Tue, 07 Jan 2025 11:34:20 GMT

Hello @diegozecchini ,

Thanks for the response.

User has sufficient access to to the specific folder. 'DELSYS_DATA' and it is a sub site within /A195. I tried to list the subsite and its there.

while trying to get the list folder from the subsite server relative url getting below error.

Don't know what am I doing wrong here :(.

Let me know if any suggestion.

Re: SharePoint Metadata connector Issue

diegozecchini — Wed, 08 Jan 2025 08:02:51 GMT

Hi!
It is very annoing situation, why don't you try to log in to SharePoint using the same account as the connector and manually navigate to:

/sites/A195/DELSYSAS_DATA/Shared Documents/USER_CONTRIBUTE/MWWWT/SIGNOFF/

Confirm that you can view the folder and its contents. Double-check permissions on the site, subsite, and folder: see if the user has at least "Read" or "Contribute" access.
Confirm that in folder permission inheritance or explicit permissions are set for the user.

From Qlik try also retrieving metadata from another folder in the same site or subsite to ensure the connector works as expected. For instance:

folder='Shared Documents/'
If this works, the issue might be specific to the target folder's path or permissions.

Re: SharePoint Metadata connector Issue

sajkhan — Fri, 10 Jan 2025 17:36:45 GMT

I resolved the issue thanks 🙂