Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm fairly new to qlik and I'm trying to load multiple tables through one single rest connector like this:
LIB CONNECT TO 'RESTcon'; Let CompanyId = 323; Let BaseURL = 'http://localhost:53823/api/gettable'; Set Tables = 'CreditorClient', 'CreditorOrderClient'; for Each table in $(Tables) RestConnectorMasterTable: SQL SELECT "__KEY_object", (SELECT (SELECT * FROM "item") FROM "$(table)") FROM XML "object" PK "__KEY_object" WITH CONNECTION(Url "$(BaseURL)/$(CompanyId)/$(table)"); [$(table)]: LOAD * RESIDENT RestConnectorMasterTable; DROP TABLE RestConnectorMasterTable; Next;
LIB CONNECT TO 'RESTcon';
Let CompanyId = 323;
Let BaseURL = 'http://localhost:53823/api/gettable';
Set Tables = 'CreditorClient', 'CreditorOrderClient';
for Each table in $(Tables)
RestConnectorMasterTable:
SQL SELECT "__KEY_object",
(SELECT
(SELECT *
FROM "item")
FROM "$(table)")
FROM XML "object" PK "__KEY_object"
WITH CONNECTION(Url "$(BaseURL)/$(CompanyId)/$(table)");
[$(table)]:
LOAD *
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
Next;
This gives me ScriptErrorDetails: Connector reply error:***
BUT if i specify atleast one field instead of * in the SELECT .. FROM "item" everything works like a charm.
Since I'm looping through multiple tables with 99% of the fields being different I would really need to use * instead of field names.
Any ideas why this doesn't work?
Thanks in advance
Christer