Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

How to fetch data from sharepoint into QlikSense

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

 

1 Solution

Accepted Solutions
asinha1991
Contributor III

Re: How to fetch data from sharepoint into QlikSense

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.

3 Replies
asinha1991
Contributor III

Re: How to fetch data from sharepoint into QlikSense

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

Partner
Partner

Re: How to fetch data from sharepoint into QlikSense

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
Contributor III

Re: How to fetch data from sharepoint into QlikSense

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.