Qlik Sense Restconnector/ JSON Drops Lead Zero

[heusdenc]

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