0 Replies Latest reply: Mar 7, 2017 7:36 AM by Christer Sagvaag RSS

    Qlik REST Connector reply error ***

    Christer Sagvaag

      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