javahtmlstringfor-loopjsoup
To read content from HTML using JSOUP Library in java
I am having HTML Email Body like Below.
I want to fetch Each element present in emailBody(Company,Priority,Description etc) and finally make Json Key Value pair.
I hope by using JSOUP Library we can able to achieve this.
HTML Content:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
</head>
<body dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<a>
<b>
<span lang="EN-US" style="font-size:10.0pt; font-family:"Segoe UI",sans-serif; color:black">Mandatory fields are Ticket Type, Company, Priority, Short Description. </span>
</b>
</a>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<span lang="EN-US" style=""> </span>
</b>
</span>
</p>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<span style=""></span>
<table class="MsoNormalTable" align="left" width="666" style="width:499.25pt; border-collapse:collapse; border:none; margin-left:6.75pt; margin-right:6.75pt; margin-bottom:5.75pt">
<tbody>
<tr style="height:19.85pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:19.85pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style=""></span>
<span style="">
<b>
<span style="color:red">Ticket Type: </span>
</b>
</span>
<span style="">
<span style=""> </span>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border:solid windowtext 1.0pt; border-left:none; padding:0cm 5.4pt 0cm 5.4pt; height:19.85pt">
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style="">Incident </span>
</span>
</p>
</td>
</tr>
<tr style="height:17.35pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style="">
<b>
<span style="">
<span style="color:red">Company:</span>
</span>
</b>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style="">Grupo Bimbo DSDE </span>
</span>
</p>
</td>
</tr>
<tr style="height:17.35pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style="">
<b>
<span style="">Configuration Item: </span>
</b>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<span style=""></span>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style=""> </span>
</span>
</p>
</td>
</tr>
<tr style="height:17.35pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style="">
<b>
<span style="color:red">Priority: </span>
</b>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style="">P3-Moderate </span>
</span>
</p>
</td>
</tr>
<tr style="height:17.35pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style="">
<b>
<span style="color:red">Short Description: </span>
</b>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<span style=""></span>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style=""> </span>
</span>
</p>
</td>
</tr>
<tr style="height:17.35pt">
<td width="150" valign="top" style="width:112.25pt; border:solid windowtext 1.0pt; border-top:none; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<p class="MsoNormal" align="right" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; text-align:right; line-height:105%">
<span style="">
<b>
<span style="">Description: </span>
</b>
</span>
</p>
</td>
<td width="516" valign="top" style="width:387.0pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt; height:17.35pt">
<span style=""></span>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif; line-height:105%">
<span style="">
<span style=""> </span>
</span>
</p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""></span>
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style=""> </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<u>
<span lang="EN-US" style="font-size:13.0pt">NOTE: Request user to contact CMS Operations Team at +91-7337894153/8939984385 for Critical Incidents - P1 with business impact. </span>
</u>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<b>
<span lang="EN-US" style=""> </span>
</b>
</span>
</p>
<p class="MsoNormal" style="margin:0cm; font-size:11pt; font-family:Calibri,sans-serif">
<span style="">
<span lang="EN-US" style="font-size:10.5pt; color:black">Thanks,
<br>CMS Support
</span>
</span>
<span style="">
<b>
<span lang="EN-US" style=""> </span>
</b>
</span>
</p>
<br>
</div>
</body>
</html>
Code:
public class FetchHTMLBody {
private static final Logger logger = Logger.getLogger(FetchHTMLBody.class.getName());
public static void main(String[] args) {
String htmlContent="<html Content mentioned above>"
Document doc = Jsoup.parse(htmlContent);
List<String> keys = new ArrayList<>();
List<Map<String, String>> dataPairs = new ArrayList<>();
Elements trElements = doc.getElementsByTag("tr");
//logger.info("trElements::" + trElements);
for (int i = 0; i < trElements.size(); i++) {
Element element = trElements.get(i);
Elements pElements = element.getElementsByTag("td");
//logger.info("pElements::" + pElements);
Map<String, String> map = new HashMap<>();
for (int i1 = 0; i1 < pElements.size(); i1++) {
Element p = pElements.get(i1);
if (i == 0) {
keys.add(p.text());
} else {
map.put(keys.get(i1), p.text());
}
}
dataPairs.add(map);
logger.info("trElements::" + dataPairs);
}
}
}
The above code gives wrong output like below
[{}, {Ticket Type: =Company: , Incident =Grupo Bimbo DSDE }, {Ticket Type: =Configuration Item: , Incident = }, {Ticket Type: =Priority: , Incident =P3-Moderate }, {Ticket Type: =Short Description: , Incident = }, {Ticket Type: =Description: , Incident = }]
Expected Output like below:
Ticket Type=Incident,
Company=Grupo Bimbo DSDE,
Configuration Item=null,
Priority=P3-Moderate,
Short Description=null,
Description=null
Can anyone please help me to resolve this?
Solution
Document doc = Jsoup.parse(htmlContent);
List<String> keys = new ArrayList<>();
List<Map<String, String>> dataPairs = new ArrayList<>();
Elements trElements = doc.getElementsByTag("tr");
//logger.info("trElements::" + trElements);
for (Element trElement : trElements) {
Elements tdElements = trElement.getElementsByTag("td");
//logger.info("pElements::" + pElements);
Map<String, String> map = new HashMap<>();
keys.add(tdElements.get(0).text());
map.put(tdElements.get(0).text(), tdElements.get(1).text());
dataPairs.add(map);
logger.info("trElements::" + dataPairs);
}
- NullPointerException in Java JDK code while performing parallelStream.forEach(..)
- Locating code that is filling PermGen with dead Groovy code
- Cannot find test class in project - "The input type of the launch configuration does not exist"
- Passing the values to the fraction class in java
- How to use different authentication methods for different paths using Spring Security
- how to fetch and validate csv header in open csv?
- 4-Sum algorithm failing with duplicate values in Java
- Error getting month while using Calendar object
- java Calendar Timezones strange stuff
- java.util.Date class with different approach for same date gives different output
- Finding out the type of invoked method in JDT
- How to get the size of a file in MB (Megabytes)?
- Exception in thread "main" java.lang.IllegalStateException: Attempted to load Config resource 'class path resource [application.yml]'
- Why does Google Calendar.Events.Watch say my request is not HTTPS
- Java - Class.forName, how to get a Field from Class
- Use of verify() method with and without times(1) parameter
- JDBC connection without database definition
- Running my testNG project from a jar using Maven
- Do subclasses inherit interfaces?
- Spring Security - how can I ask invoke access control methods directly?
- most accurate time type in java?
- How to get the currently selected application from Windows in Java
- validate the credit card expiry date using java?
- Finding the square root of a number by using binary search
- log4j : current time in milliseconds
- Why Joda DateTime gives different result than Java Date?
- Tomcat - maxThreads vs. maxConnections
- Android notification importance cannot be changed
- How to enable all endpoints in actuator (Spring Boot 2.0.0 RC1)
- Map rainbow colors to RGB