Qlik Sense Restconnector/ JSON Drops Lead Zero

heusdenc — Wed, 23 Oct 2019 12:45:00 GMT

Hello all,

I hope someone can help me with the following:

I have an issue with a Restconnector which random drops a lead zero!

In the preview of the data load selection is shows the “Id” correctly e.g. “000008” but the end result in Qlik sense is “00008”.

Load statement I use:

LIB CONNECT TO 'Ultimo_Article (mosa_cheus1)';

RestConnectorMasterTable:

SQL SELECT

"__KEY_root",

(SELECT

"Id",

"Description",

"__FK_items"

FROM "items" FK "__FK_items")

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

[items]:

LOAD [Id],

[Description]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_items]);

DROP TABLE RestConnectorMasterTable;

After Load the end result is the just one lead zero missing!

Has anybody experience with this issue?

Thanks for the Help!

Ceriel

topic Qlik Sense Restconnector/ JSON Drops Lead Zero in App Development