EmailFlowEmailContent - SuperOffice

“EmailFlowEmailContent”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.EmailFlowSMessageContentProvider inside NetServer’s SODatabase assembly. Email flow message content. Lists all email flow message content

Supported Entities

Name	Description
”SMessage”

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool
getNoRows	bool
shipmentMessageId	int		x
shipmentMessagePictureFolderId	int		x
shipmentMessageThumbnail	None
shipmentMessageSubject	string		x
shipmentMessageDescription	string		x
nameOrDescription	string		x
updatedBy	associate		x
updatedDate	date		x
registeredBy	associate		x
registeredDate	date		x
emailFlow/emailFlowId	int		x
emailFlow/emailFlowHierarchyId	int		x
emailFlow/shipmentType	listAny		x
emailFlow/overrideConsentSubscription	bool		x
emailFlow/thumbnail	None
emailFlow/mediumThumbnail	None
emailFlow/workflowId	int		x
emailFlow/workflowName	string		x
emailFlow/workflowDescription	string		x
emailFlow/workflowDefinitionStatus	listAny		x
emailFlow/workflowDefinitionStatusId	listAny		x
emailFlow/jumpToFinish	bool		x
emailFlow/startOnlyOnce	bool		x
emailFlow/workflowEnrolledCount	None
emailFlow/workflowInProgressCount	None
emailFlow/workflowCompletedCount	None
emailFlow/workflowSucceededCount	None
emailFlow/workflowSuccessRate	None
emailFlow/updatedBy	associate		x
emailFlow/updatedDate	date		x
emailFlow/registeredBy	associate		x
emailFlow/registeredDate	date		x
shipment/mailingId	int		x
shipment/mailingFolderId	int		x
shipment/mailingSelectionId	int		x
shipment/mailingDescription	string		x
shipment/mailingSent	listAny		x
shipment/mailingSimpleStatus	listAny		x
shipment/mailingEndDate	date		x
shipment/scheduledAt	date		x
shipment/mailingType	listAny		x
shipment/mailingTypeId	None
shipment/mailingStatusId	int
shipment/mailingConfiguration	int
shipment/mailingSubscriptionType	listAny		x
shipment/mailingSentTo	int		x
shipment/mailingOwner	associate		x
shipment/mailingFrom	string		x
shipment/mailingReplyTo	string		x
shipment/mailingSentCount	int		x
shipment/mailingOpenRate	decimal		x
shipment/mailingClickRate	decimal		x
shipment/mailingBounceRate	decimal		x
shipment/mailingDeleted	bool
shipment/recipientStatus	listAny
shipment/thumbnail	None
shipment/icon	None		x
shipment/date	date		x
shipment/type	listAny		x
shipment/text	positiveString		x
shipment/associateId	associate		x
shipment/contactId	listAny		x
shipment/personId	listAny		x
shipment/projectId	listAny		x
shipment/updatedBy	associate		x
shipment/updatedDate	date		x
shipment/registeredBy	associate		x
shipment/registeredDate	date		x
shipment/recordTypeText	None		x
shipment/emailFlow/emailFlowId	int		x
shipment/emailFlow/emailFlowHierarchyId	int		x
shipment/emailFlow/shipmentType	listAny		x
shipment/emailFlow/overrideConsentSubscription	bool		x
shipment/emailFlow/thumbnail	None
shipment/emailFlow/mediumThumbnail	None
shipment/emailFlow/workflowId	int		x
shipment/emailFlow/workflowName	string		x
shipment/emailFlow/workflowDescription	string		x
shipment/emailFlow/workflowDefinitionStatus	listAny		x
shipment/emailFlow/workflowDefinitionStatusId	listAny		x
shipment/emailFlow/jumpToFinish	bool		x
shipment/emailFlow/startOnlyOnce	bool		x
shipment/emailFlow/workflowEnrolledCount	None
shipment/emailFlow/workflowInProgressCount	None
shipment/emailFlow/workflowCompletedCount	None
shipment/emailFlow/workflowSucceededCount	None
shipment/emailFlow/workflowSuccessRate	None
shipment/emailFlow/updatedBy	associate		x
shipment/emailFlow/updatedDate	date		x
shipment/emailFlow/registeredBy	associate		x
shipment/emailFlow/registeredDate	date		x
shipment/emailFlow/workflowAssociate/firstName	string		x
shipment/emailFlow/workflowAssociate/lastName	string		x
shipment/emailFlow/workflowAssociate/middleName	string		x
shipment/emailFlow/workflowAssociate/fullName	string		x
shipment/emailFlow/workflowAssociate/contactId	int
shipment/emailFlow/workflowAssociate/personId	int

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
shipment/emailFlow/workflowAssociate/mrMrs	string		x
shipment/emailFlow/workflowAssociate/title	string		x
shipment/emailFlow/workflowAssociate/associateDbId	associate		x
shipment/emailFlow/workflowAssociate/contactName	string		x
shipment/emailFlow/workflowAssociate/contactDepartment	string		x
shipment/emailFlow/workflowAssociate/usergroup	userGroup		x
shipment/emailFlow/workflowAssociate/usergroupId	int		x
shipment/emailFlow/workflowAssociate/contactFullName	string		x
shipment/emailFlow/workflowAssociate/contactCategory	listAny		x
shipment/emailFlow/workflowAssociate/role	listAny		x
shipment/emailFlow/workflowAssociate/assocName	associate		x
shipment/emailFlow/workflowAssociate/assocTooltip	string
shipment/emailFlow/workflowAssociate/assocType	listAny		x
shipment/emailFlow/workflowAssociate/ejUserId	int
shipment/emailFlow/workflowAssociate/simultaneousEjUser	bool
shipment/emailFlow/workflowAssociate/ejDisplayName	string		x
shipment/emailFlow/workflowAssociate/ejStatus	int
shipment/emailFlow/workflowAssociate/credentialType	None		x
shipment/emailFlow/workflowAssociate/credentialDisplayValue	None		x
shipment/emailFlow/workflowAssociate/isActive	bool		x
shipment/emailFlow/workflowAssociate/isActiveText	bool		x
shipment/emailFlow/workflowAssociate/portraitThumbnail	None
shipment/emailFlow/workflowAssociate/otherGroups	userGroup
shipment/emailFlow/workflowAssociate/userName	string		x
shipment/emailFlow/workflowAssociate/personEmail	string		x
shipment/emailFlow/workflowAssociate/locationAddress	string		x
shipment/emailFlow/workflowAssociate/isLocation	bool		x
shipment/emailFlow/hierarchyId	int		x
shipment/emailFlow/hierarchyFullname	string		x
shipment/emailFlow/hierarchyName	string		x
shipment/emailFlow/hierarchyParentId	int		x
shipment/emailFlow/hierarchyFullpathIds	None
shipment/project/completed	bool		x
shipment/project/projectId	int		x
shipment/project/name	stringorPK		x
shipment/project/number	string		x
shipment/project/type	listAny		x
shipment/project/status	listAny		x
shipment/project/statusRank	None		x
shipment/project/associateId	associate		x
shipment/project/hasInfoText	bool		x
shipment/project/icon	None		x
shipment/project/text	string		x
shipment/project/description	string		x
shipment/project/updatedBy	associate		x
shipment/project/updatedByFullName	associate		x
shipment/project/updatedDate	date		x
shipment/project/registeredBy	associate		x
shipment/project/registeredByFullName	associate		x
shipment/project/registeredDate	date		x
shipment/project/hasGuide	bool		x
shipment/project/nextMilestone	date		x
shipment/project/endDate	date		x
shipment/project/imageThumbnail	None
shipment/project/activeErpLinks	bool		x
shipment/project/eventId	int		x
shipment/project/startDate	date		x
shipment/project/projectPublish/isPublished	bool		x
shipment/project/projectPublish/publishedFrom	date		x
shipment/project/projectPublish/publishedTo	date		x
shipment/project/projectPublish/publishedBy	None
shipment/project/projectEvent/isExternalEvent	bool		x
shipment/project/projectEvent/eventDate	date		x
shipment/project/projectEvent/hasSignOn	bool		x
shipment/project/projectEvent/hasSignOff	bool		x
shipment/project/projectUrl/URLAddress	string		x
shipment/project/projectUrl/URLDescription	string		x
shipment/project/projectAssociate/firstName	string		x
shipment/project/projectAssociate/lastName	string		x
shipment/project/projectAssociate/middleName	string		x
shipment/project/projectAssociate/fullName	string		x
shipment/project/projectAssociate/contactId	int
shipment/project/projectAssociate/personId	int
shipment/project/projectAssociate/mrMrs	string		x
shipment/project/projectAssociate/title	string		x
shipment/project/projectAssociate/associateDbId	associate		x
shipment/project/projectAssociate/contactName	string		x
shipment/project/projectAssociate/contactDepartment	string		x
shipment/project/projectAssociate/usergroup	userGroup		x
shipment/project/projectAssociate/usergroupId	int		x
shipment/project/projectAssociate/contactFullName	string		x
shipment/project/projectAssociate/contactCategory	listAny		x
shipment/project/projectAssociate/role	listAny		x
shipment/project/projectAssociate/assocName	associate		x
shipment/project/projectAssociate/assocTooltip	string
shipment/project/projectAssociate/assocType	listAny		x
shipment/project/projectAssociate/ejUserId	int
shipment/project/projectAssociate/simultaneousEjUser	bool
shipment/project/projectAssociate/ejDisplayName	string		x
shipment/project/projectAssociate/ejStatus	int
shipment/project/projectAssociate/credentialType	None		x
shipment/project/projectAssociate/credentialDisplayValue	None		x
shipment/project/projectAssociate/isActive	bool		x
shipment/project/projectAssociate/isActiveText	bool		x
shipment/project/projectAssociate/portraitThumbnail	None
shipment/project/projectAssociate/otherGroups	userGroup
shipment/project/projectAssociate/userName	string		x
shipment/project/projectAssociate/personEmail	string		x
shipment/project/projectAssociate/locationAddress	string		x
shipment/project/projectAssociate/isLocation	bool		x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
shipment/project/projectUdef/SuperOffice:1	string		x
shipment/project/projectUdef/SuperOffice:2	string		x
shipment/project/projectUdef/SuperOffice:3	int		x
shipment/project/projectUdef/SuperOffice:4	date		x
shipment/project/projectUdef/SuperOffice:5	unlimitedDate		x
shipment/project/projectUdef/SuperOffice:6	bool		x
shipment/project/projectUdef/SuperOffice:7	listAny		x
shipment/project/projectUdef/SuperOffice:8	decimal		x
shipment/project/projectUdef/SuperOffice:9	int		x
shipment/project/projectUdef/SuperOffice:10	int		x
shipment/project/NumberOfActivities	int
shipment/project/NumberOfActivitiesInPeriod	int
shipment/project/NumberOfNotCompletedActivities	int
shipment/project/NumberOfNotCompletedActivitiesInPeriod	int
shipment/project/LastActivity	date
shipment/project/LastCompletedActivity	date
shipment/project/LastDoByActivity	date
shipment/project/NumberOfSales	int
shipment/project/NumberOfSalesInPeriod	int
shipment/project/NumberOfNotCompletedSales	int
shipment/project/NumberOfNotCompletedSalesInPeriod	int
shipment/project/LastSale	date
shipment/project/LastCompletedSale	date
shipment/project/LastDoBySale	date
shipment/project/SaintStatus3	saintStatus
shipment/project/saintSaleStatus	listAny
shipment/project/saintAmountClass	listAny
shipment/project/saintActivityType	listAny
shipment/project/saintDirection	listAny
shipment/project/saintIntention	listAny
shipment/project/saintTicketStatus	listAny
shipment/project/saintTicketCategory	listAny
shipment/project/project/textId	int		x
shipment/project/project/infoText	positiveString		x
shipment/historyRank	int		x

Sample

GET /api/v1/archive/EmailFlowEmailContent?$select=shipment/project/saintAmountClass,shipment/emailFlow/workflowName,shipment/emailFlow/workflowAssociate/credentialDisplayValue
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.