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