topic Error 401 when trying Office365 to Qliksense connectivity Using Rest connector in Connectivity & Data Prep

Error 401 when trying Office365 to Qliksense connectivity Using Rest connector

manojciti — Fri, 20 May 2022 11:26:03 GMT

HI All,

I'm trying to pull data in list on office 365 using Rest connector and selecting authentication as Windows NTLM and putting my credentials and its throwing error as

HTTP Protocol error 401 (unauthorized) : Requested resource required authentication

I tried looking in community but not getting solution and I don't want to use Connector

Appreciate response.

Thanks

Re: Error 401 when trying Office365 to Qliksense connectivity Using Rest connector

Luis_Arocho-LLantin — Tue, 24 May 2022 14:01:47 GMT

Are you trying to use the office365 connector?

Thanks,

Luis

Re: Error 401 when trying Office365 to Qliksense connectivity Using Rest connector

manojciti — Tue, 24 May 2022 14:07:03 GMT

Nope , I'm trying using Rest connector . I don't want to use Office 365 connector and try using normal rest connection process we follow for SharePoint connection

Re: Error 401 when trying Office365 to Qliksense connectivity Using Rest connector

Jay_Brown — Thu, 26 May 2022 20:50:49 GMT

@manojciti , The APIs that are used in SharePoint 365 may not have the ease of use and best practice is to use Qlik Web Connectors as mentioned above.

Is there some reason why you would like to use REST instead of the connector?

In general, if you have issues connecting with REST the first steps towards troubleshooting will be trying to verify this is working outside of Qlik Products in another REST client such as Postman, ARC, PowerShell, etc, and then trying to use those parameters within Qlik.