Extract keys and values from email text

Nick_Sheetz · October 30, 2023, 2:41am

Hello,

I need help with a scenario. I regularly receive emails like the one listed below. The emails are always the same format with the only values changing being the text in “”. How can I make a scenario that can ingest this data, convert it to keys and values and then send it via webhook to another endpoint? I also want to make an array of anything that comes after the line “URL Link to the media files in the S3 bucket:”

Tour ID: “653d5389cfeecc4f1232f83b”;

Tour theme ID: “631127abfcd5c60182ebb35f”;

Account name: “nbean”;

Account email: “nbean@sares-regis.com”;

Client: “5d9df3265d985a294d628c21”;

Title: “The Heights at Park Lane Apartments”;

Building name: “Flats”;

Parent tour: “631127fcd1c9000190db079f”;

Parent tour theme ID: “631127abfcd5c60182ebb35f”;

Unit number: “F719”;

Amenity name: “”;

Street view connections URL: “https://login.tourbuilder.com/#/tour/streetview/create/5d9df3265d985a294d628c21/Sares%20Regis:::5…”;

Add scenes to the main tour: “false”;

Floor plan type: “F19”;

Camera id: “YN34113139”;

Tour type: “unit”;

other_property_type_name: “”;

URL Link to the media files in the S3 bucket:

Scene “Hallway”: Hallway
Scene “Hallway”: Hallway
Scene “Bathroom”: Bathroom
Scene “Hallway”: Hallway
Scene “Study room”: Study room
Scene “Kitchen”: Kitchen
Scene “Kitchen”: Kitchen
Scene “Kitchen”: Kitchen
Scene “Living Room”: Living Room
Scene “Living Room”: Living Room
Scene “Balcony”: Balcony
Scene “Living Room”: Living Room
Scene “Primary bedroom”: Primary bedroom
Scene “Primary bedroom”: Primary bedroom
Scene “Primary bedroom”: Primary bedroom
Scene “Primary bedroom”: Primary bedroom
Scene “Primary bedroom”: Primary bedroom
Scene “Primary bathroom”: Primary bathroom
Scene “Primary bathroom”: Primary bathroom
Scene “Primary bathroom”: Primary bathroom
Nav. data: indoor_data.json

Donald_Mitchell · October 30, 2023, 3:00am

Hi Nick,

You can use the Text Parser Match Elements module to extract the pieces of data from the text.

Then, you have use HTTP Module to pass the data on to another endpoint.

Nick_Sheetz · October 30, 2023, 4:15am

Thanks for the input! When I do that, it only allows me to map the first key and value rather than all 62 that should have been generated. (When I click in to the parse text response it shows 62 output bundles) See screen shot.