Setting up an Email Endpoint

Email Endpoints are available in PhixFlow version 11.3+

What is an Email Endpoint?

  Email Endpoints are a type of Actionflow that run in response to an incoming email and can read data into tables. They include the ability to handle attachments and save these to a file table. 

How does an Email Endpoint work?

  1. An Email Account must be set up in your application to receive incoming emails. See Email Account Integrationfor an example.
    1. The email account setup must include:
      1. Type: choose Inbound
      2. On Email Received: choose Trigger an email endpoint actionflow
      3. Email Endpoint Action: choose your   Email Endpoint
  2. To save the emails, a  Table must be created with appropriate attributes for the headers on the incoming emails, e.g. id, from, to, cc, subject, body, folderId
  3. To allow PhixFlow to save attachments, a  File Table must be created
  4. The above Table and File Table must have a relation on an ERD, see Relationship
  5. Upon receiving an email, the   Email Endpoint will run and perform the action(s) as specified within the Email Endpoint Actionflow, such as saving each incoming email as a record in a table 
    1. If saving to a table, each received email saves as a separate record

Creating an Email Endpoint

Email endpoints must be made using the specific option on the  Actionflow homepage to ensure the set of predefined input parameters are configured on the  incoming connection point.

  1. Create a new   Email Endpoint on the  Actionflow homepage using the  option
  2. Set a unique name and provide a useful description
  3. Additional attributes can be added to the  connection point which will obtain the value from a header with the same name on the incoming email(s) 
    1. Note: Any '-' characters are removed from the name and the names are case insensitive 
  4. Configure the endpoint to perform the required tasks on receiving of incoming emails, for example, save all records to a  Table, see Save Action Configuration
    1. If saving any of the attributes with a Type of Structured Data, a  Calculate action can be used between the  input and  Save action to convert these incoming values into a format that can be saved by PhixFlow
      1. For each attribute, use the listToString function

Email Endpoints cannot contain  Open Screen actions, output connection points, lookups or phases.

Saving Attachments

Attachments can be saved in a separate   File Table.

  1. On the Email Endpoint, click  Properties in the toolbar to open the settings on the right
    1. For the full Properties list, see Email Endpoint Properties
  2. In the Basic Settings, in the Save Attachments to field, set the File Table to save incoming email attachments to

    1. A new  File Table can be created by clicking the  icon or choose an existing table using the icon or selecting from the drop down list.
      1. When creating a File Table to save attachments to, a folderId attribute is automatically created

If the Email Endpoint fails, any incoming attachments will still be saved to the specified  File Table.

If no location is specified in the Save Attachments to field, attachments will not be saved.

Linking Emails and Attachments

The folderId attribute that is automatically created on new  File Tables is used to link an email to its attachments.

  • After receiving an incoming email with attachments:
    • A value will generate for the folderId attribute on the  Table where the email records are saved for each email received
    • value will generate for the folderId attribute on the  File Table where the email attachments are saved for each email received

Displaying Emails

Emails can be displayed using a  Grid view.  

Emojis in Emails

In PhixFlow version 11.4+, if the database collation for the PhixFlow system does not support certain Unicode characters they will be removed from the body of the incoming emails.


Worked Example

Coming Soon.

If you require support, please contact PhixFlow Support via either:

  •   Support Centre
  • Contact PhixFlow

These options are available in  Design Mode under the  Administration menu in the top right of PhixFlow.