Qlik REST Connector reply error ***

Tue, 07 Mar 2017 09:25:03 GMT

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

topic Qlik REST Connector reply error *** in App Development

Qlik REST Connector reply error ***