SharePoint Metadata connector Issue

[sajkhan]

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.

[diegozecchini]

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.