topic OData Connector v1 in App Development

OData Connector v1

joaopaulo_delco — Thu, 13 Oct 2022 13:03:33 GMT

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:

Re: OData Connector v1

Frank_S — Thu, 13 Oct 2022 23:03:01 GMT

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

Re: OData Connector v1

joaopaulo_delco — Wed, 19 Oct 2022 16:51:45 GMT

I verify that domais is only used to NTLM autentication.

Re: OData Connector v1

Frank_S — Wed, 19 Oct 2022 17:43:53 GMT

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

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