saving URL strings as a JSON array modifies the URLs values

Question

I want to convert this array of youtube URLs to a JSON Array to be saved in an android SQL database.

[https://www.youtube.com/watch?v=FnCdOQsX5kc, https://www.youtube.com/watch?v=xKJmEC5ieOk]

It might be extended with other attributes at a later point so I encode with this:

 JSONObject mJsonObject = new JSONObject();
 mJsonObject.put(MoviesDBJsonUtils.MDB_JSON_OBJ_KEY, new JSONArray(detailsCellEntry));
 String urlArrayList = mJsonObject.toString();

It should now all be ready for saving into a SQL text field. But it gives me:

{"DB_JSON_OBJ_KEY":["https:\/\/www.youtube.com\/watch?v=FnCdOQsX5kc","https:\/\/www.youtube.com\/watch?v=xKJmEC5ieOk"]}

It's backslashing all the forward slashes. This is a pain in the butt. What's the best way of preventing this or remedying this?

I'm tempted to just scrap it and import another external library Gson, but bloating it up with libraries feels lazy.

Why dont you just save the original string? (The first one in your post). — greenapps
– greenapps, Commented Nov 27, 2017 at 10:37
greenapps, that's what I originally did but the insertion put it in double [[array 1, array 2 ]] this pushed me over. I've decided I may want to store more things in the object, other than a url array, so I'm setting it up. Greenapps - it's an unnecessary additional loop over the whole array to strip out the backslashes. — Sam
– Sam, Commented Nov 27, 2017 at 10:42

Tiago_nes · Accepted Answer · 2017-11-27 10:43:18Z

0

Try converting to a List before converting to Json

Arrays.asList(urlsArray)

answered Nov 27, 2017 at 10:43

Tiago_nes

9538 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Babul · Accepted Answer · 2017-11-27 10:45:27Z

0

First convert your json object to string

String urlArrayList = mJsonObject.toString();

than replace all \ with below function than use myurl in your purpose

String myUrl = urlArrayList .replace("\\","");

answered Nov 27, 2017 at 10:45

Babul

1,2428 silver badges11 bronze badges

Collectives™ on Stack Overflow

saving URL strings as a JSON array modifies the URLs values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related