check if json object contains specific value

Question

I have a json data listing all music scales and their keys.

this is how it looks like:

or the code view:

{
  "allScalesJson": [
    {
      "scale": "A Major",
      "keys": [
        "b",
        "a",
        "e",
        "d",
        "gs",
        "fs",
        "cs"
      ]
    },
    {
      "scale": "B Major",
      "keys": [
        "b",
        "e",
        "as",
        "gs",
        "fs",
        "ds",
        "cs"
      ]
    },
    {
      "scale": "D Major",
      "keys": [
        "b",
        "a",
        "g",
        "e",
        "d",
        "fs",
        "cs"
      ]
    }
  ]
}

I'm trying to create a method that will take keys as parameter and return all scales that contains those keys.

Example based on above json data:

List<String> returned_scales = findScalesThatContainThisKeys(Arrays.asList("a","d"));

output:

A Major, D Major

Here it is:

private List<String> findScalesThatContainThisKeys(List<String> keys_array){
    List<String> foundedScales = new ArrayList<>();
    try {
        JSONObject jsonObj = new JSONObject(loadJSONFromAsset());
        JSONArray rootElement = jsonObj.getJSONArray("allScalesJson");
        for (int i = 0; i < rootElement.length(); i++) {
            JSONObject obj = rootElement.getJSONObject(i);

            String scale = obj.getString("scale");

            // Keys is json array
            JSONArray genreArray = obj.getJSONArray("keys");
            ArrayList<String> keys = new ArrayList<>();
            for (int j = 0; j < genreArray.length(); j++) {
                // TODO: 5/12/2018
            }
        }
    }catch (Exception e){e.printStackTrace();}


    return foundedScales;
}

sorry i dont understnd this means ? " I'm trying to create a method that will take keys as parameter and return all scales that contains those keys." — BiRjU
– BiRjU, Commented May 12, 2018 at 4:57
@BirjuBhatt I've created an example of what I'm trying to do — Mehran
– Mehran, Commented May 12, 2018 at 5:02
All the items in your keys_array List should match ? or one item match is ik? — Abu Yousuf
– Abu Yousuf, Commented May 12, 2018 at 5:27
@AbuYousuf thanks for replay, order doesn't matter , but it should contain all the keys — Mehran
– Mehran, Commented May 12, 2018 at 5:30

Sandesh Gupta · Accepted Answer · 2018-05-12 05:32:34Z

1

Try this with for loops.

  private List<String> findScales(List<String> keys_array){
        List<String> foundedScales = new ArrayList<>();
        try {
            JSONObject jsonObj = new JSONObject(loadJSONFromAsset());
            JSONArray rootElement = jsonObj.getJSONArray("allScalesJson");
            ArrayList<String> scales_found = new ArrayList<>();

            for (int i = 0; i < rootElement.length(); i++) {
                JSONObject obj = rootElement.getJSONObject(i);

                String scale = obj.getString("scale");

                // Keys is json array
                JSONArray genreArray = obj.getJSONArray("keys");
                boolean all_found = true;

                for(String key: keys_array){
                   boolean found_this_key = false;
                   for (int j = 0; j < genreArray.length(); j++) {
                      if(key.equals(genreArray.getString(j))){
                          found_this_key = true;
                          break;
                      }
                   }
                   if(!found_this_key){
                        all_found = false;
                        break;
                   }
                }

                if(all_found){
                    scales_found.add(scale);
                }
            }

            return scales_found;
        }catch (Exception e){e.printStackTrace();}


        return foundedScales;
    }

answered May 12, 2018 at 5:32

Sandesh Gupta

1,1952 gold badges11 silver badges19 bronze badges

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

4 Comments

Sandesh Gupta Over a year ago

@AbuYousuf You can test it yourself. Its is checking for all keys

Abu Yousuf Over a year ago

Sorry didn't check full code. This will also work. Got confused with loops .

Abu Yousuf Over a year ago

Any way you can do it with one loop.

Sandesh Gupta Over a year ago

Even your answer is using 3 loops in total. Just that it is modular. Nice solution by the way..

Abu Yousuf · Accepted Answer · 2018-05-12 06:31:26Z

Use this code:

private List<String> findScales(List<String> keys_array){
List<String> foundedScales = new ArrayList<>();
try {
    JSONObject jsonObj = new JSONObject(loadJSONFromAsset());
    JSONArray rootElement = jsonObj.getJSONArray("allScalesJson");


    for (int i = 0; i < rootElement.length(); i++) {
        JSONObject obj = rootElement.getJSONObject(i);

        String scale = obj.getString("scale");

        // Keys is json array
        JSONArray genreArray = obj.getJSONArray("keys");
        ArrayList<String> keys = new ArrayList<>();
        for (int j = 0; j < genreArray.length(); j++) {
            // TODO: 5/12/2018
            String str = genreArray.getString(j);
            keys.add(str);
        }

        if(isContainsKeys(keys_array, keys)){
           foundedScales.add(scale);
        } 
    }
}catch (Exception e){e.printStackTrace();}


  return foundedScales;
}


public boolean isContainsKeys(List<String> keys_array, List<String> keys ){
    if (keys.size() == 0) {
        return false;
    }  
    for (String s : keys_array) {
        if (!keys.contains(s)) {
            return false;
        }
    }

    return true;
}

This will ignore uppercase or lowercase issue. For that all string should be converted in one case (uppercase/lowercase)

Rajasimman R · Accepted Answer · 2018-05-12 05:29:35Z

try this, use Hashmap and get by key

public class MainActivity extends AppCompatActivity {


    private RequestQueue mRequestQueue;
    private StringRequest mStringRequest;
    private String url = "url";

    JSONArray jsonArray;

    HashMap<String, String> meMap=new HashMap<String, String>();

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        mRequestQueue = Volley.newRequestQueue(this);
        //String Request initialized
        mStringRequest = new StringRequest(Request.Method.GET, url, new Response.Listener<String>() {
            @Override
            public void onResponse(String response) {


                try {
                    JSONObject jsonObject = new JSONObject(response);
                    jsonArray = jsonObject.getJSONArray("allScalesJson");
                    for (int i = 0; i <jsonArray.length() ; i++) {

                        jsonObject = jsonArray.getJSONObject(i);

                        meMap.put(jsonObject.getString("scale"),jsonObject.getString("keys"));

                    }

                    Toast.makeText(MainActivity.this, meMap.toString(), Toast.LENGTH_SHORT).show();
                    Toast.makeText(MainActivity.this, meMap.get("A Major"), Toast.LENGTH_SHORT).show();
                } catch (JSONException e) {
                    e.printStackTrace();
                }
            }
        }, new Response.ErrorListener() {
            @Override
            public void onErrorResponse(VolleyError error) {

            }
        });
        mRequestQueue.add(mStringRequest);


    }
}

Fazal Hussain · Accepted Answer · 2018-05-12 05:41:44Z

0

Update your code like below

private List<String> findScales(List<String> keys_array){ 
    List<String> foundedScales = new ArrayList<>(); 
    try { 
            JSONObject jsonObj = new JSONObject(loadJSONFromAsset());       

            JSONArray rootElement = jsonObj.getJSONArray("allScalesJson"); 
            for (int i = 0; i < rootElement.length(); i++) { 
                 JSONObject obj = rootElement.getJSONObject(i); 
                 String scale = obj.getString("scale"); // Keys is json array 
                JSONArray genreArray = obj.getJSONArray("keys");  
                ArrayList<String> keys = new ArrayList<>(); 
                for (int j = 0; j < genreArray.length(); j++) { 
                      if(keys_array.contains(genreArray.get(i)){
                        foundedScales.add(scale);
                     }
                } 
            } 
        }catch (Exception e) {
             e.printStackTrace();
        } 
    return foundedScales; 
}

answered May 12, 2018 at 5:41

Fazal Hussain

1,12712 silver badges30 bronze badges

1 Comment

Abu Yousuf Over a year ago

This will add scale for every key

Collectives™ on Stack Overflow

check if json object contains specific value

4 Answers 4

4 Comments

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related