> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.
# contactfavourites
## "contactfavourites"
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.ContactFavouritesProvider inside NetServer's SODatabase assembly.
## Supported Entities
| Name | Description |
| --------- | ----------------- |
| "contact" | Favourite company |
## Supported Columns
| Name | Restriction | Description | OrderBy |
| -------------------------------------------- | -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- |
| getAllRows | bool | GetAll: Get all rows of archive - use with care, you may be fetching the whole database | |
| getNoRows | bool | GetNone: Do not get any rows from the archive | |
| contactId | int | Company ID: Database ID of company | x |
| name | stringorPK | Company name | x |
| department | string | Department | x |
| nameDepartment | string | Company: Displays the company an activity is linked to | x |
| hasInfoText | bool | Has note: Displays an icon indicating if there is additional information available about the contact | x |
| hasInterests | bool | Has interests: Displays an Icon indicating if the contact has active interests | x |
| associateId | associate | Our contact: Displays our contact | x |
| category | listAny | Category | x |
| categoryGroup | listAny | Category group | x |
| companyCategoryRank | int | Category rank | x |
| business | listAny | Business | x |
| country | listAny | Country: This criterion corresponds to the Country field on the Company card. | x |
| countryId | int | Country ID: Country ID | x |
| number | string | Number | x |
| code | string | Code | x |
| orgnr | string | VAT No. | x |
| stop | bool | Stop | x |
| contactNoMail | bool | No mailings (company) | x |
| updatedBy | associate | Updated by: The user who last updated the data | x |
| updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| registeredBy | associate | Registered by: The user who registered the data | x |
| registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| contactSource | listAny | Source: Source (Company) | x |
| contactDeleted | bool | Deleted: Deleted | x |
| phone/formattedNumber | string | Phone : Displays phone number | |
| activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| deletedDate | datetime | Deleted date: Deleted date | |
| mainContact | *None* | Main contact: Main contact for this company | x |
| forceCompany | bool | Dummy: Dummy | |
| entityIcon | *None* | Row specific icon: Row specific icon | x |
| icon | *None* | Category: Displays the icon for an activity type | x |
| text | positiveString | Favourite: Displays a descriptive text for the item | x |
| favouriteAssociateId | associate | ID: Displays the login ID of the associate who owns the activity. | x |
| contactPhone/formattedNumber | string | Telephone - Phone: Displays phone number | |
| contactPhone/description | string | Telephone - Description: Phone number description | x |
| contactFax/formattedNumber | string | Fax - Phone: Displays phone number | |
| contactFax/description | string | Fax - Description: Phone number description | x |
| searchPhone/formattedNumber | string | Searchphone - Phone: Displays phone number | |
| searchPhone/description | string | Searchphone - Description: Phone number description | x |
| email/emailProtocol | string | Protocol: E-mail protocol, such as SMTP | x |
| email/emailAddress | string | E-mail | x |
| email/emailDescription | string | Description | x |
| email/emailId | int | ID | x |
| email/emailLastSent | datetime | Last sent: The date and time an e-mail was last sent to this address | x |
| email/emailBounceCount | int | Bounce count: Bounce count for this e-mail address | x |
| email/emailLastBounce | datetime | Last bounce: Date and time for last bounce to this e-mail address | x |
| email/emailHasBounced | bool | Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
| postAddress/addressId | int | Postal address - Address ID: Database ID for the address record | x |
| postAddress/line1 | string | Postal address - Address 1: First line of the address | x |
| postAddress/line2 | string | Postal address - Address 2: Second line of the address | x |
| postAddress/line3 | string | Postal address - Address 3: Third line of the address | x |
| postAddress/county | string | Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
| postAddress/city | string | Postal address - City: This criterion corresponds to the City field on the Company card. | x |
| postAddress/zip | string | Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| postAddress/state | string | Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
| postAddress/wgs84latitude | decimal | Postal address - Latitude: Latitude | x |
| postAddress/wgs84longitude | decimal | Postal address - Longitude: Longitude | x |
| postAddress/formattedAddress | *None* | Postal address - {formattedAddress}: {formattedAddress} | |
| postAddress/formattedMultiLineAddress | *None* | Postal address - {formattedAddress}: {formattedAddress} | |
| streetAddress/addressId | int | Street address - Address ID: Database ID for the address record | x |
| streetAddress/line1 | string | Street address - Address 1: First line of the address | x |
| streetAddress/line2 | string | Street address - Address 2: Second line of the address | x |
| streetAddress/line3 | string | Street address - Address 3: Third line of the address | x |
| streetAddress/county | string | Street address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
| streetAddress/city | string | Street address - City: This criterion corresponds to the City field on the Company card. | x |
| streetAddress/zip | string | Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| streetAddress/state | string | Street address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
| streetAddress/wgs84latitude | decimal | Street address - Latitude: Latitude | x |
| streetAddress/wgs84longitude | decimal | Street address - Longitude: Longitude | x |
| streetAddress/formattedAddress | *None* | Street address - {formattedAddress}: {formattedAddress} | |
| streetAddress/formattedMultiLineAddress | *None* | Street address - {formattedAddress}: {formattedAddress} | |
| restrictionAddress/addressId | int | Search address - Address ID: Database ID for the address record | x |
| restrictionAddress/line1 | string | Search address - Address 1: First line of the address | x |
| restrictionAddress/line2 | string | Search address - Address 2: Second line of the address | x |
| restrictionAddress/line3 | string | Search address - Address 3: Third line of the address | x |
| restrictionAddress/county | string | Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
| restrictionAddress/city | string | Search address - City: This criterion corresponds to the City field on the Company card. | x |
| restrictionAddress/zip | string | Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| restrictionAddress/state | string | Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
| restrictionAddress/wgs84latitude | decimal | Search address - Latitude: Latitude | x |
| restrictionAddress/wgs84longitude | decimal | Search address - Longitude: Longitude | x |
| restrictionAddress/formattedAddress | *None* | Search address - {formattedAddress}: {formattedAddress} | |
| restrictionAddress/formattedMultiLineAddress | *None* | Search address - {formattedAddress}: {formattedAddress} | |
| url/URLAddress | string | URL | x |
| url/URLDescription | string | Description | x |
| contactAssociate/firstName | string | First name: Displays the contact's first name | x |
| contactAssociate/lastName | string | Last name: Displays the contact's last name | x |
| contactAssociate/middleName | string | Middle Name : Displays the contact's middle name. | x |
| contactAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| contactAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| contactAssociate/personId | int | Contact ID: Database ID of the contact row | |
| contactAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| contactAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| contactAssociate/associateDbId | associate | ID | x |
| contactAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
## Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
| ------------------------------------------ | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- | ------- |
| contactAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| contactAssociate/usergroup | userGroup | Primary group: The user's primary user group | x |
| contactAssociate/usergroupId | int | Group ID: The user's primary user group | x |
| contactAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| contactAssociate/contactCategory | listAny | Category: Category | x |
| contactAssociate/role | listAny | Role : Role | x |
| contactAssociate/assocName | associate | User ID : User ID | x |
| contactAssociate/assocTooltip | string | Description : Description | |
| contactAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| contactAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| contactAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| contactAssociate/ejDisplayName | string | Nickname: User's nickname in Service | x |
| contactAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| contactAssociate/credentialType | *None* | Auth. type: What type of credentials to use when this user logs in | x |
| contactAssociate/credentialDisplayValue | *None* | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| contactAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| contactAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| contactAssociate/portraitThumbnail | *None* | Person image: Person image | |
| contactAssociate/otherGroups | userGroup | Other groups: Other groups | |
| contactAssociate/userName | string | User name: User name | x |
| contactAssociate/personEmail | string | E-mail | x |
| contactAssociate/locationAddress | string | Location: Location | x |
| contactAssociate/isLocation | bool | Is a location: Is a location | x |
| contactInterestIds | listInterest | Company Interest: This criterion corresponds to the Interests tab on the Company card. | |
| contactUdef/SuperOffice:1 | string | companyshorttext: tooltipshorttext | x |
| contactUdef/SuperOffice:2 | string | companylongtext: tooltiplongtext | x |
| contactUdef/SuperOffice:3 | int | companynumber | x |
| contactUdef/SuperOffice:4 | date | companydate | x |
| contactUdef/SuperOffice:5 | unlimitedDate | companyunlimiteddate: tooltipunlimiteddate | x |
| contactUdef/SuperOffice:6 | bool | companycheckbox | x |
| contactUdef/SuperOffice:7 | listAny | companydropdownlistbox | x |
| contactUdef/SuperOffice:8 | decimal | companydecimal | x |
| contactUdef/SuperOffice:9 | string | page1saleonly | x |
| contactUdef/SuperOffice:10 | string | page1marketingonly | x |
| contactUdef/SuperOffice:11 | string | page1adminonly | x |
| contactUdef/SuperOffice:12 | listAny | Udlist one: Static tooltip for udlist one | x |
| contactUdef/SuperOffice:13 | listAny | Udlist two: Static tooltip for udlist two | x |
| contactExtra/x\_contact\_integer | int | Extra Integer: Custom integer field | x |
| contactExtra/x\_contact\_hidden\_integer | int | Extra hidden integer: Custom integer field - hidden | x |
| contactExtra/x\_contact\_default\_integer | int | Extra Default Integer: Custom integer field with default value 123. | x |
| contactExtra/x\_contact\_float | decimal | Extra Float: Custom float field with 3 decimals | x |
| contactExtra/x\_contact\_longtext | string | Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor | x |
| contactExtra/x\_contact\_dropdown | listAny | Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc. | x |
| contactExtra/x\_contact\_date | date | Extra date: Custom date field. User current as default. | x |
| contactExtra/x\_contact\_datetime | datetime | Extra DateTime: Custom Date Time field. No default value. External | x |
| contactExtra/x\_contact\_time | *None* | Extra time: Custom time field. | x |
| contactExtra/x\_contact\_boolean | bool | Extra boolean: Custom boolean field. | x |
| contactExtra/x\_contact\_timespan | timeSpan | Extra timespan: Custom timespan field. Hours and minutes in 10 units | x |
| contactExtra/x\_contact\_shorttext | string | Extra short text: Custom short text field. Keep HTML tags. | x |
| contactExtra/x\_contact\_short\_dropdown | listAny | Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External. | x |
| contactExtra/x\_contact\_contact\_relation | stringorPK | Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons | x |
| contactExtra/x\_contact\_request\_relation | stringorPK | Extra Request relation: Request relation on company | x |
| contactExtra/x\_contact\_contact | stringorPK | Extra contact relation: Contact relation on company | x |
| contactExtra/y\_organization/x\_name | string | Organization - Name: Name | x |
| NumberOfActivities | int | Number of activities | |
| NumberOfActivitiesInPeriod | int | Number of activities in last 90 days | |
| NumberOfNotCompletedActivities | int | Number of non-completed activities | |
| NumberOfNotCompletedActivitiesInPeriod | int | Number of non-completed activities in last 90 days | |
| LastActivity | date | Date of last activity | |
| LastCompletedActivity | date | Date of last completed activity | |
| LastDoByActivity | date | Date of last non-completed activity | |
| NumberOfSales | int | Number of sales | |
| NumberOfSalesInPeriod | int | Number of sales in last 90 days | |
| NumberOfNotCompletedSales | int | Number of non-completed sales | |
| NumberOfNotCompletedSalesInPeriod | int | Number of non-completed sales in last 90 days | |
| LastSale | date | Date of last sale | |
| LastCompletedSale | date | Date of last completed sale | |
| LastDoBySale | date | Date of last non-completed sale | |
| NumberOfTickets | int | Number of requests | |
| NumberOfTicketsInPeriod | int | Number of requests in last 90 days | |
| NumberOfNotCompletedTickets | int | Number of non-completed requests | |
| NumberOfNotCompletedTicketsInPeriod | int | Number of non-completed requests in last 90 days | |
| LastTicket | date | Date of last request | |
| LastCompletedTicket | date | Date of last completed request | |
| LastDoByTicket | date | Date of last non-completed request | |
| SaintStatus1 | saintStatus | Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden. | |
| SaintStatus2 | saintStatus | C-company: Kundens navn starter med bokstaven C | |
| saintSaleStatus | listAny | With status | |
| saintAmountClass | listAny | Amount class | |
| saintActivityType | listAny | SAINT type | |
| saintDirection | listAny | Direction | |
| saintIntention | listAny | Intention | |
| saintTicketStatus | listAny | Status | |
| saintTicketCategory | listAny | Category | |
## Sample
```http! theme={null}
GET /api/v1/archive/contactfavourites?$select=icon,contactAssociate/contactFullName,postAddress/formattedAddress
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv
```
See also: IArchiveAgent.
## Related topics
- [contactfavourite](/en/api/mdo-providers/reference/contactfavourite.md)
- [Archive Provider List](/en/api/archive-providers/reference/index.md)
- [MDO List Provider names](/en/api/mdo-providers/reference/index.md)