Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?