Im trying to read the SharePoin online excel spreadsheet data via Qlikview web files wizard we are getting 403 forbidden error

[venkatasuresh]

Im trying to read the SharePoint online excel spreadsheet data via Qlikview web files wizard we are getting "403 forbidden error"

Can you any one help me how can i extract the SharePoint online data to qlikview?

Thanks in advance,

Suresh.VV

[vardhancse]

Hi Suresh,

every share point excel file will be save in one common share drive, try to get the drive path.

In QV you can use the path instead of URL.

[vardhancse]

In share point

Library-> Open with Explorer

You will get the share drive path, there all your sharepoint files will besaved

[venkatasuresh]

Thank you Sasi

the bellow im copied my share point office 365 online spread sheet Url (the bellow link im trying to hit via web files)

Example Url:

https://collaboration.sharepoint.com/sites/S45/AB1/_layouts/15/guestaccess.aspx?guestaccesstoken=IlJ...

can you please help me how to read online share point excel spread sheet data?

is there any other ways to extract ?

Thanks,

Suresh.VV

[vardhancse]

Hi Suresh,

If you want to load the share point online spreadsheet data.

Try to export the share point data to MS ACCESS DB with live connection, so that where ever there is new/edit of record in share point that will be automatically reflected into MS access.

So now try to load data from MS access to QV

[avinashelite]

Select the file type as xls or xlsx and try

[venkatasuresh]

Hi Vardhan,

Thank you

If possible can you give me the steps to implement,

You any document related to this if you have con you share me please.

Thanks,

Suresh.

[venkatasuresh]

Hi Avinash,

i have tried those all types bit its not work out, if i am going to choose xls are .xlsx format im getting bad zip file

Thanks,

Suresh.VV

[buzzy996]

you can follow any one the below link approach.

Reading Data from Sharepoint lists into QlikView

we are fetching data by created Access DB as bridge, by the time(when u r creating first time the source file "Select a folder and choose the option "Link to Data on the Sharepoint Site".")

HTH

[venkatasuresh]

Thank you Shiva,

i will try to implement

Thanks,

Suresh.VV