I am trying to get data from a remote SharePoint. By remote, I mean that I do have the security to write an application on the SharePoint server. I have been researching a billion ways to connect and I am having trouble finding one that works.
Anyways, I found this to be the closest so far but requires SQL security that I cannot bypass. This may be useful in the future if I work on a project that gives me that access:
SELECT * FROM OPENROWSET
('Microsoft.ACE.OLEDB.12.0', 'WSS;IMEX=1; DATABASE=http://sharepointserver/optionalsite/;LIST=On Call;VIEW=;RetrieveIds=Yes;', 'SELECT * FROM LIST')
No comments:
Post a Comment