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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?