Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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?