I’m using an IMAP email trigger for an automation where I’m using the content of the email in a workbench with the goal of delivering a JSON payload to Cityworks to automatically create a new Work Order.

I’ve set up a User Parameter in the workbench to receive data from the the email. When I use the “Event as JSON” option for the parameter in FME Flow, the message body is being delivered to the workbench as HTML. This crashes the JSON being delivered. Everything up to the body is fine, but the message body doesn’t make it over, and everything that follows the body is also lost.

I’ve been able to get the message content into a workbench by using the individual headings such as “Email Body”, “Email Subject”,  “Sent from Address” headings in Flow as the parameters to pass, but doing it this way does not allow you to use the JSON transformers in the workbench.

Essentially what I am needing to do is receive JSON formatted data in a workbench from the IMAP email trigger, create attributes from the JSON (including the email body), and then build a JSON payload from the attributes to deliver to Cityworks.

I’ve been working on this a couple of days, and the only hangup is the email body. Any suggestions?