Hi @Shravan
Here is the sample flow based on the input data shared by you.
In this example, I have stored the html code in a compose action:
<p> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <style type="text/css"> <!-- body {padding:0 2em; font-family:Verdana,sans-serif; color:#444; background:#eee} table {background:#34495E; color:#fff; border-radius:.4em; overflow:hidden; margin:1em 0; min-width:300px} tr {border-top:1px solid #ddd; border-bottom:1px solid #ddd} tr {border-color:#46637f} th, caption, td:before {font-weight:bold!important; letter-spacing:-1px; color:#FFFF00!important; font-weight:bold!important} td:before {font-weight:bold; width:6.5em; display:inline-block} td {display:block; color:#FFFFFF} th, td {text-align:left; margin:4px 6pxem} td:first-child {padding-top:.5em} td:last-child {padding-bottom:.5em} @media (min-width: 480px) { td:before {display:none} th, td {display:table-cell; padding:.25em .5em; padding:4px!important} th:first-child, td:first-child {padding-left:0} th:last-child, td:last-child {padding-right:0} } --> </style> </head> <body> <table><caption>Table I of I which is a daily check</caption><thead><tr><th>[Domain]</th><th>[SQLInstance]</th><th>[evaldate]</th><th>[Database]</th><th>[Section]</th><th>[Details]</th><th>[Next Action]</th></tr></thead><tbody><tr><td>CFDAD</td><td>CFD-MPDB</td><td>2024-01-08T10:47:19</td><td>----</td><td>Failed Job Summary</td><td>Count;JobName;error_message;First failure;Last failure</td><td></td></tr><tr><td>CFDAD</td><td>CFD-MPDB</td><td>2024-01-08T10:47:19</td><td></td><td>Failed Job Summary</td><td>1;Multipick - Replen Create - PUHINUI;The job failed. The Job was invoked by Schedule 301 (replen fullfil PUHINUI). The last step to run was step 1 (replen fullfil PUHINUI).;Jan 8 2024 9:10AM;Jan 8 2024 9:10AM</td><td>Assign to DBA</td></tr><tr><td>CFDAD</td><td>CFD-MPDB</td><td>2024-01-08T10:47:19</td><td></td><td>Failed Job Summary</td><td>3;Multipick - Autorelease;The job failed. The Job was invoked by Schedule 284 (Autorelease). The last step to run was step 1 (Autorelease).;Jan 8 2024 8:25AM;Jan 8 2024 9:50AM</td><td>Assign to DBA</td></tr><tr><td>CFDAD</td><td>CFD-MPDB</td><td>2024-01-08T10:47:19</td><td>----</td><td>Failed Logins</td><td>Failure Count;Failure Text;MinFailureDate;MaxFailureDate</td><td></td></tr><tr><td>CFDAD</td><td>CFD-MPDB</td><td>2024-01-08T10:47:19</td><td>msdb</td><td>Failed Logins</td><td>2;Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.9.106];2024-01-03 18:42:56;2024-01-07 18:42:37</td><td>Raise with client</td></tr></tbody></table></body></html></p>
Next, add another compose action to extract the table from the input html code with the help of an expression. Expression needs to be added in the extraction window as shown below:
replace(replace(replace(concat('<table',first(split(last(split(outputs('Compose'),'<table')),'</table>')),'</table>'),'<br>',''),' ',''),decodeUriComponent('%0A'),'')
Finally, add "Select" action to create an array of objects which represent rows. Add expression for 'From' parameter and for each map key & value as shown below:
range(2, sub(int(xpath(xml(outputs('Compose_2')), 'count(//table//tbody//tr)')), 1))
Expression used for Map key & value:
| KEY |
VALUE |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[1]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[1]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[2]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[2]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[3]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[3]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[4]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[4]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[5]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[5]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[6]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[6]//text()')), ' ') |
| join(xpath(xml(outputs('Compose_2')),'//table//thead//tr[1]//th[7]//text()'),' ') |
join(xpath(xml(outputs('Compose_2')), concat('//table//tbody//tr[', item(), ']//td[7]//text()')), ' ') |
Output:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
