“EmailAddress”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.EMailAddressProvider inside NetServer’s SODatabase assembly. Special purpose archive provider used to search for email addresses. This provider combines two subchannels, one for Person and one for Contact related addresses. Each channel will match on either the email address itself, or some relevant naming information (such as contact name or person name or whatever). The resulting rows will have entity names reflecting the type of match, but the primary key will always be the email_id.Supported Entities
| Name | Description |
|---|---|
| ”email" | |
| "person" | |
| "contact” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | ||
| getNoRows | bool | ||
| emailMatch | string | ||
| emailProtocol | string | x | |
| emailAddress | string | x | |
| emailDescription | string | x | |
| emailId | int | x | |
| emailLastSent | datetime | x | |
| emailBounceCount | int | x | |
| emailLastBounce | datetime | x | |
| emailHasBounced | bool | x | |
| personId | None | ||
| firstName | None | ||
| lastName | None | ||
| middleName | None | ||
| fullName | None | ||
| fullNameWithContact | None | ||
| contactId | int | x | |
| hasInfoText | bool | x | |
| hasInterests | bool | x | |
| personHasInterests | None | ||
| mrMrs | None | ||
| position | None | ||
| personNumber | None | ||
| title | None | ||
| personCountry | None | ||
| personCountryId | None | ||
| personNoMail | None | ||
| rank | None | ||
| birthdate | None | ||
| associateType | None | ||
| useAsMailingAddress | None | ||
| personSource | None | ||
| retired | None | ||
| birthYear | None | ||
| birthMonth | None | ||
| birthDay | None | ||
| kanaFirstName | None | ||
| kanaLastName | None | ||
| personUpdatedBy | None | ||
| personUpdatedByFullName | None | ||
| personUpdatedDate | None | ||
| personRegisteredBy | None | ||
| personRegisteredByFullName | None | ||
| personRegisteredDate | None | ||
| portraitThumbnail | None | ||
| personActiveErpLinks | None | ||
| personSourcedFrom | None | ||
| personLinkedinUrl | None | ||
| ticketPriority | None | ||
| supportLanguage | None | ||
| supportAssociate | None | ||
| supportAssociateFullName | None | ||
| personAssociateId | None | ||
| personAssociateFullName | None | ||
| personCategory | None | ||
| personCategoryGroup | None | ||
| personCategoryRank | None | ||
| personBusiness | None | ||
| leadStatus | None | ||
| leadstatusRank | None | ||
| personDeletedDate | None | ||
| hasCompany | None | ||
| isProjectMember | None | ||
| isStakeholder | None | ||
| updatedByWorkflow | None | ||
| whenUpdatedByWorkflow | None | ||
| createdByForm | None | ||
| phone/formattedNumber | string | ||
| who | None | x | |
| personDirectPhone/formattedNumber | None | ||
| personDirectPhone/description | None | ||
| personMobilePhone/formattedNumber | None | ||
| personMobilePhone/description | None | ||
| personPrivate/formattedNumber | None | ||
| personPrivate/description | None | ||
| personPager/formattedNumber | None | ||
| personPager/description | None | ||
| personDirectFax/formattedNumber | None | ||
| personDirectFax/description | None | ||
| personAddress/addressId | None | ||
| personAddress/line1 | None | ||
| personAddress/line2 | None | ||
| personAddress/line3 | None | ||
| personAddress/county | None | ||
| personAddress/city | None | ||
| personAddress/zip | None | ||
| personAddress/state | None | ||
| personAddress/wgs84latitude | None | ||
| personAddress/wgs84longitude | None | ||
| personAddress/formattedAddress | None | ||
| personAddress/formattedMultiLineAddress | None | ||
| personContact/contactId | None | ||
| personContact/name | None | ||
| personContact/department | None | ||
| personContact/nameDepartment | None | ||
| personContact/hasInfoText | None | ||
| personContact/hasInterests | None | ||
| personContact/associateId | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personContact/category | None | ||
| personContact/categoryGroup | None | ||
| personContact/companyCategoryRank | None | ||
| personContact/business | None | ||
| personContact/country | None | ||
| personContact/countryId | None | ||
| personContact/number | None | ||
| personContact/code | None | ||
| personContact/orgnr | None | ||
| personContact/stop | None | ||
| personContact/contactNoMail | None | ||
| personContact/updatedBy | None | ||
| personContact/updatedByFullName | None | ||
| personContact/updatedDate | None | ||
| personContact/registeredBy | None | ||
| personContact/registeredByFullName | None | ||
| personContact/registeredDate | None | ||
| personContact/contactSource | None | ||
| personContact/contactDeleted | None | ||
| personContact/phone/formattedNumber | None | ||
| personContact/activeErpLinks | None | ||
| personContact/numEmployees | None | ||
| personContact/yearFounded | None | ||
| personContact/revenueYear | None | ||
| personContact/revenueBasecurrency | None | ||
| personContact/sharecapitalBasecurrency | None | ||
| personContact/sourcedFrom | None | ||
| personContact/linkedinUrl | None | ||
| personContact/deletedDate | None | ||
| personContact/mainContact | None | ||
| personContact/forceCompany | None | ||
| personContact/contactPhone/formattedNumber | None | ||
| personContact/contactPhone/description | None | ||
| personContact/postAddress/addressId | None | ||
| personContact/postAddress/line1 | None | ||
| personContact/postAddress/line2 | None | ||
| personContact/postAddress/line3 | None | ||
| personContact/postAddress/county | None | ||
| personContact/postAddress/city | None | ||
| personContact/postAddress/zip | None | ||
| personContact/postAddress/state | None | ||
| personContact/postAddress/wgs84latitude | None | ||
| personContact/postAddress/wgs84longitude | None | ||
| personContact/postAddress/formattedAddress | None | ||
| personContact/postAddress/formattedMultiLineAddress | None | ||
| personContact/streetAddress/addressId | None | ||
| personContact/streetAddress/line1 | None | ||
| personContact/streetAddress/line2 | None | ||
| personContact/streetAddress/line3 | None | ||
| personContact/streetAddress/county | None | ||
| personContact/streetAddress/city | None | ||
| personContact/streetAddress/zip | None | ||
| personContact/streetAddress/state | None | ||
| personContact/streetAddress/wgs84latitude | None | ||
| personContact/streetAddress/wgs84longitude | None | ||
| personContact/streetAddress/formattedAddress | None | ||
| personContact/streetAddress/formattedMultiLineAddress | None | ||
| personContact/restrictionAddress/addressId | None | ||
| personContact/restrictionAddress/line1 | None | ||
| personContact/restrictionAddress/line2 | None | ||
| personContact/restrictionAddress/line3 | None | ||
| personContact/restrictionAddress/county | None | ||
| personContact/restrictionAddress/city | None | ||
| personContact/restrictionAddress/zip | None | ||
| personContact/restrictionAddress/state | None | ||
| personContact/restrictionAddress/wgs84latitude | None | ||
| personContact/restrictionAddress/wgs84longitude | None | ||
| personContact/restrictionAddress/formattedAddress | None | ||
| personContact/restrictionAddress/formattedMultiLineAddress | None | ||
| name | None | ||
| department | None | ||
| nameDepartment | None | ||
| associateId | None | ||
| category | None | ||
| categoryGroup | None | ||
| companyCategoryRank | None | ||
| business | None | ||
| country | None | ||
| countryId | None | ||
| number | None | ||
| code | None | ||
| orgnr | None | ||
| stop | None | ||
| contactNoMail | None | ||
| updatedBy | None | ||
| updatedByFullName | None | ||
| updatedDate | None | ||
| registeredBy | None | ||
| registeredByFullName | None | ||
| registeredDate | None | ||
| contactSource | None | ||
| contactDeleted | None | ||
| activeErpLinks | None | ||
| numEmployees | None | ||
| yearFounded | None | ||
| revenueYear | None | ||
| revenueBasecurrency | None | ||
| sharecapitalBasecurrency | None | ||
| sourcedFrom | None | ||
| linkedinUrl | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| deletedDate | None | ||
| mainContact | None | ||
| forceCompany | None | ||
| contactPhone/formattedNumber | None | ||
| contactPhone/description | None | ||
| contactFax/formattedNumber | None | ||
| contactFax/description | None | ||
| searchPhone/formattedNumber | None | ||
| searchPhone/description | None | ||
| email/emailProtocol | None | ||
| email/emailAddress | None | ||
| email/emailDescription | None | ||
| email/emailId | None | ||
| email/emailLastSent | None | ||
| email/emailBounceCount | None | ||
| email/emailLastBounce | None | ||
| email/emailHasBounced | None | ||
| postAddress/addressId | None | ||
| postAddress/line1 | None | ||
| postAddress/line2 | None | ||
| postAddress/line3 | None | ||
| postAddress/county | None | ||
| postAddress/city | None | ||
| postAddress/zip | None | ||
| postAddress/state | None | ||
| postAddress/wgs84latitude | None | ||
| postAddress/wgs84longitude | None | ||
| postAddress/formattedAddress | None | ||
| postAddress/formattedMultiLineAddress | None | ||
| restrictionPostalAddress/addressId | None | ||
| restrictionPostalAddress/line1 | None | ||
| restrictionPostalAddress/line2 | None | ||
| restrictionPostalAddress/line3 | None | ||
| restrictionPostalAddress/county | None | ||
| restrictionPostalAddress/city | None | ||
| restrictionPostalAddress/zip | None | ||
| restrictionPostalAddress/state | None | ||
| restrictionPostalAddress/wgs84latitude | None | ||
| restrictionPostalAddress/wgs84longitude | None | ||
| restrictionPostalAddress/formattedAddress | None | ||
| restrictionPostalAddress/formattedMultiLineAddress | None | ||
| streetAddress/addressId | None | ||
| streetAddress/line1 | None | ||
| streetAddress/line2 | None | ||
| streetAddress/line3 | None | ||
| streetAddress/county | None | ||
| streetAddress/city | None | ||
| streetAddress/zip | None | ||
| streetAddress/state | None | ||
| streetAddress/wgs84latitude | None | ||
| streetAddress/wgs84longitude | None | ||
| streetAddress/formattedAddress | None | ||
| streetAddress/formattedMultiLineAddress | None | ||
| restrictionAddress/addressId | None | ||
| restrictionAddress/line1 | None | ||
| restrictionAddress/line2 | None | ||
| restrictionAddress/line3 | None | ||
| restrictionAddress/county | None | ||
| restrictionAddress/city | None | ||
| restrictionAddress/zip | None | ||
| restrictionAddress/state | None | ||
| restrictionAddress/wgs84latitude | None | ||
| restrictionAddress/wgs84longitude | None | ||
| restrictionAddress/formattedAddress | None | ||
| restrictionAddress/formattedMultiLineAddress | None | ||
| url/URLAddress | None | ||
| url/URLDescription | None | ||
| contactAssociate/firstName | None | ||
| contactAssociate/lastName | None | ||
| contactAssociate/middleName | None | ||
| contactAssociate/fullName | None | ||
| contactAssociate/contactId | None | ||
| contactAssociate/personId | None | ||
| contactAssociate/mrMrs | None | ||
| contactAssociate/title | None | ||
| contactAssociate/associateDbId | None | ||
| contactAssociate/contactName | None | ||
| contactAssociate/contactDepartment | None | ||
| contactAssociate/usergroup | None | ||
| contactAssociate/usergroupId | None | ||
| contactAssociate/contactFullName | None | ||
| contactAssociate/contactCategory | None | ||
| contactAssociate/role | None | ||
| contactAssociate/assocName | None | ||
| contactAssociate/assocTooltip | None | ||
| contactAssociate/assocType | None | ||
| contactAssociate/ejUserId | None | ||
| contactAssociate/simultaneousEjUser | None | ||
| contactAssociate/ejDisplayName | None | ||
| contactAssociate/ejStatus | None | ||
| contactAssociate/credentialType | None | ||
| contactAssociate/credentialDisplayValue | None | ||
| contactAssociate/isActive | None | ||
| contactAssociate/isActiveText | None | ||
| contactAssociate/portraitThumbnail | None | ||
| contactAssociate/otherGroups | None | ||
| contactAssociate/userName | None | ||
| contactAssociate/personEmail | None | ||
| contactAssociate/locationAddress | None | ||
| contactAssociate/isLocation | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| contactSupportAssociate/firstName | None | ||
| contactSupportAssociate/lastName | None | ||
| contactSupportAssociate/middleName | None | ||
| contactSupportAssociate/fullName | None | ||
| contactSupportAssociate/contactId | None | ||
| contactSupportAssociate/personId | None | ||
| contactSupportAssociate/mrMrs | None | ||
| contactSupportAssociate/title | None | ||
| contactSupportAssociate/associateDbId | None | ||
| contactSupportAssociate/contactName | None | ||
| contactSupportAssociate/contactDepartment | None | ||
| contactSupportAssociate/usergroup | None | ||
| contactSupportAssociate/usergroupId | None | ||
| contactSupportAssociate/contactFullName | None | ||
| contactSupportAssociate/contactCategory | None | ||
| contactSupportAssociate/role | None | ||
| contactSupportAssociate/assocName | None | ||
| contactSupportAssociate/assocTooltip | None | ||
| contactSupportAssociate/assocType | None | ||
| contactSupportAssociate/ejUserId | None | ||
| contactSupportAssociate/simultaneousEjUser | None | ||
| contactSupportAssociate/ejDisplayName | None | ||
| contactSupportAssociate/ejStatus | None | ||
| contactSupportAssociate/credentialType | None | ||
| contactSupportAssociate/credentialDisplayValue | None | ||
| contactSupportAssociate/isActive | None | ||
| contactSupportAssociate/isActiveText | None | ||
| contactSupportAssociate/portraitThumbnail | None | ||
| contactSupportAssociate/otherGroups | None | ||
| contactSupportAssociate/userName | None | ||
| contactSupportAssociate/personEmail | None | ||
| contactSupportAssociate/locationAddress | None | ||
| contactSupportAssociate/isLocation | None | ||
| contactSupportPerson/personId | None | ||
| contactSupportPerson/firstName | None | ||
| contactSupportPerson/lastName | None | ||
| contactSupportPerson/middleName | None | ||
| contactSupportPerson/fullName | None | ||
| contactSupportPerson/contactId | None | ||
| contactSupportPerson/hasInfoText | None | ||
| contactSupportPerson/hasInterests | None | ||
| contactSupportPerson/personHasInterests | None | ||
| contactSupportPerson/mrMrs | None | ||
| contactSupportPerson/position | None | ||
| contactSupportPerson/personNumber | None | ||
| contactSupportPerson/title | None | ||
| contactSupportPerson/personCountry | None | ||
| contactSupportPerson/personCountryId | None | ||
| contactSupportPerson/personNoMail | None | ||
| contactSupportPerson/rank | None | ||
| contactSupportPerson/birthdate | None | ||
| contactSupportPerson/associateType | None | ||
| contactSupportPerson/useAsMailingAddress | None | ||
| contactSupportPerson/personSource | None | ||
| contactSupportPerson/retired | None | ||
| contactSupportPerson/birthYear | None | ||
| contactSupportPerson/birthMonth | None | ||
| contactSupportPerson/birthDay | None | ||
| contactSupportPerson/kanaFirstName | None | ||
| contactSupportPerson/kanaLastName | None | ||
| contactSupportPerson/personUpdatedBy | None | ||
| contactSupportPerson/personUpdatedByFullName | None | ||
| contactSupportPerson/personUpdatedDate | None | ||
| contactSupportPerson/personRegisteredBy | None | ||
| contactSupportPerson/personRegisteredByFullName | None | ||
| contactSupportPerson/personRegisteredDate | None | ||
| contactSupportPerson/portraitThumbnail | None | ||
| contactSupportPerson/personActiveErpLinks | None | ||
| contactSupportPerson/personSourcedFrom | None | ||
| contactSupportPerson/personLinkedinUrl | None | ||
| contactSupportPerson/ticketPriority | None | ||
| contactSupportPerson/supportLanguage | None | ||
| contactSupportPerson/supportAssociate | None | ||
| contactSupportPerson/supportAssociateFullName | None | ||
| contactSupportPerson/personAssociateId | None | ||
| contactSupportPerson/personAssociateFullName | None | ||
| contactSupportPerson/personCategory | None | ||
| contactSupportPerson/personCategoryGroup | None | ||
| contactSupportPerson/personCategoryRank | None | ||
| contactSupportPerson/personBusiness | None | ||
| contactSupportPerson/leadStatus | None | ||
| contactSupportPerson/leadstatusRank | None | ||
| contactSupportPerson/personDeletedDate | None | ||
| contactSupportPerson/hasCompany | None | ||
| contactSupportPerson/isProjectMember | None | ||
| contactSupportPerson/isStakeholder | None | ||
| contactSupportPerson/updatedByWorkflow | None | ||
| contactSupportPerson/whenUpdatedByWorkflow | None | ||
| contactSupportPerson/createdByForm | None | ||
| contactSupportPerson/who | None | ||
| contactSupportPerson/personInfo/textId | None | ||
| contactSupportPerson/personInfo/infoText | None | ||
| contactSupportPerson/personUdef/SuperOffice:1 | None | ||
| contactSupportPerson/personUdef/SuperOffice:2 | None | ||
| contactSupportPerson/personUdef/SuperOffice:3 | None | ||
| contactSupportPerson/personUdef/SuperOffice:4 | None | ||
| contactSupportPerson/personUdef/SuperOffice:5 | None | ||
| contactSupportPerson/personUdef/SuperOffice:6 | None | ||
| contactSupportPerson/personUdef/SuperOffice:7 | None | ||
| contactSupportPerson/personUdef/SuperOffice:8 | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| contactSupportPerson/personUdef/SuperOffice:9 | None | ||
| contactSupportPerson/personUdef/SuperOffice:10 | None | ||
| contactSupportPerson/personUdef/SuperOffice:11 | None | ||
| contactSupportPerson/personExtra/x_person_integer | None | ||
| contactSupportPerson/personExtra/x_person_hidden_integer | None | ||
| contactSupportPerson/personExtra/x_person_float | None | ||
| contactSupportPerson/personExtra/x_person_longtext | None | ||
| contactSupportPerson/personExtra/x_person_date | None | ||
| contactSupportPerson/personExtra/x_person_datetime | None | ||
| contactSupportPerson/personExtra/x_person_time | None | ||
| contactSupportPerson/personExtra/x_person_boolean | None | ||
| contactSupportPerson/personExtra/x_person_timespan | None | ||
| contactSupportPerson/personExtra/x_person_shorttext | None | ||
| contactSupportPerson/personExtra/x_person_shorttext_list | None | ||
| contactSupportPerson/personExtra/x_person_user_relation | None | ||
| contactSupportPerson/personExtra/x_person_category_relation | None | ||
| contactSupportPerson/personExtra/x_person_priority_relation | None | ||
| contactSupportPerson/personExtra/x_person_request_relation | None | ||
| contactSupportPerson/personExtra/x_person_appointment_relation | None | ||
| contactSupportPerson/personExtra/x_person_contact_relation | None | ||
| contactSupportPerson/personExtra/y_rental/id | None | ||
| contactSupportPerson/personExtra/y_rental/x_start | None | ||
| contactSupportPerson/personExtra/y_rental/x_end | None | ||
| contactSupportPerson/personExtra/y_rental/x_amount | None | ||
| contactSupportPerson/personExtra/y_rental/x_contact | None | ||
| contactSupportPerson/personExtra/y_rental/y_equipment/x_name | None | ||
| contactSupportPerson/personExtra/y_car/id | None | ||
| contactSupportPerson/isMailingRecipient | None | ||
| contactSupportPerson/hasStoreConsent | None | ||
| contactSupportPerson/withdrawnStoreConsent | None | ||
| contactSupportPerson/hasEmarketingConsent | None | ||
| contactSupportPerson/withdrawnEmarketingConsent | None | ||
| contactSupportPerson/subscription | None | ||
| contactSupportPerson/legalBaseStore | None | ||
| contactSupportPerson/legalBaseEmarketing | None | ||
| contactSupportPerson/consentSourceStore | None | ||
| contactSupportPerson/consentSourceEmarketing | None | ||
| contactInterestIds | None | ||
| contactInfo/textId | None | ||
| contactInfo/infoText | None | ||
| contactUdef/SuperOffice:1 | None | ||
| contactUdef/SuperOffice:2 | None | ||
| contactUdef/SuperOffice:3 | None | ||
| contactUdef/SuperOffice:4 | None | ||
| contactUdef/SuperOffice:5 | None | ||
| contactUdef/SuperOffice:6 | None | ||
| contactUdef/SuperOffice:7 | None | ||
| contactUdef/SuperOffice:8 | None | ||
| contactUdef/SuperOffice:9 | None | ||
| contactUdef/SuperOffice:10 | None | ||
| contactUdef/SuperOffice:11 | None | ||
| contactUdef/SuperOffice:12 | None | ||
| contactUdef/SuperOffice:13 | None | ||
| contactExtra/x_contact_integer | None | ||
| contactExtra/x_contact_hidden_integer | None | ||
| contactExtra/x_contact_default_integer | None | ||
| contactExtra/x_contact_float | None | ||
| contactExtra/x_contact_longtext | None | ||
| contactExtra/x_contact_dropdown | None | ||
| contactExtra/x_contact_date | None | ||
| contactExtra/x_contact_datetime | None | ||
| contactExtra/x_contact_time | None | ||
| contactExtra/x_contact_boolean | None | ||
| contactExtra/x_contact_timespan | None | ||
| contactExtra/x_contact_shorttext | None | ||
| contactExtra/x_contact_short_dropdown | None | ||
| contactExtra/x_contact_contact_relation | None | ||
| contactExtra/x_contact_request_relation | None | ||
| contactExtra/x_contact_contact | None | ||
| contactExtra/y_organization/x_name | None | ||
| NumberOfActivities | None | ||
| NumberOfActivitiesInPeriod | None | ||
| NumberOfNotCompletedActivities | None | ||
| NumberOfNotCompletedActivitiesInPeriod | None | ||
| LastActivity | None | ||
| LastCompletedActivity | None | ||
| LastDoByActivity | None | ||
| NumberOfSales | None | ||
| NumberOfSalesInPeriod | None | ||
| NumberOfNotCompletedSales | None | ||
| NumberOfNotCompletedSalesInPeriod | None | ||
| LastSale | None | ||
| LastCompletedSale | None | ||
| LastDoBySale | None | ||
| NumberOfTickets | None | ||
| NumberOfTicketsInPeriod | None | ||
| NumberOfNotCompletedTickets | None | ||
| NumberOfNotCompletedTicketsInPeriod | None | ||
| LastTicket | None | ||
| LastCompletedTicket | None | ||
| LastDoByTicket | None | ||
| SaintStatus1 | None | ||
| SaintStatus2 | None | ||
| saintSaleStatus | None | ||
| saintAmountClass | None | ||
| saintActivityType | None | ||
| saintDirection | None | ||
| saintIntention | None | ||
| saintTicketStatus | None | ||
| saintTicketCategory | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| selectionMemberId | None | ||
| selectionIdRequest | None |
Sample
GET /api/v1/archive/EmailAddress?$select=emailLastSent,personAddress/zip,personContact/restrictionAddress/zip,orgnr,updatedDate
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv