B4J Question Unavoidable Spaces In JSON from API Upsetting the JSONParser

cklester · Nov 24, 2021

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 · Nov 24, 2021

Doing this until something better comes along:

B4X:

            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 · Nov 24, 2021

cklester said:
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/

cklester said:
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 · Nov 24, 2021

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

cklester · Nov 24, 2021

Erel said:
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.

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

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

B4J Question Unavoidable Spaces In JSON from API Upsetting the JSONParser

cklester

Well-Known Member

cklester

Well-Known Member

Erel

B4X founder

DonManfred

Expert

cklester

Well-Known Member

Similar Threads

B4J Question Unavoidable Spaces In JSON from API Upsetting the JSONParser

cklester

Well-Known Member

cklester

Well-Known Member

Erel

B4X founder

DonManfred

Expert

cklester

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency