topic Re: Qlik Rest Data connection not working with with api key authentication in Connectivity & Data Prep

Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Sun, 01 Jun 2025 07:40:38 GMT

Hi Team,

We are pulling data from Rest API data source connector. We don't have permission to enter manual service credential. So we are trying to authenticate using API key. But we are below getting error.

I am using basic authentication.

Could you please suggest me how we can authenticate .?

Regards & Thanks,

Irshad Ahmad

Re: Qlik Rest Data connection not working with with api key authentication

rafaelencinas — Sun, 01 Jun 2025 16:56:10 GMT

Hello!

Authentication method is related how to REST will authenticate before request the information. If your API requires only an API KEY , you can just select the Anonymous.

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Mon, 02 Jun 2025 05:24:21 GMT

Hi @rafaelencinas ,

Thank you for suggestion. I will check check this.

Regards,

Irshad Ahmad

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Wed, 04 Jun 2025 09:44:45 GMT

Hi @rafaelencinas ,

I have selected the authentication schema anonymous. Still getting same error.

Regards, & Thanks,

Irshad Ahad

Re: Qlik Rest Data connection not working with with api key authentication

rafaelencinas — Wed, 04 Jun 2025 11:19:02 GMT

HI @jrathgebercs !

Lets review your settings:

In your images, its written : accept - > application/json ( generally , the parameter is Content-Type )

Check in your documentation if the authentication method is GET or POST, if its POST, you have to change the method to POST and create a body

If you provide the documentation its better to help, REST APIs sometimes are too complex to setting up.

Bye!

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Fri, 06 Jun 2025 02:36:11 GMT

Hi @rafaelencinas ,

In the our existing connection we were using get method to fetch the data from API with window NTLM authentication. But after migration server on new domain. We don't have permission to use service account and password manual. That is a reason we are looking alternate way to authenticate using the api key.

As per your suggestion can we use get method to fetch the data from Api?

Regards & Thanks,

Irshad Ahmad

Re: Qlik Rest Data connection not working with with api key authentication

rafaelencinas — Fri, 06 Jun 2025 10:52:22 GMT

HI @jrathgebercs !

I recommend you to try to do what do you want with POSTMAN, to test before setting up Qlik.

You need to know with is the name of query parameter to provide a correct parameter in rest query. Can you send a print screen of your documentation or configuration ?

Bye!

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Fri, 06 Jun 2025 13:56:59 GMT

Hi @rafaelencinas ,

Thank you for help. We are not using postman.

Please find the attached Rest Get method setting which we are using.

Error Screenshot:

Regards & Thanks,

Irshad Ahmad

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Fri, 06 Jun 2025 13:59:10 GMT

PFA

Re: Qlik Rest Data connection not working with with api key authentication

rafaelencinas — Fri, 06 Jun 2025 14:04:52 GMT

OK, according the picture your Authentication Method stil Windows NTLM, but its empty.

1 - You may type domain\user into User Name box and Password and try to connect.

2 - Generally, if you have authentication key , you dont need to provide user and password, but , you have to set to Anonymous

Note:

- If you are using Windows Client Managed, you have to check if the user that Runs Windows Service has the Access to Active Directory to Authenticate.

- If your Domain IP Server its not reached by server , you must check with the infrastructure department to create a route to this new AD Server

Bye!

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Tue, 10 Jun 2025 04:29:17 GMT

HI @rafaelencinas ,

We tried Authentication method anonymous but getting same error.

Regards & Thanks,

Irshad Ahmad

Re: Qlik Rest Data connection not working with with api key authentication

vkramBI4Qlik — Sat, 28 Jun 2025 17:12:35 GMT

HI @jrathgebercs

Did you try changing the "Certificate Validation" to "Skip server certificate validation" ?

Thanks
Vikram

Re: Qlik Rest Data connection not working with with api key authentication

jrathgebercs — Tue, 01 Jul 2025 11:22:54 GMT

Hi @vkramBI4Qlik ,

Yes, We tried but getting same error.

Regards,

Irshad Ahmad