360Works Email User Guide

EmailAttachFile("http://localhost:8080/SuperContainer/123/RawData");

EmailAttachFile("file:///path/to/invoice.pdf");

EmailAttachFile("/Macintosh HD/path/to/invoice.pdf");

EmailAttachFile(myTable::myContainerField);

Note on paths vs urls: This function can also accept a path (/path/to/file) instead of a file URL (file://path/to/file). This is handy for attaching PDFs generated by FileMaker.

If called on a machine runing Mac OS X, a file URL is created from a path by prepending the directory /Volumes to the supplied path, since FileMaker includes the hard drive name in paths. For example, /MacintoshHD/Users/John Smith/Documents/ is converted to the file URL file:///Volumes/MacintoshHD/Users/John Smith/Documents/.

To use this function, first call EmailReadMessages with the appropriate parameters.

Next, call EmailGetNextMessage, which returns 1 or 0 depending on whether a message was loaded.

Finally, call EmailReadMessageValue to get individual properties of the currently loaded message.

• deleted
• replied
• draft
• flagged
• viewed
• recent

See EmailAttachFile for more information about how to attach a file.

After importing an email message into FileMaker, pass any attachment paths to this function to get container data for the attachment path. For example, you might pass the following argument:

EmailReadAttachment(
    "/Macintosh HD/private/tmp/4545776.01203682301836.JavaMail.root@pluto.local/text.html"
)

Note that this will actually work for any file, it doesn't need to be an email attachment.

If an error occurs, this function will return "ERROR". Use the EmailLastError function to get more information about the error.

Reading Individual Messages

After successfully calling EmailReadMessages, you can iterate over the fetched messages using the EmailGetNextMessage function. This pattern typically looks like this:

Loop
    Exit Loop If [not EmailGetNextMessage]
    New Record/Request
    Set Field[ImportedMessage::from ; EmailReadMessageValue( "from" )]
    Set Field[ImportedMessage::to ; EmailReadMessageValue( "to" )]
    Set Field[ImportedMessage::subject ; EmailReadMessageValue( "subject" )]
    Set Field[ImportedMessage::body ; EmailReadMessageValue( "body" )]
    Set Field[ImportedMessage::messageId ; EmailReadMessageValue( "messageId" )]
End Loop

Importing Messages via XML

To import email data into FileMaker via XML, use the "Import Records" script step, and specify an XML data source, passing the file URL returned from this function.
Use the "messageId" field in the resulting XML as a match field when defining import options. Note: XML import is not a web-safe script. Use the method described in "Reading Individual Messages" if your script is running in IWP or on the server, or if you need to modify individual messages on the server.

Flags

The following is a description of the available flags:

progress

Whether to show a cancellable progress bar (default is false).

mailbox

The name of the mailbox to read messages from. The default behavior is to read messages from the INBOX.

attachments

Boolean flag indicating whether to download attachment data. The default value is false, which disables attachment downloading. This is significantly faster. If attachment downloading is disabled, you can still retrieve a list of the attachments in a message using the EmailReadMessageValue ( "attachments" ) function. You can the re-read the message at a later time to download the attachments (see the EmailClient.fp7 example file).

skip

Skip this many records before reading results. This is useful for fetching messages in batches, if you know that messages will not be deleted from a mailbox during reading.

max

Do not return more than this many records in the import

from

Filter messages by from address

to

Filter messages by to address

subject

Filter messages by subject

messageId

Filter messages by messageId

body

Filter messages by body

viewed

Filter messages by their read/unread status. Pass true to return only previously viewed messages, false to return only unread messages.

flagged

Filter messages by their flagged status. Pass true to return only flagged messages, false to return only non-flagged messages.

deleted

Filter messages by their deleted status. Pass true to return only deleted messages, false to return only non-deleted messages.

readonly

Whether to open the mailbox folder as readonly or read-write. The default is true (read-only). If you plan on deleting, moving, or flagging any messages, use false in this parameter. Note: setting readonly=false will cause any fetched messages to be marked as "viewed"!

For example, you might use the following to fetch the first 25 unread messages from your inbox:

EmailReadMessages(
    "imap" ;
    "mailbox=INBOX" ;
    "attachments=false" ;
    "max=25" ;
    "attachments=false" ;
    "viewed=false"
)

If there are multiple values for a key, each value will be on a separate line.

The parameter must be one of the following values (case-insensitive):

• from (The FROM address)
• to (The TO addresses, comma-separated)
• cc (The CC addresses, comma-separated)
• bcc (The BCC addresses, comma-separated)
• replyTo (The reply-to address)
• subject
• messageNumber (the integer index of the message on the server. 1 is the first message in the mailbox)
• sent (The timestamp the message was sent)
• dateReceived (the timestamp the message was received)
• messageID (The unique message ID for the email message)
• attachments (A return-separated list of attachments for the message. Each line is either the attachment file path, or the name, depending on the value of the attachments parameter in EmailReadMessages)
• text (The plain-text message content, if available)
• html (The HTML body part, if one is available)
• uid (for IMAP only, returns the IMAP folder uid)
• viewed (1 or empty to indicate whether the message has been read (1) or is unread)
• flagged (1 or empty to indicate whether the message is flagged)
• replied (1 or empty)
• deleted (1 or empty)

EmailSetBody( GetAsCSS( Email::body ); "html" )