Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies