REST Connection - Dynamic RestConnectorMasterTable

prees959 — Thu, 24 May 2018 15:44:25 GMT

Hi,

I have run into a brick wall when looping through an API to retrieve results.

This is the generated script for the RestConnectorMasterTable :

RestConnectorMasterTable

RestConnectorMasterTable:

SQL SELECT

"__KEY_root",

(SELECT

"$(vID)",

"__FK_Results"

FROM "Results" FK "__FK_Results"),

(SELECT

"__KEY_Trial",

"__FK_Trial",

(SELECT

"103946",

"103960",

"27064",

"700039",

"18793",

"__FK_$(vID)"

FROM "$(vID)" FK "__FK_$(vID)")

FROM "Trial" PK "__KEY_Trial" FK "__FK_Trial")

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

Im succesfully passing vID to the API which is the Key ID field - but my problem is

"103946",

"103960",

"27064",

"700039",

"18793",

these value will change with each loop through the API. Is there a dynamic way of fixing this by using Field1, Field2 etc??? which I can store in variables ??

Many thanks,

Phil

Re: REST Connection - Dynamic RestConnectorMasterTable

njhunjhun — Fri, 27 Dec 2019 06:51:02 GMT

Hi!

Did you find a solution to it. I am facing the same issue

Thanks

Re: REST Connection - Dynamic RestConnectorMasterTable

beam — Thu, 01 Oct 2020 04:10:52 GMT

I would love someone to answer this because honestly it feels like an issue with QLIK.

topic REST Connection - Dynamic RestConnectorMasterTable in QlikView

REST Connection - Dynamic RestConnectorMasterTable

Re: REST Connection - Dynamic RestConnectorMasterTable

Re: REST Connection - Dynamic RestConnectorMasterTable