How can I parse a json representation of a response?

Question

I'm pretty new to JAVA so my apologies for asking a rather elementary question.

I have a json string that looks like this.

{"statusCode":201,
 "body":"[[\"food_corn\",\"48\"],[\"food_potatoes\",\"130\"],[\"food_rice\",\"80\"]]",
 "headers":{"Access-Control-Allow-Origin":"*"}}

I'm only interested in the body of the text which may have any number of elements.

At the end I'd like to have a map with the item name as the key and the number as the correspond value (as an integer).

Thanks for the help!

Update on where I'm at

String decoded = new String(invoke.getPayload().array(), "UTF-8");
HashMap<String, Object> map = new ObjectMapper().readValue(decoded, HashMap.class);
Object body = map.get("body")

where body looks like this

[["food_corn","48"],["food_potatoes","130"],["food_rice","80"],["food_wheat","999"]]

So then I try parsing it into an array like so

JSONArray array = new JSONArray(body);

But I get the error

EXCEPTION: JSONArray initial value should be a string or collection or array.

Which doesn't make sensee to me because the above looks like an array of arrays, no?

Does this answer your question? [How to parse JSON in Java](https://stackoverflow.com/questions/2591098/how-to-parse-json-in-java) — rkosegi, Aug 12 '20 at 05:07

score 1 · Answer 1 · answered Aug 12 '20 at 05:03

1

 @SneakyThrows
 @Test
 public void covertTest() {
  String str = "{\"statusCode\":201,\"body\":\"[[\\\"food_corn\\\",\\\"48\\\"],[\\\"food_potatoes\\\",\\\"130\\\"],"
    + "[\\\"food_rice\\\",\\\"80\\\"]]\",\"headers\":{\"Access-Control-Allow-Origin\":\"*\"}}";
  Map map = objectMapper.readValue(str, Map.class);
  System.out.println(map);
//{statusCode=201, body=[["food_corn","48"],["food_potatoes","130"],["food_rice","80"]], headers={Access-Control-Allow-Origin=*}}
}

answered Aug 12 '20 at 05:03

luckyheng

11
1

This is getting me closer... I made that map, accessed the `body` element but it won't let me cast it to array... Could you help me get a bit closer to have a map of the body elements? – financial_physician Aug 12 '20 at 05:26

score 0 · Answer 2 · answered Aug 12 '20 at 05:11

0

Parsing json to obj is called deserialization. You need to use some libarary to do this. I recommend Jackson. https://github.com/FasterXML/jackson

The below code is a sample to deserialize json into an object of a class. You need to define a class with all the fields then it will create an object of that class mapping to the json data.

    public void deserializeData() {
      var mapper = new ObjectMapper();
      var json = "{\"statusCode\":201,
     "body":"[[\"food_corn\",\"48\"],[\"food_potatoes\",\"130\"],[\"food_rice\",\"80\"]]",
     "headers":{"Access-Control-Allow-Origin":"*"}}";
      var throwable = catchThrowable(() -> mapper.readValue(json, JSONBody.class));
      log.info("You need to use an empty constructor: {}", throwable.getMessage());
      assertThat(throwable).isInstanceOf(InvalidDefinitionException.class);
    }

answered Aug 12 '20 at 05:11

diffuse

620
1
7
15

Unfortunately I'm writing in Java and not JS :/ – financial_physician Aug 12 '20 at 05:24
1

@financial_physician . Haha. It is java. New java is like this. They added var keyword from version java 10. – diffuse Aug 12 '20 at 07:19
It is code from a unit test in java. May be that's why you got confused. – diffuse Aug 12 '20 at 07:20
Also JS does not need to try this hard to parse JSON. – diffuse Aug 12 '20 at 07:23
That’s awesome! I’ll have to look more into it. I didn’t realize they added var and I haven’t used -> before – financial_physician Aug 12 '20 at 07:37

score 0 · Answer 3 · answered Aug 12 '20 at 06:41

Got it to work. Here's how I did it in case it helps anyone in the future.

(The invoke variable is the response from invoking a lambda call form a lambda call within the same region.)

try {
     String decoded = new String(invoke.getPayload().array(), "UTF-8");
     HashMap<String, Object> map = new ObjectMapper().readValue(decoded, HashMap.class);
     String body = map.get("body").toString();
     JSONArray array = new JSONArray(body);

     Map<String, Integer> inventory = new HashMap<>();
     for (Integer i=0; i < array.length(); i++) {
         JSONArray tuple = array.getJSONArray(i);
         String itemName = tuple.getString(0);
         Integer itemCount = tuple.getInt(1);
         inventory.put(itemName, itemCount);
     }
     logger.log("COMPILED INVENTORY: "+inventory.toString()+"\n");
} catch (Exception e) {
     logger.log("EXCEPTION: "+e.getMessage()+"\n");
}

How can I parse a json representation of a response?

3 Answers3