Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Qlik REST Connector reply error ***

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