topic Re: How to connect to API through the script in Connectivity & Data Prep

How to connect to API through the script

gal_polak — Thu, 23 Dec 2021 13:34:31 GMT

Hi all,

I have an API that i need to connect to, and i know i can use the REST connector.

but i need more flexibility for example:

i need to connect to the following api: https://api.game.com/usergroups?apikey='asdasdjlkascass2'

but need to change the apikey that is being sent dynamically

change the header that is being sent,

how can i do that?

i thought that maybe i will have some kind of an option from the script editor to write something like this:

CUSTOM CONNECT "http://api.game.com/usergroup?apikey=$(KEY)"

Re: How to connect to API through the script

Stoyan_Terziev — Wed, 13 Nov 2019 15:39:36 GMT

Hi Gal,

Basically the question is if you need to authenticate or not. If not - you can connect to as if you are loading internet file.

That's straight-forward with QV and quite tricky but still naively possible in QS.

If you can drop the URL in the browser and that fetches the information you need (basically scraping it), you can write the code with a bit of help.

But if you need to parse headers with token for authentication you need to check the Qlik REST connector.

I hope that helps!

Kind regards,

S.T.

Re: How to connect to API through the script

gal_polak — Wed, 13 Nov 2019 15:48:32 GMT

My problem is that i need to authenticate,

i have multipal URL (apis) each one of theme have different api key,

so i need some kind of a way to change the path when i use the "CONNECT"

Re: How to connect to API through the script

Stoyan_Terziev — Wed, 13 Nov 2019 15:51:54 GMT

Hi Gal,

We didn't clarify if this is Qlik View or Qlik Sense?

I think once you generate your "CONNECT" or LIB: statement, you can use variables to modify certain paths in it.

Still if you need to authenticate, I don't think you can bypass using REST connector. Do you have it installed?

Kind regards,
S.T.

Re: How to connect to API through the script

gal_polak — Wed, 13 Nov 2019 15:57:35 GMT

Sorry,
It's Qlik Sense
and yes i have it stored.

and i created the connector,
so as i said, another option is i can change the header of the connector dynamically,
is it possible? can you write a short example maybe?

Re: How to connect to API through the script

Stoyan_Terziev — Wed, 13 Nov 2019 16:24:34 GMT

Hi Gal,

Using the same connection and dynamically changing the header is not possible with native QS functionality to my knowledge.

I don't have a reliable test connection to play with so I can't be sure this success is legitimate (actually I'm quite sure it is not):

But for the sake of science, you can give it a shot and let's check what is happening.

The request field says:
$(=vTest)

Kind regards,

S.T.

Re: How to connect to API through the script

gal_polak — Thu, 14 Nov 2019 15:19:22 GMT

This is very creative and i like it 🙂

unfortunately it is not working.

but i found a way to change the headers:

and it will be good enough for now.

thx for all your help!