Parsing Dynamic JSON Data with Gson and Store it in SQlite DB in Android

Question

I get this JSON response from server in my Android application and I want to parse this data by Gson , In Json Response permission tag of my may contains 20-25 data with key like 1, 2,... every value of the permission contains two information separated by # key I have to display only those things which comes into permission in response. Parsed Object Class(Pojo or Model Class must be Parcelable implemented ) My application also support offline feature so, Need suggestion how I can store data in DB at same time when parsing.

[{
    "permission": {
        "0": "Title#RaqStar",
        "1": "Desc#Reader of Raw Star",
        "3": "Tytpe#Entertainment",
        "4": "Rating#4.5"
    },
    "id": "233",
    "name": "Movie Raw Star"
}, {
    "permission": {
        "0": "Title#RaqStar",
        "3": "Tytpe#Entertainment",
        "4": "Rating#4.5"
    },
    "id": "233",
    "name": "Movie Raw Star"
}, {
    "permission": {
        "1": "Desc#Reader of Raw Star",
        "3": "Tytpe#Entertainment",
        "4": "Rating#4.5"
    },
    "id": "233",
    "name": "Movie Raw Star"
}, {
    "permission": {
        "1": "Desc#Reader of Raw Star",
        "4": "Rating#4.5"
    },
    "id": "233",
    "name": "Movie Raw Star"
}]

What code do you use to handle the JSON data? Why can't you store the data in your DB at that time? — Bob Dalgleish, Dec 29 '15 at 14:21
I simply parse the data from and now It's String object format. — chotemotelog, Dec 30 '15 at 04:43
You will have to clarify. Did you want to store the JSON data as a string, or did you want to break out all of the properties and store it as a (somewhat) normalized data structure in your database? — Bob Dalgleish, Dec 30 '15 at 14:37

score 0 · Answer 1 · answered Jun 12 '17 at 07:44

    //  Whole response array I took as a String "data"
    try {
        JSONArray array = new JSONArray(data);
        for (int i = 0; i < array.length(); i++) {
             responseJSonObj = array.getJSONObject(i);
             System.out.println(
             generateTitleInfoMap(responseJSonObj.
             getJSONObject("permission")));
        }

    } catch (JSONException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }


public static HashMap<String, String> generateTitleInfoMap(JSONObject titleInfoMap) {
    try {
        HashMap<String, String> mapdataVal = new HashMap<String, String>();

        if (titleInfoMap.length() > 0) {
            Iterator keys = titleInfoMap.keys();
            while (keys.hasNext()) {
                // loop to get the dynamic key
                String currentDynamicKey = (String) keys.next();
                String[] ar = (titleInfoMap.getString(currentDynamicKey)).split("#");

                mapdataVal.put(ar[0], ar[1]);
            }
        }
        return mapdataVal;
    } catch (JSONException e) {

    }
    return null;
}

@tsp you can check this example using Gson https://github.com/abhishekkdubey/Dynamic-JSON-Parsing — chotemotelog, Jun 15 '17 at 18:42

Parsing Dynamic JSON Data with Gson and Store it in SQlite DB in Android

1 Answers1