Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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