Inbound Email Action -Fetch data

[MarripudiL]

Hi All,

I have to create incident and need to fetch the data from table to fill in the incident description field. Can someone help me with the code to create inbound email action.

Sample data:

	Site	City	ST	Zip	Provider Name
6	C04	Hagerstown	MD	217	AT&T
11	C02	Capitola	CA	950	AT&T -
23	C01	New London	CT	620	Verizon
34	C05	Odessa	TX	5932	Verizon
41	C06	Rio Rancho	NM	2063	Verizon
42	C00	Bay City	TX	4503	Verizon
43	C08	Batesville	MS	3860	T-mobile

From the above table, I want only Site and zipcode column data and fill the incident description field in same table format.

Thanks in advance.

[Ankur Bawiskar]

@MarripudiL 

you will have to do string manipulation and regex to get the values for each row

sharing few links which might help you here. you will have to tweak it as per your requirements.

Get the values from HTML table from an email in a Inbound Action 

Get the values from HTML table from an email in a Inblund Action 

If my response helped please mark it correct and close the thread so that it benefits future readers.