FoxInCloud has a FOSS function doing that, provided you remove the ‘\’ escape characters:
o = uValueJS(Strtran('{"code":" ERROR","message":"Message ","errors":[{"field1":"FIELD","value":"VALUE"}]}', '"', '"'))
https://github.com/FoxInCloud/FoxInCloud-AB https://github.com/FoxInCloud/FoxInCloud-AB
Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/
Le 16 nov. 2018 à 12:49, Paul Newton Paul.Newton@pegasus.co.uk a écrit :
Hi all
This is on Craig Boyd's Sweet Potato Software site (https://tinyurl.com/ybk97s97) but the download link is coming up 404. Any ideas where I can get hold of it? Or alternative VFP options to handle JSON? I have tried the following from various sources (e.g. VFPX, GitHub, CodePlex) : nfJson-master (Marco Plaza), vfpJson-master (Ignacio Gutiérrez Torrero), qdfoxjson (Victor Espina)
but none of them can decode JSON strings like this:
"{"code":" ERROR","message":"Message ","errors":[{"field1":"FIELD","value":"VALUE"}]}"
They all appear to stumble because of the additional JSON between the [] brackets. I could StrExtract the string between the [] and decode that separately but I would rather find something that can handle this directly. Failing that I'll have to "roll my own".
Thanks
Paul Newton
[excessive quoting removed by server]