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.