OData Connector v1

[joaopaulo_delco]

Hi guys!

I'm having a problem trying to make an OData connection through Qlik Web Connectors.

I did the configuration to view the tables but the return is always.

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

I've tried using all available settings but it's not working.

I did the same configuration in Power BI and it worked perfectly.

See the attached print:

[Frank_S]

Hi

Check the format of your username

try

• user@domain.com
• user
• domain/user

Also, double check that the user you are using has access to the tables that you are trying to query. 

Kind regards...

[joaopaulo_delco]

I verify that domais is only used to NTLM autentication.

[Frank_S · Accepted solution]

The error "Failed on attempt 1 to GET. (The remote server returned an error: (401) Unauthorized.)" indicates then that your source data provider does not give access to the user account you are attempting to use. 

Check the following to ensure that the provider you are connecting are exposing their data using the OData protocol as needed

• https://www.odata.org/ecosystem/
• https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

Ways to access your data

You can access websites that expose their data using the OData protocol. For more information, see Ecosystem: Producers.

You need to obtain the OData V4 service URL for the dataset that you want to connect to, in order to authenticate the connector. To learn more about the OData V4 service URL, see OData documentation.

If it is determined that there are no issues with odata access using your account and you are following the requirements set out in our documentation, then I suggest starting a support ticket.

Kind regards...