topic How it's possible to read a sharepoint list in Connectivity & Data Prep

How it's possible to read a sharepoint list

sigrid1 — Fri, 15 Nov 2024 20:55:23 GMT

Hi,

I'm trying to make a connection to read a sharepoint list. I create the connection with "office 365 sharepoint".

How it's possible to open the AllItems.aspx file (this contains the sharepoint list).

I was just able to read a excel from sharepoint.

Thanks in advance

Sigrid

Re: How it's possible to read a sharepoint list

SushilKumar — Tue, 09 Jul 2024 09:23:18 GMT

hello @sigrid1

Seems you posted it in the Wrong Queue. as this is related to QDI (Qlik data integration)

Request you to provide info which Qlik product you are using and having issue with.

Regards,

Sushil Kumar

Re: How it's possible to read a sharepoint list

gp_oconnor — Tue, 09 Jul 2024 09:43:14 GMT

Hi @sigrid1

If you are trying to read the contents of a Sharepoint list to include in a Qlik Sense app data model, you need to use the "Office 365 Sharepoint Metadata" connector and not the "Office 365 Sharepoint" connector.

Re: How it's possible to read a sharepoint list

sigrid1 — Tue, 09 Jul 2024 09:59:55 GMT

Hi,

I've tried to use this, but then I get an error on the Authenticate.

As base URL i use the URL in sharepoint:

https://xxx.sharepoint.com/sites/np_pr_00092/Lists/Auftragskommentar/AllItems.aspx

There was a problem authenticating with the connector, further information is listed below:

error = invalid_resource
error_description = AADSTS500011: The resource principal named https://xxx.sharepoint.com/sites/np_pr_00092/Lists/Auftragskommentar/AllItems.aspx was not found in the tenant named nordpan.com. This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant. You might have sent your authentication request to the wrong tenant. Trace ID: b1e57414-53a4-4b3d-ab42-e986dd370f00 Correlation ID: ea447c0e-934e-49fd-b584-04228f9e2ec6 Timestamp: 2024-07-09 09:57:03Z
error_uri = https://login.microsoftonline.com/error?code=500011

Re: How it's possible to read a sharepoint list

gp_oconnor — Tue, 09 Jul 2024 10:31:03 GMT

Hope attached helps.

Re: How it's possible to read a sharepoint list

sigrid1 — Tue, 09 Jul 2024 10:50:21 GMT

Thanks a lot .

it's working now 🙂