SSIS Components for Sage 200

Build 20.0.7587

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).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587