Qlik OData Connector Failed to CanAuthenticate

[roninags]

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.

[chrisbrain]

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

And can you confirm that the OData source supports this?

[roninags]

Hi! I'm using Basic authentication type.

[chrisbrain]

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

[roninags]

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

[chrisbrain]

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

?

[roninags]

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.)"

[chrisbrain]

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.

[roninags]

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