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 ??
