Get "id" from JSON file when i have "key" of specific row in champion.json

Question

This is my JSON file: http://ddragon.leagueoflegends.com/cdn/9.22.1/data/en_US/champion.json

The JSON has an ID and Name as two keys along with some other keys. For example,

{
  "type": "champion",
  "format": "standAloneComplex",
  "version": "9.22.1",
  "data": {
    "Aatrox": {
      "version": "9.22.1",
      "id": "Aatrox",
      "key": "266",
      "name": "Aatrox",
      "title": "the Darkin Blade"
    }
  }
}

So for a given key, say 'key=266', I want the id="Aatrox".

I found this code:

public String loadJSONFromAsset(Context context) {
    String json = null;
    try {
        InputStream is = context.getAssets().open("champion.json");

        int size = is.available();

        byte[] buffer = new byte[size];

        is.read(buffer);

        is.close();

        json = new String(buffer, "UTF-8");


    } catch (IOException ex) {
        ex.printStackTrace();
        return null;
    }
    return json;

}

and im trying this:

JSONObject obj = new JSONObject(loadJSONFromAsset(context));

JSONArray m_jArry = obj.getJSONArray("data");

JSONObject jo_inside = m_jArry.getJSONObject(key); 

String champName = jo_inside.getString("id");

EDITED This is my class where i already have my "key":

public class MatchListAdapter extends ArrayAdapter<Match> {

private static final String TAG = "MatchListAdapter";

private Context mContext;
private int mResource;
private int lastPosition = -1;
String championName;

public MatchListAdapter(Context context, int resource, ArrayList<Match> objects){
    super(context, resource, objects);
    mContext = context;
    mResource = resource;
}

@NonNull
@Override
public View getView(int position, View convertView, ViewGroup parent) {

    //Get the champions information
    String gameType = getItem(position).getGameType();
    int key = getItem(position).getKEY();
    String sex = getItem(position).getSex();

    LayoutInflater inflater = LayoutInflater.from(mContext);
    convertView = inflater.inflate(mResource, parent, false);

    TextView tvName = convertView.findViewById(R.id.testName);
    TextView tvBirthday = convertView.findViewById(R.id.textView2);
    TextView tvSex = convertView.findViewById(R.id.textView3);
    ImageView championIMG = convertView.findViewById(R.id.championImage);

    //Get name from champion.json using my "key" and then load imgage using Picasso

    Picasso.get()
            .load("http://ddragon.leagueoflegends.com/cdn/9.22.1/img/champion/"+championName+".png")
            .resize(100,100)
            .placeholder(R.drawable.ic_launcher_background)
            .into(championIMG, new Callback() {
                @Override
                public void onSuccess() {
                }

                @Override
                public void onError(Exception e) {
                    Log.d("error", "error Message: "+e.getMessage());
                }
            });

    tvName.setText(gameType);
    tvBirthday.setText("id: " + key);
    tvSex.setText(sex);

    return convertView;
}

}

Okay, but all of this is new for me, so how to retrive "id" when i got "key"? — 1haker, Nov 19 '19 at 12:05
I don't know if it is acceptable to point a youtube link. But still, https://www.youtube.com/watch?v=h5VLKYOQOjM — Saravana Kumar, Nov 19 '19 at 12:13
you could loop over all "keys" in data (which are the ids) as here https://stackoverflow.com/questions/684672/how-do-i-loop-through-or-enumerate-a-javascript-object then find the one whose "id" property is the one you seek. — Jeremy Kahan, Nov 19 '19 at 12:19

Mehdi Ayari · Answer 1 · 2019-11-19T12:43:03.990

0

try this code. My solution is to parse data object and test if the id is equal to the input

Input : idInput = "266"

Output: key == > Aatrox

    JSONParser parser = new JSONParser();
    String JsonString = "{\n" +
            "  \"type\": \"champion\",\n" +
            "  \"format\": \"standAloneComplex\",\n" +
            "  \"version\": \"9.22.1\",\n" +
            "  \"data\": {\n" +
            "    \"Aatrox\": {\n" +
            "      \"version\": \"9.22.1\",\n" +
            "      \"id\": \"Aatrox\",\n" +
            "      \"key\": \"266\",\n" +
            "      \"name\": \"Aatrox\",\n" +
            "      \"title\": \"the Darkin Blade\"\n" +
            "    }\n" +
            "  }\n" +
            "}";
    JSONObject jsonObject = (JSONObject) parser.parse(JsonString);

    JSONObject dataJsonObject = (JSONObject) jsonObject.get("data");

    //All keys ( aatrox , annie , ... )
    Set<String> keys = dataJsonObject.keySet();

    String idInput = "266" ;

    for(String key : keys ) {

        JSONObject jsonKey = (JSONObject)dataJsonObject.get(key) ;

        String idJsonObject = (String) jsonKey.get("key") ;

        if(idJsonObject.equals(idInput)) {
            System.out.println("key == > " + key);
            break ;
        }

    }

edited Nov 19 '19 at 12:43

answered Nov 19 '19 at 12:36

Mehdi Ayari

478
5
13

I'ill respond to you in comments for more infos ^^ hope it helps – Mehdi Ayari Nov 19 '19 at 12:47
Buy im looking for solution in Android Studio and there isnt class JSONParser :/ – 1haker Nov 19 '19 at 13:08
which library are you using for parsing json ? – Mehdi Ayari Nov 19 '19 at 13:09
i used this one on your example : https://mvnrepository.com/artifact/com.googlecode.json-simple/json-simple/1.1.1 I used the parser to convert json string to JSONObject just to test my solution – Mehdi Ayari Nov 19 '19 at 13:14
You should've specified it from the start. I saw JSONObject in your question so ithought you re using json-simple. No Problem , just after you do the get("data"). Parse the keys , and test the id each time – Mehdi Ayari Nov 19 '19 at 13:44

Mr. Polywhirl · Accepted Answer · 2019-11-19T13:30:49.710

With Google's Gson library, you can parse any valid JSON and simply traverse through the keys.

import java.io.*;
import java.util.Map.Entry;
import java.util.Set;
import java.util.stream.Collectors;
import com.google.gson.*;

public class ChampionSearch {
    public static void main(String[] args) {
        InputStream stream = ChampionSearch.class.getClassLoader().getResourceAsStream("champion.json");
        InputStreamReader reader = new InputStreamReader(stream);
        JsonObject json = JsonParser.parseReader(reader).getAsJsonObject();
        Entry<String, JsonElement> found = findFirst(json, "key", "266");
        System.out.printf("Found: %s%n", getValueForKey(found.getValue(), "id"));
    }

    public static String getValueForKey(JsonElement data, String key) {
        return data.getAsJsonObject().get(key).getAsString();
    }

    public static Entry<String, JsonElement> findFirst(JsonObject json, String key, String value) {
        return findAll(json, key, value).iterator().next();
    }

    public static Set<Entry<String, JsonElement>> findAll(JsonObject json, String key, String value) {
        return json.getAsJsonObject("data").entrySet().stream().filter(entry -> {
            return entry.getValue().getAsJsonObject().get(key).getAsString().equals(value);
        }).collect(Collectors.toSet());
    }
}

build.gradle

apply plugin: 'java'

repositories {
    jcenter()
}

dependencies {
    compile 'com.google.code.gson:gson:2.8.6'
}

You could also make the value retrieval generic, by providing a template class as the third parameter.

System.out.printf("Found: %s%n", getValueForKey(found.getValue(), "id", String.class));

@SuppressWarnings("unchecked")
public static <T> T getValueForKey(JsonElement data, String key, Class<T> clazz) throws IllegalArgumentException {
    JsonElement element = data.getAsJsonObject().get(key);

    if (Integer.class.equals(clazz)) {
        return (T) new Integer(element.getAsInt());
    } else if (Double.class.equals(clazz)) {
        return (T) new Double(element.getAsInt());
    } else if (Boolean.class.equals(clazz)) {
        return (T) new Boolean(element.getAsBoolean());
    } else if (String.class.equals(clazz)) {
        return (T) element.getAsString();
    }

    throw new IllegalArgumentException("Could not get value of type: " + clazz.getSimpleName());
}

Thank you for response, but how use this in Android Studio? – 1haker Nov 20 '19 at 11:27 — 1haker, Nov 20 '19 at 11:27
I edit my Question and put class where i got my "key". – 1haker Nov 20 '19 at 11:56 — 1haker, Nov 20 '19 at 11:56
Nevermind, everything is working perfect ! Thank you ! :) – 1haker Nov 20 '19 at 13:25 — 1haker, Nov 20 '19 at 13:25

Get "id" from JSON file when i have "key" of specific row in champion.json

2 Answers2

build.gradle