MailingsAndFolders - SuperOffice

“MailingsAndFolders”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.MailingsAndFoldersProvider inside NetServer’s SODatabase assembly. Combined archive of mailings (s_shipment) and mailing folders (s_picture_folder, folder_type = shipmentFolder) — analogous to EmailFlowsAndFoldersProvider. Unified row schema (after the column-name overrides set up below):

PrimaryKey — row’s own id
mailingFolderId — row’s container folder id (for filtering)
name — display label (mailing description on mailings, folder name on folders), via overrides
thumbnail — preview image / folder icon hint (native on both)

Client filter mailingFolderId = N returns mailings whose s_shipment.FolderId = N AND folders whose s_picture_folder.ParentId = N — i.e. everything contained in folder N. The name overrides are applied here (not by renaming the underlying extender columns) so MailingsExtenderBase keeps its native mailingDescription column for every OTHER archive that uses it (Contact / Person / Project / Sale cards). Same approach as EmailFlowsAndFoldersProvider (workflowName / hierarchyName both → name).

Supported Entities

Name	Description
”mailingfolder"
"all”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
folderId	None
mailingFolderId	int	x
name	string	x
thumbnail	None
sortGroup	None
sortName	None	x
mailingId	None
mailingSelectionId	None
mailingSent	None
mailingSimpleStatus	None
mailingEndDate	None
scheduledAt	None
mailingType	None
mailingTypeId	None
mailingStatusId	None
mailingConfiguration	None
mailingSubscriptionType	None
mailingSentTo	None
mailingOwner	None
mailingFrom	None
mailingReplyTo	None
mailingSentCount	None
mailingOpenRate	None
mailingClickRate	None
mailingBounceRate	None
mailingDeleted	None
recipientStatus	None
icon	None
date	None
type	None
text	None
associateId	None
contactId	None
personId	None
projectId	None
updatedBy	None
updatedDate	None
registeredBy	None
registeredDate	None
recordTypeText	None
mailingAddr/mailingAddrId	None
mailingAddr/contact/contactId	None
mailingAddr/contact/name	None
mailingAddr/contact/department	None
mailingAddr/contact/nameDepartment	None
mailingAddr/contact/hasInfoText	None
mailingAddr/contact/hasInterests	None
mailingAddr/contact/associateId	None
mailingAddr/contact/category	None
mailingAddr/contact/categoryGroup	None
mailingAddr/contact/companyCategoryRank	None
mailingAddr/contact/business	None
mailingAddr/contact/country	None
mailingAddr/contact/countryId	None
mailingAddr/contact/number	None
mailingAddr/contact/code	None
mailingAddr/contact/orgnr	None
mailingAddr/contact/stop	None
mailingAddr/contact/contactNoMail	None
mailingAddr/contact/updatedBy	None
mailingAddr/contact/updatedByFullName	None
mailingAddr/contact/updatedDate	None
mailingAddr/contact/registeredBy	None
mailingAddr/contact/registeredByFullName	None
mailingAddr/contact/registeredDate	None
mailingAddr/contact/contactSource	None
mailingAddr/contact/contactDeleted	None
mailingAddr/contact/phone/formattedNumber	None
mailingAddr/contact/activeErpLinks	None
mailingAddr/contact/numEmployees	None
mailingAddr/contact/yearFounded	None
mailingAddr/contact/revenueYear	None
mailingAddr/contact/revenueBasecurrency	None
mailingAddr/contact/sharecapitalBasecurrency	None
mailingAddr/contact/sourcedFrom	None
mailingAddr/contact/linkedinUrl	None
mailingAddr/contact/deletedDate	None
mailingAddr/contact/mainContact	None
mailingAddr/contact/forceCompany	None
mailingAddr/contact/contactPhone/formattedNumber	None
mailingAddr/contact/contactPhone/description	None
mailingAddr/contact/contactFax/formattedNumber	None
mailingAddr/contact/contactFax/description	None
mailingAddr/contact/searchPhone/formattedNumber	None
mailingAddr/contact/searchPhone/description	None
mailingAddr/contact/email/emailProtocol	None
mailingAddr/contact/email/emailAddress	None
mailingAddr/contact/email/emailDescription	None
mailingAddr/contact/email/emailId	None
mailingAddr/contact/email/emailLastSent	None
mailingAddr/contact/email/emailBounceCount	None
mailingAddr/contact/email/emailLastBounce	None
mailingAddr/contact/email/emailHasBounced	None
mailingAddr/contact/postAddress/addressId	None
mailingAddr/contact/postAddress/line1	None
mailingAddr/contact/postAddress/line2	None
mailingAddr/contact/postAddress/line3	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
mailingAddr/contact/postAddress/county	None
mailingAddr/contact/postAddress/city	None
mailingAddr/contact/postAddress/zip	None
mailingAddr/contact/postAddress/state	None
mailingAddr/contact/postAddress/wgs84latitude	None
mailingAddr/contact/postAddress/wgs84longitude	None
mailingAddr/contact/postAddress/formattedAddress	None
mailingAddr/contact/postAddress/formattedMultiLineAddress	None
mailingAddr/contact/streetAddress/addressId	None
mailingAddr/contact/streetAddress/line1	None
mailingAddr/contact/streetAddress/line2	None
mailingAddr/contact/streetAddress/line3	None
mailingAddr/contact/streetAddress/county	None
mailingAddr/contact/streetAddress/city	None
mailingAddr/contact/streetAddress/zip	None
mailingAddr/contact/streetAddress/state	None
mailingAddr/contact/streetAddress/wgs84latitude	None
mailingAddr/contact/streetAddress/wgs84longitude	None
mailingAddr/contact/streetAddress/formattedAddress	None
mailingAddr/contact/streetAddress/formattedMultiLineAddress	None
mailingAddr/contact/restrictionAddress/addressId	None
mailingAddr/contact/restrictionAddress/line1	None
mailingAddr/contact/restrictionAddress/line2	None
mailingAddr/contact/restrictionAddress/line3	None
mailingAddr/contact/restrictionAddress/county	None
mailingAddr/contact/restrictionAddress/city	None
mailingAddr/contact/restrictionAddress/zip	None
mailingAddr/contact/restrictionAddress/state	None
mailingAddr/contact/restrictionAddress/wgs84latitude	None
mailingAddr/contact/restrictionAddress/wgs84longitude	None
mailingAddr/contact/restrictionAddress/formattedAddress	None
mailingAddr/contact/restrictionAddress/formattedMultiLineAddress	None
mailingAddr/contact/url/URLAddress	None
mailingAddr/contact/url/URLDescription	None
mailingAddr/contact/contactAssociate/firstName	None
mailingAddr/contact/contactAssociate/lastName	None
mailingAddr/contact/contactAssociate/middleName	None
mailingAddr/contact/contactAssociate/fullName	None
mailingAddr/contact/contactAssociate/contactId	None
mailingAddr/contact/contactAssociate/personId	None
mailingAddr/contact/contactAssociate/mrMrs	None
mailingAddr/contact/contactAssociate/title	None
mailingAddr/contact/contactAssociate/associateDbId	None
mailingAddr/contact/contactAssociate/contactName	None
mailingAddr/contact/contactAssociate/contactDepartment	None
mailingAddr/contact/contactAssociate/usergroup	None
mailingAddr/contact/contactAssociate/usergroupId	None
mailingAddr/contact/contactAssociate/contactFullName	None
mailingAddr/contact/contactAssociate/contactCategory	None
mailingAddr/contact/contactAssociate/role	None
mailingAddr/contact/contactAssociate/assocName	None
mailingAddr/contact/contactAssociate/assocTooltip	None
mailingAddr/contact/contactAssociate/assocType	None
mailingAddr/contact/contactAssociate/ejUserId	None
mailingAddr/contact/contactAssociate/simultaneousEjUser	None
mailingAddr/contact/contactAssociate/ejDisplayName	None
mailingAddr/contact/contactAssociate/ejStatus	None
mailingAddr/contact/contactAssociate/credentialType	None
mailingAddr/contact/contactAssociate/credentialDisplayValue	None
mailingAddr/contact/contactAssociate/isActive	None
mailingAddr/contact/contactAssociate/isActiveText	None
mailingAddr/contact/contactAssociate/portraitThumbnail	None
mailingAddr/contact/contactAssociate/otherGroups	None
mailingAddr/contact/contactAssociate/userName	None
mailingAddr/contact/contactAssociate/personEmail	None
mailingAddr/contact/contactAssociate/locationAddress	None
mailingAddr/contact/contactAssociate/isLocation	None
mailingAddr/contact/contactInterestIds	None
mailingAddr/contact/contactUdef/SuperOffice:1	None
mailingAddr/contact/contactUdef/SuperOffice:2	None
mailingAddr/contact/contactUdef/SuperOffice:3	None
mailingAddr/contact/contactUdef/SuperOffice:4	None
mailingAddr/contact/contactUdef/SuperOffice:5	None
mailingAddr/contact/contactUdef/SuperOffice:6	None
mailingAddr/contact/contactUdef/SuperOffice:7	None
mailingAddr/contact/contactUdef/SuperOffice:8	None
mailingAddr/contact/contactUdef/SuperOffice:9	None
mailingAddr/contact/contactUdef/SuperOffice:10	None
mailingAddr/contact/contactUdef/SuperOffice:11	None
mailingAddr/contact/contactUdef/SuperOffice:12	None
mailingAddr/contact/contactUdef/SuperOffice:13	None
mailingAddr/contact/contactExtra/x_contact_integer	None
mailingAddr/contact/contactExtra/x_contact_hidden_integer	None
mailingAddr/contact/contactExtra/x_contact_default_integer	None
mailingAddr/contact/contactExtra/x_contact_float	None
mailingAddr/contact/contactExtra/x_contact_longtext	None
mailingAddr/contact/contactExtra/x_contact_dropdown	None
mailingAddr/contact/contactExtra/x_contact_date	None
mailingAddr/contact/contactExtra/x_contact_datetime	None
mailingAddr/contact/contactExtra/x_contact_time	None
mailingAddr/contact/contactExtra/x_contact_boolean	None
mailingAddr/contact/contactExtra/x_contact_timespan	None
mailingAddr/contact/contactExtra/x_contact_shorttext	None
mailingAddr/contact/contactExtra/x_contact_short_dropdown	None
mailingAddr/contact/contactExtra/x_contact_contact_relation	None
mailingAddr/contact/contactExtra/x_contact_request_relation	None
mailingAddr/contact/contactExtra/x_contact_contact	None
mailingAddr/contact/contactExtra/y_organization/x_name	None
mailingAddr/contact/NumberOfActivities	None
mailingAddr/contact/NumberOfActivitiesInPeriod	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
mailingAddr/contact/NumberOfNotCompletedActivities	None
mailingAddr/contact/NumberOfNotCompletedActivitiesInPeriod	None
mailingAddr/contact/LastActivity	None
mailingAddr/contact/LastCompletedActivity	None
mailingAddr/contact/LastDoByActivity	None
mailingAddr/contact/NumberOfSales	None
mailingAddr/contact/NumberOfSalesInPeriod	None
mailingAddr/contact/NumberOfNotCompletedSales	None
mailingAddr/contact/NumberOfNotCompletedSalesInPeriod	None
mailingAddr/contact/LastSale	None
mailingAddr/contact/LastCompletedSale	None
mailingAddr/contact/LastDoBySale	None
mailingAddr/contact/NumberOfTickets	None
mailingAddr/contact/NumberOfTicketsInPeriod	None
mailingAddr/contact/NumberOfNotCompletedTickets	None
mailingAddr/contact/NumberOfNotCompletedTicketsInPeriod	None
mailingAddr/contact/LastTicket	None
mailingAddr/contact/LastCompletedTicket	None
mailingAddr/contact/LastDoByTicket	None
mailingAddr/contact/SaintStatus1	None
mailingAddr/contact/SaintStatus2	None
mailingAddr/contact/saintSaleStatus	None
mailingAddr/contact/saintAmountClass	None
mailingAddr/contact/saintActivityType	None
mailingAddr/contact/saintDirection	None
mailingAddr/contact/saintIntention	None
mailingAddr/contact/saintTicketStatus	None
mailingAddr/contact/saintTicketCategory	None
mailingAddr/person/personId	None
mailingAddr/person/firstName	None
mailingAddr/person/lastName	None
mailingAddr/person/middleName	None
mailingAddr/person/fullName	None
mailingAddr/person/contactId	None
mailingAddr/person/hasInfoText	None
mailingAddr/person/hasInterests	None
mailingAddr/person/personHasInterests	None
mailingAddr/person/mrMrs	None
mailingAddr/person/position	None
mailingAddr/person/personNumber	None
mailingAddr/person/title	None
mailingAddr/person/personCountry	None
mailingAddr/person/personCountryId	None
mailingAddr/person/personNoMail	None
mailingAddr/person/rank	None
mailingAddr/person/birthdate	None
mailingAddr/person/associateType	None
mailingAddr/person/useAsMailingAddress	None
mailingAddr/person/personSource	None
mailingAddr/person/retired	None
mailingAddr/person/birthYear	None
mailingAddr/person/birthMonth	None
mailingAddr/person/birthDay	None
mailingAddr/person/kanaFirstName	None
mailingAddr/person/kanaLastName	None
mailingAddr/person/personUpdatedBy	None
mailingAddr/person/personUpdatedByFullName	None
mailingAddr/person/personUpdatedDate	None
mailingAddr/person/personRegisteredBy	None
mailingAddr/person/personRegisteredByFullName	None
mailingAddr/person/personRegisteredDate	None
mailingAddr/person/portraitThumbnail	None
mailingAddr/person/personActiveErpLinks	None
mailingAddr/person/personSourcedFrom	None
mailingAddr/person/personLinkedinUrl	None
mailingAddr/person/ticketPriority	None
mailingAddr/person/supportLanguage	None
mailingAddr/person/supportAssociate	None
mailingAddr/person/supportAssociateFullName	None
mailingAddr/person/personAssociateId	None
mailingAddr/person/personAssociateFullName	None
mailingAddr/person/personCategory	None
mailingAddr/person/personCategoryGroup	None
mailingAddr/person/personCategoryRank	None
mailingAddr/person/personBusiness	None
mailingAddr/person/leadStatus	None
mailingAddr/person/leadstatusRank	None
mailingAddr/person/personDeletedDate	None
mailingAddr/person/hasCompany	None
mailingAddr/person/isProjectMember	None
mailingAddr/person/isStakeholder	None
mailingAddr/person/updatedByWorkflow	None
mailingAddr/person/whenUpdatedByWorkflow	None
mailingAddr/person/createdByForm	None
mailingAddr/person/phone/formattedNumber	None
mailingAddr/person/personDirectPhone/formattedNumber	None
mailingAddr/person/personDirectPhone/description	None
mailingAddr/person/personMobilePhone/formattedNumber	None
mailingAddr/person/personMobilePhone/description	None
mailingAddr/person/personPrivate/formattedNumber	None
mailingAddr/person/personPrivate/description	None
mailingAddr/person/personPager/formattedNumber	None
mailingAddr/person/personPager/description	None
mailingAddr/person/personDirectFax/formattedNumber	None
mailingAddr/person/personDirectFax/description	None
mailingAddr/person/searchPhone/formattedNumber	None
mailingAddr/person/searchPhone/description	None
mailingAddr/person/personInfo/textId	None
mailingAddr/person/personInfo/infoText	None
mailingAddr/person/email/emailProtocol	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
mailingAddr/person/email/emailAddress	None
mailingAddr/person/email/emailDescription	None
mailingAddr/person/email/emailId	None
mailingAddr/person/email/emailLastSent	None
mailingAddr/person/email/emailBounceCount	None
mailingAddr/person/email/emailLastBounce	None
mailingAddr/person/email/emailHasBounced	None
mailingAddr/person/personUrl/URLAddress	None
mailingAddr/person/personUrl/URLDescription	None
mailingAddr/person/personAddress/addressId	None
mailingAddr/person/personAddress/line1	None
mailingAddr/person/personAddress/line2	None
mailingAddr/person/personAddress/line3	None
mailingAddr/person/personAddress/county	None
mailingAddr/person/personAddress/city	None
mailingAddr/person/personAddress/zip	None
mailingAddr/person/personAddress/state	None
mailingAddr/person/personAddress/wgs84latitude	None
mailingAddr/person/personAddress/wgs84longitude	None
mailingAddr/person/personAddress/formattedAddress	None
mailingAddr/person/personAddress/formattedMultiLineAddress	None
mailingAddr/person/restrictionAddress/addressId	None
mailingAddr/person/restrictionAddress/line1	None
mailingAddr/person/restrictionAddress/line2	None
mailingAddr/person/restrictionAddress/line3	None
mailingAddr/person/restrictionAddress/county	None
mailingAddr/person/restrictionAddress/city	None
mailingAddr/person/restrictionAddress/zip	None
mailingAddr/person/restrictionAddress/state	None
mailingAddr/person/restrictionAddress/wgs84latitude	None
mailingAddr/person/restrictionAddress/wgs84longitude	None
mailingAddr/person/restrictionAddress/formattedAddress	None
mailingAddr/person/restrictionAddress/formattedMultiLineAddress	None
mailingAddr/person/personInterestIds	None
mailingAddr/person/personUdef/SuperOffice:1	None
mailingAddr/person/personUdef/SuperOffice:2	None
mailingAddr/person/personUdef/SuperOffice:3	None
mailingAddr/person/personUdef/SuperOffice:4	None
mailingAddr/person/personUdef/SuperOffice:5	None
mailingAddr/person/personUdef/SuperOffice:6	None
mailingAddr/person/personUdef/SuperOffice:7	None
mailingAddr/person/personUdef/SuperOffice:8	None
mailingAddr/person/personUdef/SuperOffice:9	None
mailingAddr/person/personUdef/SuperOffice:10	None
mailingAddr/person/personUdef/SuperOffice:11	None
mailingAddr/person/personExtra/x_person_integer	None
mailingAddr/person/personExtra/x_person_hidden_integer	None
mailingAddr/person/personExtra/x_person_float	None
mailingAddr/person/personExtra/x_person_longtext	None
mailingAddr/person/personExtra/x_person_date	None
mailingAddr/person/personExtra/x_person_datetime	None
mailingAddr/person/personExtra/x_person_time	None
mailingAddr/person/personExtra/x_person_boolean	None
mailingAddr/person/personExtra/x_person_timespan	None
mailingAddr/person/personExtra/x_person_shorttext	None
mailingAddr/person/personExtra/x_person_shorttext_list	None
mailingAddr/person/personExtra/x_person_user_relation	None
mailingAddr/person/personExtra/x_person_category_relation	None
mailingAddr/person/personExtra/x_person_priority_relation	None
mailingAddr/person/personExtra/x_person_request_relation	None
mailingAddr/person/personExtra/x_person_appointment_relation	None
mailingAddr/person/personExtra/x_person_contact_relation	None
mailingAddr/person/personExtra/y_rental/id	None
mailingAddr/person/personExtra/y_rental/x_start	None
mailingAddr/person/personExtra/y_rental/x_end	None
mailingAddr/person/personExtra/y_rental/x_amount	None
mailingAddr/person/personExtra/y_rental/x_contact	None
mailingAddr/person/personExtra/y_rental/y_equipment/x_name	None
mailingAddr/person/personExtra/y_car/id	None
mailingAddr/person/personAssociate/firstName	None
mailingAddr/person/personAssociate/lastName	None
mailingAddr/person/personAssociate/middleName	None
mailingAddr/person/personAssociate/fullName	None
mailingAddr/person/personAssociate/contactId	None
mailingAddr/person/personAssociate/personId	None
mailingAddr/person/personAssociate/mrMrs	None
mailingAddr/person/personAssociate/title	None
mailingAddr/person/personAssociate/associateDbId	None
mailingAddr/person/personAssociate/contactName	None
mailingAddr/person/personAssociate/contactDepartment	None
mailingAddr/person/personAssociate/usergroup	None
mailingAddr/person/personAssociate/usergroupId	None
mailingAddr/person/personAssociate/contactFullName	None
mailingAddr/person/personAssociate/contactCategory	None
mailingAddr/person/personAssociate/role	None
mailingAddr/person/personAssociate/assocName	None
mailingAddr/person/personAssociate/assocTooltip	None
mailingAddr/person/personAssociate/assocType	None
mailingAddr/person/personAssociate/ejUserId	None
mailingAddr/person/personAssociate/simultaneousEjUser	None
mailingAddr/person/personAssociate/ejDisplayName	None
mailingAddr/person/personAssociate/ejStatus	None
mailingAddr/person/personAssociate/credentialType	None
mailingAddr/person/personAssociate/credentialDisplayValue	None
mailingAddr/person/personAssociate/isActive	None
mailingAddr/person/personAssociate/isActiveText	None
mailingAddr/person/personAssociate/portraitThumbnail	None
mailingAddr/person/personAssociate/otherGroups	None
mailingAddr/person/personAssociate/userName	None
mailingAddr/person/personAssociate/personEmail	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
mailingAddr/person/personAssociate/locationAddress	None
mailingAddr/person/personAssociate/isLocation	None
mailingAddr/person/correspondingAssociate/firstName	None
mailingAddr/person/correspondingAssociate/lastName	None
mailingAddr/person/correspondingAssociate/middleName	None
mailingAddr/person/correspondingAssociate/fullName	None
mailingAddr/person/correspondingAssociate/contactId	None
mailingAddr/person/correspondingAssociate/personId	None
mailingAddr/person/correspondingAssociate/mrMrs	None
mailingAddr/person/correspondingAssociate/title	None
mailingAddr/person/correspondingAssociate/associateDbId	None
mailingAddr/person/correspondingAssociate/contactName	None
mailingAddr/person/correspondingAssociate/contactDepartment	None
mailingAddr/person/correspondingAssociate/usergroup	None
mailingAddr/person/correspondingAssociate/usergroupId	None
mailingAddr/person/correspondingAssociate/contactFullName	None
mailingAddr/person/correspondingAssociate/contactCategory	None
mailingAddr/person/correspondingAssociate/role	None
mailingAddr/person/correspondingAssociate/assocName	None
mailingAddr/person/correspondingAssociate/assocTooltip	None
mailingAddr/person/correspondingAssociate/assocType	None
mailingAddr/person/correspondingAssociate/ejUserId	None
mailingAddr/person/correspondingAssociate/simultaneousEjUser	None
mailingAddr/person/correspondingAssociate/ejDisplayName	None
mailingAddr/person/correspondingAssociate/ejStatus	None
mailingAddr/person/correspondingAssociate/credentialType	None
mailingAddr/person/correspondingAssociate/credentialDisplayValue	None
mailingAddr/person/correspondingAssociate/isActive	None
mailingAddr/person/correspondingAssociate/isActiveText	None
mailingAddr/person/correspondingAssociate/portraitThumbnail	None
mailingAddr/person/correspondingAssociate/otherGroups	None
mailingAddr/person/correspondingAssociate/userName	None
mailingAddr/person/correspondingAssociate/personEmail	None
mailingAddr/person/correspondingAssociate/locationAddress	None
mailingAddr/person/correspondingAssociate/isLocation	None
mailingAddr/person/isMailingRecipient	None
mailingAddr/person/hasStoreConsent	None
mailingAddr/person/withdrawnStoreConsent	None
mailingAddr/person/hasEmarketingConsent	None
mailingAddr/person/withdrawnEmarketingConsent	None
mailingAddr/person/subscription	None
mailingAddr/person/legalBaseStore	None
mailingAddr/person/legalBaseEmarketing	None
mailingAddr/person/consentSourceStore	None
mailingAddr/person/consentSourceEmarketing	None
associate/firstName	None
associate/lastName	None
associate/middleName	None
associate/fullName	None
associate/contactId	None
associate/personId	None
associate/mrMrs	None
associate/title	None
associate/associateDbId	None
associate/contactName	None
associate/contactDepartment	None
associate/usergroup	None
associate/usergroupId	None
associate/contactFullName	None
associate/contactCategory	None
associate/role	None
associate/assocName	None
associate/assocTooltip	None
associate/assocType	None
associate/ejUserId	None
associate/simultaneousEjUser	None
associate/ejDisplayName	None
associate/ejStatus	None
associate/credentialType	None
associate/credentialDisplayValue	None
associate/isActive	None
associate/isActiveText	None
associate/portraitThumbnail	None
associate/otherGroups	None
associate/userName	None
associate/personEmail	None
associate/locationAddress	None
associate/isLocation	None
emailFlow/emailFlowId	None
emailFlow/emailFlowHierarchyId	None
emailFlow/shipmentType	None
emailFlow/overrideConsentSubscription	None
emailFlow/thumbnail	None
emailFlow/mediumThumbnail	None
emailFlow/workflowId	None
emailFlow/workflowName	None
emailFlow/workflowDescription	None
emailFlow/workflowDefinitionStatus	None
emailFlow/workflowDefinitionStatusId	None
emailFlow/jumpToFinish	None
emailFlow/startOnlyOnce	None
emailFlow/workflowEnrolledCount	None
emailFlow/workflowInProgressCount	None
emailFlow/workflowCompletedCount	None
emailFlow/workflowSucceededCount	None
emailFlow/workflowSuccessRate	None
emailFlow/updatedBy	None
emailFlow/updatedDate	None
emailFlow/registeredBy	None
emailFlow/registeredDate	None

Supported Columns (cont.)

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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
project/projectAssociate/portraitThumbnail	None
project/projectAssociate/otherGroups	None
project/projectAssociate/userName	None
project/projectAssociate/personEmail	None
project/projectAssociate/locationAddress	None
project/projectAssociate/isLocation	None
project/projectUdef/SuperOffice:1	None
project/projectUdef/SuperOffice:2	None
project/projectUdef/SuperOffice:3	None
project/projectUdef/SuperOffice:4	None
project/projectUdef/SuperOffice:5	None
project/projectUdef/SuperOffice:6	None
project/projectUdef/SuperOffice:7	None
project/projectUdef/SuperOffice:8	None
project/projectUdef/SuperOffice:9	None
project/projectUdef/SuperOffice:10	None
project/NumberOfActivities	None
project/NumberOfActivitiesInPeriod	None
project/NumberOfNotCompletedActivities	None
project/NumberOfNotCompletedActivitiesInPeriod	None
project/LastActivity	None
project/LastCompletedActivity	None
project/LastDoByActivity	None
project/NumberOfSales	None
project/NumberOfSalesInPeriod	None
project/NumberOfNotCompletedSales	None
project/NumberOfNotCompletedSalesInPeriod	None
project/LastSale	None
project/LastCompletedSale	None
project/LastDoBySale	None
project/SaintStatus3	None
project/saintSaleStatus	None
project/saintAmountClass	None
project/saintActivityType	None
project/saintDirection	None
project/saintIntention	None
project/saintTicketStatus	None
project/saintTicketCategory	None
project/project/textId	None
project/project/infoText	None
historyRank	None

Sample

GET /api/v1/archive/MailingsAndFolders?$select=mailingAddr/person/personUpdatedBy,mailingAddr/person/personAddress/county,mailingAddr/person/personExtra/y_rental/id,mailingAddr/person/correspondingAssociate/usergroup,emailFlow/workflowCompletedCount
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv