1 Reply Latest reply: Nov 8, 2017 9:14 AM by Michael Tarallo RSS

    Direct Discovery with Qlik Rest Connector

    omar bensalem

      Hi community  ,( mto )

       

      I'm trying to use direct discovery with qlik rest connector.

       

      This is my script to connecte to my web service:

       

      LIB CONNECT TO 'Post Alert';

       

       

      RestConnectorMasterTable:

      SQL SELECT

      "alertName",

      "dateCreation",

      "dateValidation",

      "utcodeValidator"

      FROM JSON (wrap on) "root" WITH CONNECTION(

      BODY "$(vRequestBody)"

      );

       

      [root]:

      LOAD [alertName] AS [alertName],

      [dateCreation] AS [dateCreation],

      [dateValidation] AS [dateValidation],

      [utcodeValidator] AS [utcodeValidator]

      RESIDENT RestConnectorMasterTable;

       

      DROP TABLE RestConnectorMasterTable;

       

      Here's an example of direct discovery:

      ODBC CONNECT32 TO [Tutorial;DBQ=D:\Database\TUTORIAL_DATA_7200.mdb];

      [DirectDiscovery]:
      DIRECT QUERY
      dimension
      CALL_CTR_ID,
      CUST_CITY_ID
      detail
      COMMENT
      measure
      GROSS_DOLLAR_SALES

      FROM CITY_CTR_SLS;


      Now, the question is, can I implement that, not with an ODBC connection.. but with a REST CONNECTOR like in my case?

      Thanks !