how to consume an array within an array in spring boot?

Question

I am trying to consume an API whose response is like:-

{
    "data": [
        [
            "2075/76",
            "2075-2094767",
            "2075/08/29",
            1466,
            "210003502",
            null,
            "गीता  श्रीस काउचा थापा",
            2418146,
            null,
            14224,
            "Production",
            1800,
            0,
            "2074/75",
            "2075/09/02",
            "Cash",
            null,
            "1",
            null,
            null,
            11019,
            "2018/12/17",
            0,
            "T",
            null,
            "2018/12/17"
        ],
        [
            "2075/76",
            "2075-2093892",
            "2075/08/28",
            1466,
            "210003502",
            null,
            "हेमन्त  बुढाथोकी",
            2417027,
            null,
            14224,
            "Production",
            1400,
            0,
            "2074/75",
            "2075/09/02",
            "Cash",
            null,
            "1",
            null,
            null,
            11019,
            "2018/12/17",
            0,
            "T",
            null,
            "2018/12/17"
        ]
]
}

I am using spring boot and rest template like this.

 @GetMapping("/consume")
    public void consumeApi(@RequestParam  String date) throws IOException {
        BankVoucherParams params = setVoucherParams(date);
        RestTemplate restTemplate = new RestTemplate();

        String token = getBearerToken();

        HttpHeaders headers = new HttpHeaders();
        headers.setBearerAuth(token);


        HttpEntity<BankVoucherParams> request = new HttpEntity<BankVoucherParams>(params, headers);

        String response = restTemplate.postForObject(endpoint, request, String.class);

        ObjectMapper objectMapper = new ObjectMapper();

        Object o = objectMapper.readValue(response,Object.class);




        System.out.println(response);
    }

in the above code I get the response in string form. I want to map every value to a pojo class and insert it into my database. For now I don't know how to map each of these array into my pojo class.

This may help >> stackoverflow.com/questions/23109531/json-array-to-pojo — Nikhil Zurunge
– Nikhil Zurunge, Commented Dec 21, 2018 at 7:32

mkjh · Accepted Answer · 2018-12-21 07:25:45Z

0

You can convert the json string to a HashMap with key as "data" and value as

List<List<String>>

or

String[][].

Then iterate through the value and set it to a POJO.

If you would like to dynamically assign each position to a certain field of a POJO, you may wan to keep a mapping of position-field and uses reflection to set the fields. http://tutorials.jenkov.com/java-reflection/fields.html

answered Dec 21, 2018 at 7:25

mkjh

1,65413 silver badges25 bronze badges

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

Comments

elp · Accepted Answer · 2018-12-21 07:34:25Z

0

If the pojo is available in that project scope you can simly parse the whole object like this:

ResponseEntity<Object> response = restTemplate.exchange(url, HttpMethod.GET, entity, Object.class);

where Object can be replaced by your pojo. So you would have something similar to

ResponseEntity<YourClass> response = restTemplate.exchange(url, HttpMethod.GET, entity, YourClass.class);

If you need to map it you can use libraries like Gson or Jackson.

EDIT: As mentioned below you do not receive key/value pairs. Because of that you need to use a mapper library like Gson or Jackson

edited Dec 21, 2018 at 7:34

answered Dec 21, 2018 at 7:24

elp

8804 gold badges14 silver badges39 bronze badges

3 Comments

Ankur Over a year ago

I don't think it would work, because response does not have any key-value pair, but rather an object array

sagar limbu Over a year ago

how do i map with gson or jackson ?

Ankur Over a year ago

@sagarlimbu, I don't think you would be able to. Refer to the link mentioned in my comment to your question. You would need to have a similar implementation.

Collectives™ on Stack Overflow

how to consume an array within an array in spring boot?

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related