QVSource Sharepoint 365 connectivity

[joaobastos86]

Hello everyone,

In my solution there is a new requirement to connect to SharePoint 365. We were connecting to a previous version of the SharePoint and now was updated to 365 version.

In my local computer I changed the url and it's working fine (https://<url site>/_vti_bin/owssvr.dll?CMD=Display&XMLDATA=1&List=<GUID>) but it seems that in the QMC this doesn't work. In order to overcome it I create a connection with QVSource.

And with QVSource I can get the EXCEL files that I need.

But for the Lists I did the following query:

http://<QVSource Connection>?table=ListItemsFromID&subSite=sites%2fCompass&listId=<GUID>

With this query I'm getting different fields from the query without the QVSource. The fields that I need are: ows_LinkFilename, ows_Modified and  ows_Editor. Anyone knows how I can get these fields with QVSource?

In addiction I cannot query groups. Anyone knows how I can get the list of users within a SP Group?

Thanks in advance