JSON conversion bug when trying list all items

[toledano]

You could try https://ipwho.is/ returning JSON (without [] pairs).

ParseJson return an object containg dic of dics... OK

Caller retrieve it in an object var => OK

Looping each item in object get an error 13 Data type not compatible.
Trying to change receiver object as Dictionaries, getting error when setting object from ParseJson call...

I tried to debug within a day without success.

Platform Win11/64 MS/Access 2024

[Nick-vanGemeren]

"You could try ..." - are you replying to some other post?

If you are using aFor Eachon a Dictionary, remember to specify whether you want.Keysor.Items. TheFor Eachvaruable must be a Variant if the items may be non-objects or Object if the items may contain Collections (JSON Arrays) as well as Dictionaries (JSON Objects).

Beyond that, we would need to see the relevant code and maybe a small JSON which shows the problem. Attach them as text files.

================
If the above solves your problem, please close the issue here.

[Nick-vanGemeren]

If the JSON is coming from a database, it will usually be a set of records., with a JSON Array containing JSON Objects. After parsing, this will be a Collection of Dictionaries.