How it's possible to read a sharepoint list

[sigrid1]

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

[SushilKumar]

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

[gp_oconnor]

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.

[sigrid1]

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

[gp_oconnor · Accepted solution]

Hope attached helps.

[sigrid1]

Thanks a lot .

it's working now 🙂