“emailpersonaddress”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.EmailPersonAddressProvider inside NetServer’s SODatabase assembly. Person subchannel for special purpose archive provider used to search for email addresses. This channel will match on either the email address itself, or person.firstname or person.lastname The resulting rows will have entity name ‘contact’, but the primary key will always be the email_id.Supported Entities
| Name | Description |
|---|---|
| ”email" | |
| "person” |
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 | int | x | |
| firstName | string | x | |
| lastName | string | x | |
| middleName | string | x | |
| fullName | string | x | |
| fullNameWithContact | None | x | |
| contactId | int | x | |
| hasInfoText | bool | x | |
| hasInterests | bool | x | |
| personHasInterests | bool | x | |
| mrMrs | string | x | |
| position | listAny | x | |
| personNumber | string | x | |
| title | string | x | |
| personCountry | listAny | x | |
| personCountryId | int | x | |
| personNoMail | bool | x | |
| rank | int | x | |
| birthdate | None | ||
| associateType | None | ||
| useAsMailingAddress | bool | x | |
| personSource | listAny | x | |
| retired | bool | x | |
| birthYear | int | x | |
| birthMonth | int | x | |
| birthDay | int | x | |
| kanaFirstName | string | x | |
| kanaLastName | string | x | |
| personUpdatedBy | associate | x | |
| personUpdatedByFullName | associate | x | |
| personUpdatedDate | date | x | |
| personRegisteredBy | associate | x | |
| personRegisteredByFullName | associate | x | |
| personRegisteredDate | date | x | |
| portraitThumbnail | None | ||
| personActiveErpLinks | bool | x | |
| personSourcedFrom | string | x | |
| personLinkedinUrl | string | x | |
| ticketPriority | listAny | x | |
| supportLanguage | listAny | x | |
| supportAssociate | associate | x | |
| supportAssociateFullName | associate | x | |
| personAssociateId | associate | x | |
| personAssociateFullName | associate | x | |
| personCategory | listAny | x | |
| personCategoryGroup | listAny | x | |
| personCategoryRank | int | x | |
| personBusiness | listAny | x | |
| leadStatus | listAny | x | |
| leadstatusRank | int | x | |
| personDeletedDate | datetime | ||
| hasCompany | bool | x | |
| isProjectMember | bool | x | |
| isStakeholder | bool | x | |
| updatedByWorkflow | listAny | x | |
| whenUpdatedByWorkflow | datetime | x | |
| createdByForm | listAny | x | |
| phone/formattedNumber | string | ||
| who | None | x | |
| personDirectPhone/formattedNumber | string | ||
| personDirectPhone/description | string | x | |
| personMobilePhone/formattedNumber | string | ||
| personMobilePhone/description | string | x | |
| personPrivate/formattedNumber | string | ||
| personPrivate/description | string | x | |
| personPager/formattedNumber | string | ||
| personPager/description | string | x | |
| personDirectFax/formattedNumber | string | ||
| personDirectFax/description | string | x | |
| personAddress/addressId | int | x | |
| personAddress/line1 | string | x | |
| personAddress/line2 | string | x | |
| personAddress/line3 | string | x | |
| personAddress/county | string | x | |
| personAddress/city | string | x | |
| personAddress/zip | string | x | |
| personAddress/state | string | x | |
| personAddress/wgs84latitude | decimal | x | |
| personAddress/wgs84longitude | decimal | x | |
| personAddress/formattedAddress | None | ||
| personAddress/formattedMultiLineAddress | None | ||
| personContact/contactId | int | x | |
| personContact/name | stringorPK | x | |
| personContact/department | string | x | |
| personContact/nameDepartment | string | x | |
| personContact/hasInfoText | bool | x | |
| personContact/hasInterests | bool | x | |
| personContact/associateId | associate | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personContact/category | listAny | x | |
| personContact/categoryGroup | listAny | x | |
| personContact/companyCategoryRank | int | x | |
| personContact/business | listAny | x | |
| personContact/country | listAny | x | |
| personContact/countryId | int | x | |
| personContact/number | string | x | |
| personContact/code | string | x | |
| personContact/orgnr | string | x | |
| personContact/stop | bool | x | |
| personContact/contactNoMail | bool | x | |
| personContact/updatedBy | associate | x | |
| personContact/updatedByFullName | associate | x | |
| personContact/updatedDate | date | x | |
| personContact/registeredBy | associate | x | |
| personContact/registeredByFullName | associate | x | |
| personContact/registeredDate | date | x | |
| personContact/contactSource | listAny | x | |
| personContact/contactDeleted | bool | x | |
| personContact/phone/formattedNumber | string | ||
| personContact/activeErpLinks | bool | x | |
| personContact/numEmployees | int | x | |
| personContact/yearFounded | int | x | |
| personContact/revenueYear | int | x | |
| personContact/revenueBasecurrency | decimal | x | |
| personContact/sharecapitalBasecurrency | decimal | x | |
| personContact/sourcedFrom | string | x | |
| personContact/linkedinUrl | string | x | |
| personContact/deletedDate | datetime | ||
| personContact/mainContact | None | x | |
| personContact/forceCompany | bool | ||
| personContact/contactPhone/formattedNumber | string | ||
| personContact/contactPhone/description | string | x | |
| personContact/postAddress/addressId | int | x | |
| personContact/postAddress/line1 | string | x | |
| personContact/postAddress/line2 | string | x | |
| personContact/postAddress/line3 | string | x | |
| personContact/postAddress/county | string | x | |
| personContact/postAddress/city | string | x | |
| personContact/postAddress/zip | string | x | |
| personContact/postAddress/state | string | x | |
| personContact/postAddress/wgs84latitude | decimal | x | |
| personContact/postAddress/wgs84longitude | decimal | x | |
| personContact/postAddress/formattedAddress | None | ||
| personContact/postAddress/formattedMultiLineAddress | None | ||
| personContact/streetAddress/addressId | int | x | |
| personContact/streetAddress/line1 | string | x | |
| personContact/streetAddress/line2 | string | x | |
| personContact/streetAddress/line3 | string | x | |
| personContact/streetAddress/county | string | x | |
| personContact/streetAddress/city | string | x | |
| personContact/streetAddress/zip | string | x | |
| personContact/streetAddress/state | string | x | |
| personContact/streetAddress/wgs84latitude | decimal | x | |
| personContact/streetAddress/wgs84longitude | decimal | x | |
| personContact/streetAddress/formattedAddress | None | ||
| personContact/streetAddress/formattedMultiLineAddress | None | ||
| personContact/restrictionAddress/addressId | int | x | |
| personContact/restrictionAddress/line1 | string | x | |
| personContact/restrictionAddress/line2 | string | x | |
| personContact/restrictionAddress/line3 | string | x | |
| personContact/restrictionAddress/county | string | x | |
| personContact/restrictionAddress/city | string | x | |
| personContact/restrictionAddress/zip | string | x | |
| personContact/restrictionAddress/state | string | x | |
| personContact/restrictionAddress/wgs84latitude | decimal | x | |
| personContact/restrictionAddress/wgs84longitude | decimal | x | |
| personContact/restrictionAddress/formattedAddress | None | ||
| personContact/restrictionAddress/formattedMultiLineAddress | None |
Sample
GET /api/v1/archive/emailpersonaddress?$select=personContact/numEmployees,personCategoryGroup,personAddress/county
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv