redirection workaround

levente81 — Thu, 07 Sep 2023 14:01:55 GMT

Hi,

Qlik does not allow redirection in a simple way. I wonder if anybody can help me with such issue that the result of an API call is a redirection link, that I would like to use somehow to get access to the actual data I need.

The redirection link has the below structure:

temp_url = https:// ... .json

?X-Amz-Algorithm= ...

&X-Amz-Credential= ...

&X-Amz-Date= ...

&X-Amz-Expires= ...

&X-Amz-Security-Token= ...

&X-Amz-Signature= ...

&X-Amz-SignedHeaders= ...

&x-id=GetObject

Can I refer to these values using a WITH CONNECTION clause, and get finally what I aimed to fetch?

Thanks and best regards,

Levente

Re: redirection workaround

williejacobs — Tue, 19 Sep 2023 08:08:45 GMT

Hi @levente81,

I have had great success with using the 'With Connection' in my Rest API calls.
Extracting Tokens and redirect URLs and then passing them into the call with $ expansion.

Short sample of how I use this:
The 2 variables 'vOrgId' and 'vAccessToken' are extracted from other calls and then passed into this call.

FROM JSON (wrap on) "root" QDL

WITH CONNECTION

(

URL "https://API Endpoint/org/$(vOrgId)",

HTTPHEADER "Authorization" "Bearer $(vAccessToken)"

);

topic redirection workaround in Connectivity & Data Prep

redirection workaround

Re: redirection workaround