How to fetch data from sharepoint into QlikSense

[dhananjay_capge]

Hello,

How do we fetch the data from sharpoint to Qliksense.

Qliksense Version : Feb 2019.

Sharepoint Version: SharePoint Server 2013 Enterprise SharePoint Server 2013.

Regards,

Dhananjay J

[asinha1991]

what kind of data you want to fetch? if it is sharepoint list then you can use sharepoint connector(its licensed), for text delimited files(including csv) and also for list you can use sharepoint REST connector..This is the end point

http://site url/_api/web/GetFileByServerRelativeUrl('/Folder Name/file name')/$value

you need to call oauth (another REST end point) , take token and then pass it to above rest call.

Qliksense rest connector supports only text files, csv, json and xml as of now...for others you cannot do directly in Qliksense ( you can use the above mentioned end point In some other programming language and store file somewhere though)

I can share more details on REST if you want

[dhananjay_capge]

Thanks for Quick reply.

But there is one excel file at given sharepoint location. we need to fetch monthly data from that excel each month.

is that ok with rest connectors?

Regards,

DHananjay J

[asinha1991 · Accepted solution]

No, QLiksense Rest connector doesn't understand .xlsx or .xls response as of now...if it is possible you can ask people to save excel as CSV (can be done through excel) before upload. then you can read in qliksense.

if you cant change file type, you can use sharepoint rest api to fetch excel via some other programming language( for example python) and store excel somewhere accessible to Qliksense.

[xy-siang]

Hi Asinha1991, 

I am finding a way to create a library connection in qliksense that can retrieve data from CSV files in the sharepoint. 

Hence, would you mind sharing more details on REST to  create a library connection in qliksense that can retrieve data from CSV files in the sharepoint?

Thanks and Regards, 

XY Siang

[Shivesh_Yadav]

Hi, I have tried to access data from sharepoint in an XML format using the _api. But I can only access 15000 at one point. Is there any way to increase this limit or can you please suggest any other solution for this.

[Ken_T]

instead of REST, you should use Qlik Office 365 Sharepoint Connector.

this will allow you to directly use the excel file in your qlik app, an excel file that is hosted on sharepoint.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...