B4J Question Unavoidable Spaces In JSON from API Upsetting the JSONParser

[cklester]

I'm getting some JSON from a website, and they apparently don't properly terminate their strings. It's causing this error:

(JSONException) org.json.JSONException: Unterminated object at character 31 of {symbol=CITY, name=Manchester City Fan Token, id=1489, tradingSymbol=CITY}

Looks like the spaces in the string values are causing issues.

{symbol=CITY, name=Manchester City Fan Token, id=1489, tradingSymbol=CITY}

How can I properly parse that string into JSON, since I have no control over what I receive from the API?

 

[cklester]

Doing this until something better comes along:

            s = s.SubString2(1,s.Length-1).Trim
            Dim sep() As String = Regex.Split(",",s)
            For Each str As String In sep
                Dim seps() As String = Regex.Split("=",str)
                newmap.Put(seps(0).trim,seps(1).Trim)
            Next

 

[Erel]

How can I properly parse that string into JSON

You can't because it is not a valid json string. You can test it here: https://jsonlint.com/

since I have no control over what I receive from the API?

If the API doesn't send properly formatted json then there is no proper way to parse it. You will need to use a "hack" as you did.

 

[DonManfred]

I would contact the Api Author and ask him to fix the defective json-output.

 

[cklester]

You can't because it is not a valid json string. You can test it here: https://jsonlint.com/

If the API doesn't send properly formatted json then there is no proper way to parse it. You will need to use a "hack" as you did.

I would contact the Api Author and ask him to fix the defective json-output.

Yes... Done! Let's see what they say!