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

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

venkatasuresh — Wed, 25 Nov 2020 16:16:04 GMT

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

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

vardhancse — Thu, 09 Feb 2017 10:06:53 GMT

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.

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

vardhancse — Thu, 09 Feb 2017 10:11:55 GMT

In share point

Library-> Open with Explorer

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

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

venkatasuresh — Thu, 09 Feb 2017 10:19:16 GMT

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/Xfcvs/J1xPVws/+1s8CU/yw=&docid=2_1799f1e2f0653e&rev=1

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

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

vardhancse — Fri, 10 Feb 2017 05:54:29 GMT

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

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

avinashelite — Fri, 10 Feb 2017 05:59:06 GMT

Select the file type as xls or xlsx and try

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

venkatasuresh — Fri, 10 Feb 2017 11:14:14 GMT

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.

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

venkatasuresh — Fri, 10 Feb 2017 11:16:18 GMT

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

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

buzzy996 — Fri, 10 Feb 2017 11:19:50 GMT

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

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

venkatasuresh — Fri, 10 Feb 2017 11:23:13 GMT

Thank you Shiva,

i will try to implement

Thanks,

Suresh.VV

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

avinashelite — Fri, 10 Feb 2017 11:23:29 GMT

check this

Import Excel File from SharePoint to QlikView without writing Job

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

venkatasuresh — Fri, 10 Feb 2017 12:06:51 GMT

Hi Shiva,

we need to extract the SharePoint Online Excel file not a list can you have any idea

Thanks,

Suresh.VV

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

venkatasuresh — Fri, 10 Feb 2017 12:08:32 GMT

Hi Avinash,

I need to read Sharepoint Online Excel

Thanks,

Suresh.VV

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

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:09:39 GMT

Is this Sharepoint looks like Pagination / Attachment? I've done with the Pagination. But, i am not sure what your intend to prove here

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

venkatasuresh — Fri, 10 Feb 2017 12:25:50 GMT

Hi Anil,

Issue:

Qlikview unable to read the SharePoint excel online data

Step1:- We are trying to read the data from the bellow URL

https://collaboration.sharepoint.com/sites/SS245/AB911/_layouts/15/guestaccess.aspx?guestaccesstoken=IlJ/Xfcvs/SmXPVws/+evFXUgR1Fg+CU/yw=&docid=2_19acba8fd0653e&rev=1

Step2:- We are hitting the URL from Qlikview Studio -->opening the web files-->internet file (copy the URL) and click the next button

Step3:- While we hitting the SharePoint online excel we are getting 403 forbidden error message

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

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:37:07 GMT

Q) I need to know does this Excel situated in Sharepoint That's Fine then My question is is that file is like as attachment at URL or simple Pagination like below. Please confirm this so then we can go ahead

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

buzzy996 — Fri, 10 Feb 2017 13:07:45 GMT

ok, do u have the idea wht is the ddifference between Online Excel file and list on sharepoint?

in my view(for extractor into QlikView),we can make the list as online excel by selecting the radio button as said on my previous post can pull it the live data. u can

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

venkatasuresh — Mon, 13 Feb 2017 03:54:36 GMT

Hi Anil,

Thats not a page negation we need to read the data from office 365 online excel. PFA...

Thanks,

Suresh

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

venkatasuresh — Mon, 13 Feb 2017 04:04:23 GMT

Thank you Shiva,

Im bit confused on your replys,

If possible can you give your contact number i will contact you

Thanks,

Suresh. VV

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

vardhancse — Mon, 13 Feb 2017 05:16:13 GMT

https://support.office.com/en-us/article/Synchronize-a-SharePoint-2010-list-with-Access-2010-975bfb97-c799-4fce-b7cc-3db3b397f116