topic Re: Qlik OData Connector Failed to CanAuthenticate in Connectivity & Data Prep

Qlik OData Connector Failed to CanAuthenticate

roninags — Thu, 23 Dec 2021 18:57:31 GMT

We have issues connecting Qlik OData Connector to our OData Service. It returned an error "Failed on attempt 1 to GET. (The remote server returned an error: (403) Forbidden.)". See attached image.

Re: Qlik OData Connector Failed to CanAuthenticate

chrisbrain — Wed, 09 Sep 2020 06:23:37 GMT

Hi - What authentication method are you using in the connector?

And can you confirm that the OData source supports this?

Re: Qlik OData Connector Failed to CanAuthenticate

roninags — Wed, 09 Sep 2020 14:04:58 GMT

Hi! I'm using Basic authentication type.

Re: Qlik OData Connector Failed to CanAuthenticate

chrisbrain — Wed, 09 Sep 2020 14:23:41 GMT

OK - And you can confirm the OData source supports this? Do you have an docs for the OData end point?

Re: Qlik OData Connector Failed to CanAuthenticate

roninags — Thu, 10 Sep 2020 16:31:43 GMT

I'm using Basic authentication method, we try to connect to OData Service via CLI and retrieve data without problem. We even try Power BI to connect to OData Service without issue. Please see images of Power BI connected to OData Service compare to Qlik Odata Connector.Qlik OData Connector AuthenticationPower BI AuthenticationPower BI Connection to OData Service

Re: Qlik OData Connector Failed to CanAuthenticate

chrisbrain — Thu, 10 Sep 2020 16:57:46 GMT

The accept header looks odd with the preceding $ and actually this OData connector doesn't currently support JSON.

Could you tell me if you get any different behaviour if you:
- leave the accept header blank.
- set it to: application/xml
- set it to: application/atom+xml

?

Re: Qlik OData Connector Failed to CanAuthenticate

roninags — Sat, 12 Sep 2020 00:50:36 GMT

Leaving accept header blank gives me an error message

"Failed on attempt 1 to GET. (The remote server returned an error: (403) Forbidden.)"

Changing accept header to application/xml and application/atom+xml gives me an error message

"Failed on attempt 1 to GET. (The remote server returned an error: (406) Not Acceptable.)"

Re: Qlik OData Connector Failed to CanAuthenticate

chrisbrain — Mon, 14 Sep 2020 06:57:31 GMT

Can you confirm whether this OData source supports XML as a format? My current suspicion is that it's JSON only in which case the connector will not currently work.

Re: Qlik OData Connector Failed to CanAuthenticate

roninags — Sat, 19 Sep 2020 03:41:41 GMT

Is there a chance that JSON format can work with Qlik OData Connector.