Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
eri
Contributor III
Contributor III

Qliksense connector to Sharepoint

Hi,

I have built a form in SharePoint but I want to connect it to Qlik sense so that every time I add data into the form it gets saved into the SharePoint which has my data excel.
Does anyone have an idea how can I do this without buying any additional paid software?

Looking forward to hear from you.

Thanks!1

Labels (1)
1 Reply
andoryuu
Creator III
Creator III

Are you asking how to load data from SharePoint into Qlik Sense without buying additional software?  If so you can use the Sharepoint REST API to call your list and get the data back.  We've done this successfully with multiple SharePoint lists here.  The only bummer is that it returns one table for every field in your list.  With some cleanup, you can join the 1-to-1 fields to the main "properties" table returned by the REST API. 

 

You mention excel - if you need to reference files their locations in SharePoint are provided to you in the data returned by the REST API so you can load them with the web locations provided in the data return.  

 

If you need is different from this could you please clarify?