Merge two String Arrays into a JSON format in JAVA [duplicate]

Question

I have these two arrays:

String[] COLUMN_NAMES = { "row_number", "column_name", "column_value_string", "column_value_float", "blockId", "pipelineId" };
String[] Values = { "1", "Output", "Valid", "", "123sde-dfgr", "pipeline-sde34" };

Where the output I need to be is in a json format (replacing empty values in Values Array with null in the output):

{
    "row_number": 1,
    "column_name": "output",
    "column_value_string": "Valid",
    "column_value_float": null,
    "blockId": "123sde-dfgr",
    "pipelineId": "pipeline-sde34"
}

Here is the code:

Map<String,String> result = IntStream.range( 0,COLUMN_NAMES.length ).boxed()
                                .collect( Collectors.toMap( i->COLUMN_NAMES[i], i->Values[i] ) );

@Mike'Pomax'Kamermans have you read the rest of the question? I mentioned that the empty values should be replaced with null — basel.ai
– basel.ai, Commented Aug 28, 2019 at 16:03
Build a Map<String, String> of column names to values, replacing empty values with null as you go, then ask a JSON generator to convert that to JSON. — Andreas
– Andreas, Commented Aug 28, 2019 at 16:03
One liner: JSONObject jSONObject = new JSONObject(IntStream.range(0, COLUMN_NAMES.length).boxed() .collect(Collectors.toMap(i -> COLUMN_NAMES[i], i -> (Values[i] == "" ? null : Values[i])))); — Giddy Naya
– Giddy Naya, Commented Aug 28, 2019 at 16:52

i.bondarenko · Accepted Answer · 2019-08-28 16:09:38Z

0

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;

import java.util.LinkedHashMap;
import java.util.Map;

public class Test {

    public static void main(String[] args) throws JsonProcessingException {
        String[] COLUMN_NAMES = { "row_number", "column_name", "column_value_string", "column_value_float", "blockId", "pipelineId" };
        String[] Values = { "1", "Output", "Valid", "", "123sde-dfgr", "pipeline-sde34" };
        Map<String, String> map = new LinkedHashMap<>();
        for (int i = 0; i < COLUMN_NAMES.length; i++) {
            map.put(COLUMN_NAMES[i], Values[i]);
        }

        String json = new ObjectMapper().writeValueAsString(map);
        System.out.println(json);
    }
}

answered Aug 28, 2019 at 16:09

i.bondarenko

3,6123 gold badges14 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Merge two String Arrays into a JSON format in JAVA [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related