We have a project where ServiceNow will be receiving an inbound email, and needs to create Incidents off of it. The information needed to create the Incidents is found in an HTML table in the email. I have found other threads discussing similar issues, but this one appears to be a bit different than those ones I found.
In all the other ones I found, the field name was in the first column of the table, and the value was in the second column. My table is structured differently. It has field name in the first row of the table, then data runs under it. So it will look something like this:
So, there will always be at least one row of data, but there could be more.
From this, I need to create an Incident for each separate data row. So, from the example I above, I would need to create 3 separate Incidents, one for each data row.
How can I do this?
How can I parse my data table in the inbound email action, and create an Incident for each row (using the values/details from each row)?
So, my end result would be three separate Incidents. The Short Description of these Incidents would look like:
Incident 1: "Site Expiration Notice for abc.com"
Incident 2: "Site Expiration Notice for lmn.com"
Incident 3: "Site Expiration Notice for xyz.com"
Thanks.
