Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to use a single REST Connection with several Data Endpoint?

Good evening,

I don't know if it's a bug or I'm doing something wrong.

When I'm setting the URL parameter in a WITH CONNECTION no Data is returned, except the Key

i.e. working:

RestConnectorMasterTable:

SQL SELECT

id,

name,

creationDate

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

       QUERY "authorization" "Bearer",

       QUERY "access_token" "$(vTOKEN)"

    );

i.e. not working

RestConnectorMasterTable:

SQL SELECT

id,

name,

creationDate

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

    URL "https://staging.exampleurl.de/v1/organizations/589b07b21d4530f2987cfd70",

       QUERY "authorization" "Bearer",

       QUERY "access_token" "$(vTOKEN)"

    );

Can you give me some suggestions about what i'm doing wrong?

Thx a lot and greeting.

Wolf

2 Replies
Not applicable

Re: How to use a single REST Connection with several Data Endpoint?

also other approaches to retrieve data from several REST endpoint from one server will be appreciated

Not applicable

Re: How to use a single REST Connection with several Data Endpoint?

Hi there,

solved. It seem that, not like written in the Documentation, the REST Connector resets complety (not overwriting just the parameter) after setting the new URL. So it was necessary to set all other Query Parameters again to get it working.

RestConnectorMasterTable:

SQL SELECT

id,

name,

creationDate

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION (

    URL "https://staging.exampleurl.de/v1/organizations/589b07b21d4530f2987cfd70",

       QUERY "authorization" "Bearer",

       QUERY "access_token" "$(vTOKEN)"

     QUERY "other" "oldValue"

    );