PendingEmails

When working with Microsoft Flow, it is useful to be able to access pending emails to send as notifications to the user from Sage 200.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM PendingEmails WHERE Id = 123
SELECT * FROM PendingEmails WHERE EmailType = 'abc'
SELECT * FROM PendingEmails WHERE EmailAddress = 'abc'
SELECT * FROM PendingEmails WHERE EmailSubject = 'abc'
SELECT * FROM PendingEmails WHERE EmailBody = 'abc'
SELECT * FROM PendingEmails WHERE UserNumber = 123
SELECT * FROM PendingEmails WHERE UserName = 'abc'
SELECT * FROM PendingEmails WHERE DateTimeUpdated = '2019-10-02T11:46:53Z'

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique id of the Sage 200 pending email identifier.
EmailType	String		The type of pending email (which provides the intended purpose).
EmailAddress	String		The email address of the email recipient.
EmailSubject	String		The text to use for the subject of the email.
EmailBody	String		The text to use for the body of the email.
UserNumber	Long		The user id of the email recipient.
UserName	String		The user name of the email recipient.
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

JDBC Driver for Sage 200

PendingEmails

Table Specific Information

Select

Columns