Load incorrect values with REST Connector

[Cam_Ly]

Hi,

I am loading via the REST Connector item data into Qlik Cloud.

Unfortunately, Qlik is displaying incorrect values for some fields. For example, in Postman the JSON response shows UnitCost as "0.289", but in Qlik the same field appears as "289".

After several tests, I noticed that the correct values are shown when I apply a filter to reduce the dataset size. Without filtering, I fetch around 14000 rows.

This issue occurs occasionally: most rows display correctly, but some do not. I have also observed similar behavior with GET calls from other REST APIs.

Here's another example:

• JSON response in Postman: "11.232" as UnitCost
• Screenshot from Qlik: (incorrect value shown)

Note: I am working in Qlik with German punctuation settings, where "11.232" means 11,232 (the point is used as a thousands separator).

Has anyone experienced this before or can provide guidance on how to resolve this issue? Any help would be greatly appreciated!

[Cam_Ly · Accepted solution]

Found the solution:

In the extraction app I have to define the punctuation formatting as follows:

SET ThousandSep=',';
SET DecimalSep='.';

Afterwards I can change it in the transformer/load app (for German localization):

SET ThousandSep='.';
SET DecimalSep=',';

But nether the less I have to use the following function, so it displayed in the app properly.

Load Replace(UnitCost, '.', ',') ...

Solved the issue for me.

[Xiaodi_Shi]

Hello,

Thanks for sharing this great solution with us on Community.
Best regards

Sabrina