2 Replies Latest reply: Oct 19, 2017 2:17 AM by Elene Gelitashvili RSS

    Rest Connector

    Elene Gelitashvili

      Hello everyone,

      i use Rest Connector to get some data,

      is it possible to get data with " * " instead wrire down those fields ("storedId", "city","region",  "__FK_stores")

       

       

      SQL SELECT

            "__KEY_root",

           (SELECT "storedId",

                     "city",

                     "region",    

                      "__FK_stores"

            FROM "stores" FK "__FK_stores")

      FROM JSON (wrap on) "root" PK "__KEY_root";

      [stores]:

      LOAD

            [storedId] AS [storeId],

            [city] AS [city],

            [__FK_stores] AS [__KEY_root]

      RESIDENT RestConnectorMasterTable

      WHERE NOT IsNull([__FK_stores]);