topic Rest Connector in Connectivity & Data Prep

Rest Connector

Anonymous — Fri, 02 Apr 2021 08:05:27 GMT

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

felipedl — Wed, 18 Oct 2017 16:18:53 GMT

Hi Elene,

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

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

Felipe.

Anonymous — Thu, 19 Oct 2017 06:17:03 GMT

Thank you!

ratnadeep9433 — Mon, 13 Dec 2021 09:23:31 GMT

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