Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dhananjay_capge
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

 

Labels (1)
1 Solution

Accepted Solutions
asinha1991
Creator III
Creator III

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.

View solution in original post

6 Replies
asinha1991
Creator III
Creator III

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
Partner
Partner
Author

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

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.

View solution in original post

xy-siang
Partner
Partner

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

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
Creator II
Creator II

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...