topic Re: Extracting sharepoint in QlikView https://community.qlik.com/t5/QlikView/Extracting-sharepoint/m-p/1250672#M868708 <HTML><HEAD></HEAD><BODY><P>Hi Praveen,</P><P></P><P>Your question is quite compact so I might be missing your point. For now I assume you want to get data out of Sharepoint Online. For an on-premise Sharepoint setup I have no answer.</P><P></P><P>To get data (list items) out of Sharepoint Online (part of Office 365) you can use the Microsoft Graph API. It's documented at <A href="https://graph.microsoft.io/en-us/docs/overview/overview" title="https://graph.microsoft.io/en-us/docs/overview/overview">Microsoft Graph - Documentation - Overview</A>. The part you need is in beta currently, see <A href="https://graph.microsoft.io/en-us/docs/api-reference/beta/resources/sharepoint" title="https://graph.microsoft.io/en-us/docs/api-reference/beta/resources/sharepoint">Microsoft Graph - Documentation - SharePoint</A>. I have to note this: it requires moderate to advanced Powershell and developer skills to do this. You'll need to know:</P><OL><LI>How to register an application in Azure AD with the right scope (scope = Sites.Read.All)</LI><LI>How to use OAUTH2 to get an authentication code and then an access token</LI><LI>How to list your sites and lists to get the appropriate listID. The listID used by the Graph API is not the same one as you see in Sharepoint Online...</LI></OL><P></P><P>With regards,</P><P></P><P>Egbert</P></BODY></HTML> Sat, 24 Dec 2016 14:58:44 GMT 2016-12-24T14:58:44Z Extracting sharepoint https://community.qlik.com/t5/QlikView/Extracting-sharepoint/m-p/1250671#M868707 <HTML><HEAD></HEAD><BODY><P>Please let me know..how to extract list data from sharepoint using powershell..i hope that might genius help me ...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Extracting-sharepoint/m-p/1250671#M868707 praveenkumar_s 2020-11-25T16:16:04Z Re: Extracting sharepoint https://community.qlik.com/t5/QlikView/Extracting-sharepoint/m-p/1250672#M868708 <HTML><HEAD></HEAD><BODY><P>Hi Praveen,</P><P></P><P>Your question is quite compact so I might be missing your point. For now I assume you want to get data out of Sharepoint Online. For an on-premise Sharepoint setup I have no answer.</P><P></P><P>To get data (list items) out of Sharepoint Online (part of Office 365) you can use the Microsoft Graph API. It's documented at <A href="https://graph.microsoft.io/en-us/docs/overview/overview" title="https://graph.microsoft.io/en-us/docs/overview/overview">Microsoft Graph - Documentation - Overview</A>. The part you need is in beta currently, see <A href="https://graph.microsoft.io/en-us/docs/api-reference/beta/resources/sharepoint" title="https://graph.microsoft.io/en-us/docs/api-reference/beta/resources/sharepoint">Microsoft Graph - Documentation - SharePoint</A>. I have to note this: it requires moderate to advanced Powershell and developer skills to do this. You'll need to know:</P><OL><LI>How to register an application in Azure AD with the right scope (scope = Sites.Read.All)</LI><LI>How to use OAUTH2 to get an authentication code and then an access token</LI><LI>How to list your sites and lists to get the appropriate listID. The listID used by the Graph API is not the same one as you see in Sharepoint Online...</LI></OL><P></P><P>With regards,</P><P></P><P>Egbert</P></BODY></HTML> Sat, 24 Dec 2016 14:58:44 GMT https://community.qlik.com/t5/QlikView/Extracting-sharepoint/m-p/1250672#M868708 2016-12-24T14:58:44Z