Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rest Connector

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]);


1 Solution

Accepted Solutions
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Elene,

If you change it to *, it will get a parsing error from the connector, something like

sample.png

Its how the connector was implemented, any particularity that you wouldn't want all the fields to be shown?

Felipe.

View solution in original post

3 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Elene,

If you change it to *, it will get a parsing error from the connector, something like

sample.png

Its how the connector was implemented, any particularity that you wouldn't want all the fields to be shown?

Felipe.

Anonymous
Not applicable
Author

Thank you!

ratnadeep9433
Contributor
Contributor

How can I use a variable in rest connection url when using qliksense?