PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → How to read this Json in WINDEV/WINDEV MOBILE
How to read this Json in WINDEV/WINDEV MOBILE
Débuté par PETER ZHOU, 12 avr. 2018 11:34 - 3 réponses
Posté le 12 avril 2018 - 11:34
Hi,

{"success": "[{'product': u'BEER (BOTTLE)', 'barcode': '_', 'lot': u'N0007', 'id': 11, 'uom': u'CTN24', 'qty': 1.0}, {'product': u'SOFTDRINK', 'barcode': '_', 'lot': u'N0001', 'id': 12, 'uom': u'BOT', 'qty': 1.0}]"}

What is the equivalent WLanguage to reading this Json file ?

Regards,

PETER ZHOU
Posté le 12 avril 2018 - 13:53
Posté le 13 avril 2018 - 13:23
Quote
Ruben Sanchez Peña

Hi, look at https://help.windev.com/en-US/search2.awp…





Rubén

Hi Ruben,

Actually i should explain more.
I am aware of the functions in windev, but i couldn't get windev/windev mobile to return result without error
for example the following json i have no issue
[{"id": 4, "name": "admin"}]

But the follow json file, i have problem
{"success": "[{'product': u'BEER (BOTTLE)', 'barcode': '_', 'lot': u'N0007', 'id': 11, 'uom': u'CTN24', 'qty': 1.0}, {'product': u'SOFTDRINK', 'barcode': '_', 'lot': u'N0001', 'id': 12, 'uom': u'BOT', 'qty': 1.0}]"}

Regards,

PETER ZHOU
Posté le 13 avril 2018 - 15:18
If you are expecting to get one list from your second JSON you can't, check the use of " and ' in both samples and you will see the difference.

Use your json with problems and for instance
[{"id": 4, "name": "admin"},{"id": 5, "name": "admin5"}]
in one JSON formatter/Validator like https://jsonformatter.curiousconcept.com/ and you will see the difference