Notes

public List<Map<String, Object>> exampleQuery() {

List<Map<String, Object>> qresult = jdbcTemplate.queryForList(
"SELECT JsonData FROM [MDM_LAND].[dbo].[MULTIVATDQ_TEST]");

return qresult;
}

public void getResult(String filename) throws IOException, SQLException, JSONException {

List<Map<String, Object>> qresult = exampleQuery();
try (BufferedWriter writer = Files.newBufferedWriter(Paths.get(filename));

CSVPrinter csvPrinter = new CSVPrinter(writer,
CSVFormat.DEFAULT.withHeader("BPNUMBER", "LEGACY_ID", "SOURCE_SYSTEM", "SOURCE_VAT_RGSTRTN_NR",
"SOURCE_TAX_NR_1", "SOURCE_TAX_NR_2", "SOURCE_TAX_NR_3", "SOURCE_TAX_NR_4",
"SOURCE_ORG_NM_1", "SOURCE_ORG_NM_2", "SOURCE_ORG_NM_3", "SOURCE_ORG_NM_4",
"SOURCE_STREET", "SOURCE_CITY", "SOURCE_COUNTRY", "SOURCE_REGION", "SOURCE_POSTAL_CODE",
"MDM_ORG_NM", "MDM_ADDR_LN_1", "MDM_ADDR_LN_2", "MDM_ADDR_LN_3", "MDM_CITY",
"MDM_STATE_PRVC_NM", "MDM_POSTAL_CODE", "MDM_COUNTRY", "MDM_IDENTIFIER_TYPE",
"MDM_IDENTIFIER_TYPE_Description", "MDM_IDENTIFIER_VAL", "MDM_VAT_TAX_COUNTRY",
"External_Identifier_Type_Status", "ON_UNMERGE_LIST", "ON_DASHBOARD", "VALID_TAX_FIELD",
"XREF_DUNS_ID", "PRTY_DUNS_ID", "SRC_DLT_IND"

));) {

for (int i = 0; i < qresult.size(); i++) {
replaceNullValues(qresult.get(i), "null");

}
for (int i = 0; i < qresult.size(); i++) {
JSONObject jo = new JSONObject(qresult.get(i));
String t1 = jo.getString("BPNUMBER");
String t2 = jo.getString("LEGACY_ID");
String t3 = jo.getString("SOURCE_SYSTEM");
String t4 = jo.getString("SOURCE_VAT_RGSTRTN_NR");
String t5 = jo.getString("SOURCE_TAX_NR_1");
String t6 = jo.getString("SOURCE_TAX_NR_2");
String t7 = jo.getString("SOURCE_TAX_NR_3");
String t8 = jo.getString("SOURCE_TAX_NR_4");
String t9 = jo.getString("SOURCE_ORG_NM_1");
String t10 = jo.getString("SOURCE_ORG_NM_2");
String t11 = jo.getString("SOURCE_ORG_NM_3");
String t12 = jo.getString("SOURCE_ORG_NM_4");
String t13 = jo.getString("SOURCE_STREET");
String t14 = jo.getString("SOURCE_CITY");
String t15 = jo.getString("SOURCE_COUNTRY");
String t16 = jo.getString("SOURCE_REGION");
String t17 = jo.getString("SOURCE_POSTAL_CODE");
String t18 = jo.getString("MDM_ORG_NM");
String t19 = jo.getString("MDM_ADDR_LN_1");
String t20 = jo.getString("MDM_ADDR_LN_2");
String t21 = jo.getString("MDM_ADDR_LN_3");
String t22 = jo.getString("MDM_CITY");
String t23 = jo.getString("MDM_STATE_PRVC_NM");
String t24 = jo.getString("MDM_POSTAL_CODE");
String t25 = jo.getString("MDM_COUNTRY");
String t26 = jo.getString("MDM_IDENTIFIER_TYPE");
String t27 = jo.getString("MDM_IDENTIFIER_TYPE_Description");
String t28 = jo.getString("MDM_IDENTIFIER_VAL");
String t29 = jo.getString("MDM_VAT_TAX_COUNTRY");
String t30 = jo.getString("External_Identifier_Type_Status");
String t31 = jo.getString("ON_UNMERGE_LIST");
String t32 = jo.getString("ON_DASHBOARD");
String t33 = jo.getString("VALID_TAX_FIELD");
String t34 = jo.getString("XREF_DUNS_ID");
String t35 = jo.getString("PRTY_DUNS_ID");
String t36 = jo.getString("SRC_DLT_IND");

csvPrinter.printRecord(t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18,
t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29, t30, t31, t32, t33, t34, t35, t36);

}

csvPrinter.flush();
}

}