Relation - SuperOffice

“Relation”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.RelationProvider inside NetServer’s SODatabase assembly. Data provider class for the ‘Relation’ archive under the company card. This class combines output from the up to eight basic sub-providers (CC, PC, PP and CP plus their reversed cousins) into one data stream.

Supported Entities

Name	Description
”relation”	Relation
”retired”	Former employees
”stop”	Companies flagged with Stop

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
relationName	string	Name: Name of relation, not taking into account the relation direction	x
relationComment	string	Comment: Comment on the relation	x
reversedName	string	Passive form : The name of the relation in the passive direction	x
processedName	None	has relations: Has the given relationship to
relationId	int	ID: Database ID of the relation record	x
relationDefinitionId	int	Definition ID: Database ID of the definition record for this relation	x
direction	int	Direction: The direction of this relation (active or passive)	x
associateId	associate	ID: Displays the login ID of the associate who owns the activity.	x
source/personId	None	Source - DB ID: Displays the database ID of a contact
source/firstName	None	Source - First name: Displays the contact’s first name
source/lastName	None	Source - Last name: Displays the contact’s last name
source/middleName	None	Source - Middle name: Displays the contact’s middle name.
source/fullName	None	Source - Contact: Displays the contact to which an item is linked
source/fullNameWithContact	None	Source - Contact and company: The fully formatted contact name, and full company name
source/contactId	int	Source - Company ID: Database ID of company	x
source/hasInfoText	bool	Source - Has note: Displays an icon indicating if there is additional information available about the contact	x
source/hasInterests	bool	Source - Has interests: Displays an Icon indicating if the contact has active interests	x
source/personHasInterests	None	Source - Has interests: Displays an Icon indicating if the contact has active interests
source/mrMrs	None	Source - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
source/position	None	Source - Position
source/personNumber	None	Source - Number: Displays the contact’s number
source/title	None	Source - Title: Displays the contact’s job title
source/personCountry	None	Source - Country: Country
source/personCountryId	None	Source - Country ID: Country ID
source/personNoMail	None	Source - No Mailings: Displays the contact’s No Mailings checkbox
source/rank	None	Source - Rank: Displays a contact’s current rank
source/birthdate	None	Source - Birthdate: Displays the contact’s date of birth
source/associateType	None	Source - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading.
source/useAsMailingAddress	None	Source - Use as postal address: Use as postal address
source/personSource	None	Source - Source: Source (Contact)
source/retired	None	Source - Former employee: Indicates whether the contact has retired/left the company
source/birthYear	None	Source - Birth year: Displays contact’s birth year
source/birthMonth	None	Source - Birth month: Displays contact’s birth month
source/birthDay	None	Source - Birth day: Displays contact’s birth day (day of month)
source/kanaFirstName	None	Source - First name, kana: Contact’s first name, in kana alphabet
source/kanaLastName	None	Source - Last name, kana: Contact’s last name, in kana alphabet
source/personUpdatedBy	None	Source - Updated by: The user who last updated the data
source/personUpdatedByFullName	None	Source - Updated by - Full name: The user who last updated the data
source/personUpdatedDate	None	Source - Updated: The date/time the data was last updated in UTC.
source/personRegisteredBy	None	Source - Registered by: The user who registered the data
source/personRegisteredByFullName	None	Source - Registered by - Full name: The user who registered the data
source/personRegisteredDate	None	Source - Registered date: The date/time the data was registered in UTC.
source/portraitThumbnail	None	Source - Person image: Person image
source/personActiveErpLinks	None	Source - ERP connected: Is there an active ERP Sync?
source/ticketPriority	None	Source - Service priority: Default service priority for this contact
source/supportLanguage	None	Source - Preferred language: Preferred language used for reply templates and more
source/supportAssociate	None	Source - Our service contact: Default service contact for this contact
source/supportAssociateFullName	None	Source - Our service contact - Full name: Default service contact for this contact
source/personAssociateId	None	Source - Our contact: Displays our contact
source/personAssociateFullName	None	Source - Our contact - Full name: Displays our contact
source/personCategory	None	Source - Category
source/personCategoryGroup	None	Source - Category group
source/personCategoryRank	None	Source - !!Category rank
source/personBusiness	None	Source - Business
source/leadStatus	None	Source - Lead status
source/leadstatusRank	None	Source - !!Lead status RANK
source/personDeletedDate	None	Source - Deleted date: Deleted date
source/hasCompany	None	Source - Has company: The contact is associated with a company
source/isProjectMember	None	Source - Is project member: This person is a project member
source/isStakeholder	None	Source - Is stakeholder: This person is a sale stakeholder
source/updatedByWorkflow	None	Source - Updated by flow: Updated by flow
source/whenUpdatedByWorkflow	None	Source - When updated by flow: When updated by flow
source/createdByForm	None	Source - Created by form: Created by form
source/phone/formattedNumber	string	Source - Phone: Displays phone number
source/restrictionContactId	int	Source - Company ID: Database ID of company to fetch relations for
source/restrictionPersonId	None	Source - Company ID: Database ID of company to fetch relations for
source/who	None	Source - Full name: Full name of company/contact	x
source/personDirectPhone/formattedNumber	None	Source - Direct - Phone: Displays phone number
source/personDirectPhone/description	None	Source - Direct - Description: Phone number description
source/personMobilePhone/formattedNumber	None	Source - Mobile - Phone: Displays phone number
source/personMobilePhone/description	None	Source - Mobile - Description: Phone number description
source/personPrivate/formattedNumber	None	Source - Private - Phone: Displays phone number
source/personPrivate/description	None	Source - Private - Description: Phone number description
source/personPager/formattedNumber	None	Source - Other - Phone: Displays phone number
source/personPager/description	None	Source - Other - Description: Phone number description
source/personDirectFax/formattedNumber	None	Source - Fax - Phone: Displays phone number
source/personDirectFax/description	None	Source - Fax - Description: Phone number description
source/name	stringorPK	Source - Company name	x
source/department	string	Source - Department	x
source/nameDepartment	string	Source - Company: Displays the company an activity is linked to	x
source/associateId	associate	Source - Our contact: Displays our contact	x
source/category	listAny	Source - Category	x
source/categoryGroup	listAny	Source - Category group	x
source/companyCategoryRank	int	Source - Category rank	x
source/business	listAny	Source - Business	x
source/country	listAny	Source - Country: This criterion corresponds to the Country field on the Company card.	x
source/countryId	int	Source - Country ID: Country ID	x
source/number	string	Source - Number	x
source/code	string	Source - Code	x
source/orgnr	string	Source - VAT No.	x
source/stop	bool	Source - Stop	x
source/contactNoMail	bool	Source - No mailings (company)	x
source/updatedBy	associate	Source - Updated by: The user who last updated the data	x
source/updatedByFullName	associate	Source - Updated by - Full name: The user who last updated the data	x
source/updatedDate	date	Source - Updated: The date/time the data was last updated in UTC.	x
source/registeredBy	associate	Source - Registered by: The user who registered the data	x
source/registeredByFullName	associate	Source - Registered by - Full name: The user who registered the data	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
source/registeredDate	date	Source - Registered date: The date/time the data was registered in UTC.	x
source/contactSource	listAny	Source - Source: Source (Company)	x
source/contactDeleted	bool	Source - Deleted: Deleted	x
source/activeErpLinks	bool	Source - ERP connected: Is there an active ERP Sync?	x
source/deletedDate	datetime	Source - Deleted date: Deleted date
source/mainContact	None	Source - Main contact: Main contact for this company	x
source/forceCompany	bool	Source - Dummy: Dummy
source/contactPhone/formattedNumber	string	Source - Telephone - Phone: Displays phone number
source/contactPhone/description	string	Source - Telephone - Description: Phone number description	x
target/contactId	int	Target - Company ID: Database ID of company	x
target/name	stringorPK	Target - Company name	x
target/department	string	Target - Department	x
target/nameDepartment	string	Target - Company: Displays the company an activity is linked to	x
target/hasInfoText	bool	Target - Has note: Displays an icon indicating if there is additional information available about the contact	x
target/hasInterests	bool	Target - Has interests: Displays an Icon indicating if the contact has active interests	x
target/associateId	associate	Target - Our contact: Displays our contact	x
target/category	listAny	Target - Category	x
target/categoryGroup	listAny	Target - Category group	x
target/companyCategoryRank	int	Target - Category rank	x
target/business	listAny	Target - Business	x
target/country	listAny	Target - Country: This criterion corresponds to the Country field on the Company card.	x
target/countryId	int	Target - Country ID: Country ID	x
target/number	string	Target - Number	x
target/code	string	Target - Code	x
target/orgnr	string	Target - VAT No.	x
target/stop	bool	Target - Stop	x
target/contactNoMail	bool	Target - No mailings (company)	x
target/updatedBy	associate	Target - Updated by: The user who last updated the data	x
target/updatedByFullName	associate	Target - Updated by - Full name: The user who last updated the data	x
target/updatedDate	date	Target - Updated: The date/time the data was last updated in UTC.	x
target/registeredBy	associate	Target - Registered by: The user who registered the data	x
target/registeredByFullName	associate	Target - Registered by - Full name: The user who registered the data	x
target/registeredDate	date	Target - Registered date: The date/time the data was registered in UTC.	x
target/contactSource	listAny	Target - Source: Source (Company)	x
target/contactDeleted	bool	Target - Deleted: Deleted	x
target/phone/formattedNumber	string	Target - Phone: Displays phone number
target/activeErpLinks	bool	Target - ERP connected: Is there an active ERP Sync?	x
target/deletedDate	datetime	Target - Deleted date: Deleted date
target/mainContact	None	Target - Main contact: Main contact for this company	x
target/forceCompany	bool	Target - Dummy: Dummy
target/restrictionContactId	int	Target - Company ID: Database ID of company to fetch relations for
target/who	None	Target - Full name: Full name of company/contact	x
target/contactPhone/formattedNumber	string	Target - Telephone - Phone: Displays phone number
target/contactPhone/description	string	Target - Telephone - Description: Phone number description	x
target/contactFax/formattedNumber	None	Target - Fax - Phone: Displays phone number
target/contactFax/description	None	Target - Fax - Description: Phone number description
target/searchPhone/formattedNumber	None	Target - Searchphone - Phone: Displays phone number
target/searchPhone/description	None	Target - Searchphone - Description: Phone number description
target/email/emailProtocol	None	Target - Protocol: E-mail protocol, such as SMTP
target/email/emailAddress	None	Target - E-mail
target/email/emailDescription	None	Target - Description
target/email/emailId	None	Target - ID
target/email/emailLastSent	None	Target - Last sent: The date and time an e-mail was last sent to this address
target/email/emailBounceCount	None	Target - Bounce count: Bounce count for this e-mail address
target/email/emailLastBounce	None	Target - Last bounce: Date and time for last bounce to this e-mail address
target/email/emailHasBounced	None	Target - Has bounced: This checkbox is active if delivery to this e-mail address has failed.
target/postAddress/addressId	None	Target - Postal address - Address ID: Database ID for the address record
target/postAddress/line1	None	Target - Postal address - Address 1: First line of the address
target/postAddress/line2	None	Target - Postal address - Address 2: Second line of the address
target/postAddress/line3	None	Target - Postal address - Address 3: Third line of the address
target/postAddress/county	None	Target - 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.
target/postAddress/city	None	Target - Postal address - City: This criterion corresponds to the City field on the Company card.
target/postAddress/zip	None	Target - Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
target/postAddress/state	None	Target - 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.
target/postAddress/wgs84latitude	None	Target - Postal address - Latitude: Latitude
target/postAddress/wgs84longitude	None	Target - Postal address - Longitude: Longitude
target/postAddress/formattedAddress	None	Target - Postal address - :
target/postAddress/formattedMultiLineAddress	None	Target - Postal address - :
target/streetAddress/addressId	None	Target - Street address - Address ID: Database ID for the address record
target/streetAddress/line1	None	Target - Street address - Address 1: First line of the address
target/streetAddress/line2	None	Target - Street address - Address 2: Second line of the address
target/streetAddress/line3	None	Target - Street address - Address 3: Third line of the address
target/streetAddress/county	None	Target - 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.
target/streetAddress/city	None	Target - Street address - City: This criterion corresponds to the City field on the Company card.
target/streetAddress/zip	None	Target - Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
target/streetAddress/state	None	Target - 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.
target/streetAddress/wgs84latitude	None	Target - Street address - Latitude: Latitude
target/streetAddress/wgs84longitude	None	Target - Street address - Longitude: Longitude
target/streetAddress/formattedAddress	None	Target - Street address - :
target/streetAddress/formattedMultiLineAddress	None	Target - Street address - :
target/restrictionAddress/addressId	None	Target - Search address - Address ID: Database ID for the address record
target/restrictionAddress/line1	None	Target - Search address - Address 1: First line of the address
target/restrictionAddress/line2	None	Target - Search address - Address 2: Second line of the address
target/restrictionAddress/line3	None	Target - Search address - Address 3: Third line of the address
target/restrictionAddress/county	None	Target - 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.
target/restrictionAddress/city	None	Target - Search address - City: This criterion corresponds to the City field on the Company card.
target/restrictionAddress/zip	None	Target - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
target/restrictionAddress/state	None	Target - 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.
target/restrictionAddress/wgs84latitude	None	Target - Search address - Latitude: Latitude
target/restrictionAddress/wgs84longitude	None	Target - Search address - Longitude: Longitude
target/restrictionAddress/formattedAddress	None	Target - Search address - :
target/restrictionAddress/formattedMultiLineAddress	None	Target - Search address - :
target/url/URLAddress	None	Target - URL
target/url/URLDescription	None	Target - Description
target/contactAssociate/firstName	None	Target - First name: Displays the contact’s first name
target/contactAssociate/lastName	None	Target - Last name: Displays the contact’s last name
target/contactAssociate/middleName	None	Target - Middle Name: Displays the contact’s middle name.
target/contactAssociate/fullName	None	Target - Full name: Displays full name of user (first, middle, last - according to settings)
target/contactAssociate/contactId	None	Target - Company ID: Database ID of the company the user belongs to
target/contactAssociate/personId	None	Target - Contact ID: Database ID of the contact row

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
target/contactAssociate/mrMrs	None	Target - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
target/contactAssociate/title	None	Target - Title: Displays whether the contact is addressed as Mr or Ms
target/contactAssociate/associateDbId	None	Target - ID
target/contactAssociate/contactName	None	Target - Owning company: Name of the company the user belongs to
target/contactAssociate/contactDepartment	None	Target - Owning department: Name of the department at the company the user belongs to
target/contactAssociate/usergroup	None	Target - Primary group: The user’s primary user group
target/contactAssociate/usergroupId	None	Target - Group ID: The user’s primary user group
target/contactAssociate/contactFullName	None	Target - Owner: Name and department of the company the user belongs to
target/contactAssociate/contactCategory	None	Target - Category: Category
target/contactAssociate/role	None	Target - Role: Role
target/contactAssociate/assocName	None	Target - User ID: User ID
target/contactAssociate/assocTooltip	None	Target - Description: Description
target/contactAssociate/assocType	None	Target - Type: Type of user: associate, external user, system user, anonymous account
target/contactAssociate/ejUserId	None	Target - Service user ID: The database ID of a Service user
target/contactAssociate/simultaneousEjUser	None	Target - 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
target/contactAssociate/ejDisplayName	None	Target - Nickname: User’s nickname in Service
target/contactAssociate/ejStatus	None	Target - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
target/contactAssociate/credentialType	None	Target - Auth. type: What type of credentials to use when this user logs in
target/contactAssociate/credentialDisplayValue	None	Target - Auth. value: Credential value (public, visible part) to be used when this user logs in
target/contactAssociate/isActive	None	Target - Active: Is this user active, and should be able to log in?
target/contactAssociate/isActiveText	None	Target - Active status: Is this user active, and should be able to log in?
target/contactAssociate/portraitThumbnail	None	Target - Person image: Person image
target/contactAssociate/otherGroups	None	Target - Other groups: Other groups
target/contactAssociate/userName	None	Target - User name: User name
target/contactAssociate/personEmail	None	Target - E-mail
target/contactAssociate/locationAddress	None	Target - Location: Location
target/contactAssociate/isLocation	None	Target - Is a location: Is a location
target/contactInterestIds	None	Target - Company Interest: This criterion corresponds to the Interests tab on the Company card.
target/contactUdef/SuperOffice:1	None	Target - companyshorttext: tooltipshorttext
target/contactUdef/SuperOffice:2	None	Target - companylongtext: tooltiplongtext
target/contactUdef/SuperOffice:3	None	Target - companynumber
target/contactUdef/SuperOffice:4	None	Target - companydate
target/contactUdef/SuperOffice:5	None	Target - companyunlimiteddate: tooltipunlimiteddate
target/contactUdef/SuperOffice:6	None	Target - companycheckbox
target/contactUdef/SuperOffice:7	None	Target - companydropdownlistbox
target/contactUdef/SuperOffice:8	None	Target - companydecimal
target/contactUdef/SuperOffice:9	None	Target - page1saleonly
target/contactUdef/SuperOffice:10	None	Target - page1marketingonly
target/contactUdef/SuperOffice:11	None	Target - page1adminonly
target/contactUdef/SuperOffice:12	None	Target - Udlist one: Static tooltip for udlist one
target/contactUdef/SuperOffice:13	None	Target - Udlist two: Static tooltip for udlist two
target/contactExtra/x_contact_integer	None	Target - Extra Integer: Custom integer field
target/contactExtra/x_contact_hidden_integer	None	Target - Extra hidden integer: Custom integer field - hidden
target/contactExtra/x_contact_default_integer	None	Target - Extra Default Integer: Custom integer field with default value 123.
target/contactExtra/x_contact_float	None	Target - Extra Float: Custom float field with 3 decimals
target/contactExtra/x_contact_longtext	None	Target - Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor
target/contactExtra/x_contact_dropdown	None	Target - Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.
target/contactExtra/x_contact_date	None	Target - Extra date: Custom date field. User current as default.
target/contactExtra/x_contact_datetime	None	Target - Extra DateTime: Custom Date Time field. No default value. External
target/contactExtra/x_contact_time	None	Target - Extra time: Custom time field.
target/contactExtra/x_contact_boolean	None	Target - Extra boolean: Custom boolean field.
target/contactExtra/x_contact_timespan	None	Target - Extra timespan: Custom timespan field. Hours and minutes in 10 units
target/contactExtra/x_contact_shorttext	None	Target - Extra short text: Custom short text field. Keep HTML tags.
target/contactExtra/x_contact_short_dropdown	None	Target - Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.
target/contactExtra/x_contact_contact_relation	None	Target - Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons
target/contactExtra/x_contact_request_relation	None	Target - Extra Request relation: Request relation on company
target/contactExtra/x_contact_contact	None	Target - Extra contact relation: Contact relation on company
target/contactExtra/y_organization/x_name	None	Target - Organization - Name: Name
target/NumberOfActivities	None	Target - Number of activities
target/NumberOfActivitiesInPeriod	None	Target - Number of activities in last 90 days
target/NumberOfNotCompletedActivities	None	Target - Number of non-completed activities
target/NumberOfNotCompletedActivitiesInPeriod	None	Target - Number of non-completed activities in last 90 days
target/LastActivity	None	Target - Date of last activity
target/LastCompletedActivity	None	Target - Date of last completed activity
target/LastDoByActivity	None	Target - Date of last non-completed activity
target/NumberOfSales	None	Target - Number of sales
target/NumberOfSalesInPeriod	None	Target - Number of sales in last 90 days
target/NumberOfNotCompletedSales	None	Target - Number of non-completed sales
target/NumberOfNotCompletedSalesInPeriod	None	Target - Number of non-completed sales in last 90 days
target/LastSale	None	Target - Date of last sale
target/LastCompletedSale	None	Target - Date of last completed sale
target/LastDoBySale	None	Target - Date of last non-completed sale
target/NumberOfTickets	None	Target - Number of requests
target/NumberOfTicketsInPeriod	None	Target - Number of requests in last 90 days
target/NumberOfNotCompletedTickets	None	Target - Number of non-completed requests
target/NumberOfNotCompletedTicketsInPeriod	None	Target - Number of non-completed requests in last 90 days
target/LastTicket	None	Target - Date of last request
target/LastCompletedTicket	None	Target - Date of last completed request
target/LastDoByTicket	None	Target - Date of last non-completed request
target/SaintStatus1	None	Target - Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden.
target/SaintStatus2	None	Target - C-company: Kundens navn starter med bokstaven C
target/saintSaleStatus	None	Target - With status
target/saintAmountClass	None	Target - Amount class
target/saintActivityType	None	Target - SAINT type
target/saintDirection	None	Target - Direction
target/saintIntention	None	Target - Intention
target/saintTicketStatus	None	Target - Status
target/saintTicketCategory	None	Target - Category
firstName	string	First name: Displays the contact’s first name	x
lastName	string	Last name: Displays the contact’s last name	x
middleName	string	Middle Name : Displays the contact’s middle name.	x
fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
contactId	int	Company ID: Database ID of the company the user belongs to
personId	int	Contact ID: Database ID of the contact row
mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
associateDbId	associate	ID	x
contactName	string	Owning company: Name of the company the user belongs to	x
contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
usergroup	userGroup	Primary group: The user’s primary user group	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
usergroupId	int	Group ID: The user’s primary user group	x
contactFullName	string	Owner: Name and department of the company the user belongs to	x
contactCategory	listAny	Category: Category	x
role	listAny	Role : Role	x
assocName	associate	User ID : User ID	x
assocTooltip	string	Description : Description
assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
ejUserId	int	Service user ID: The database ID of a Service user
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
ejDisplayName	string	Nickname: User’s nickname in Service	x
ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
isActive	bool	Active: Is this user active, and should be able to log in?	x
isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
portraitThumbnail	None	Person image: Person image
otherGroups	userGroup	Other groups: Other groups
userName	string	User name: User name	x
personEmail	string	E-mail	x
locationAddress	string	Location: Location	x
isLocation	bool	Is a location: Is a location	x
target/personId	None	Target - DB ID: Displays the database ID of a contact
target/firstName	None	Target - First name: Displays the contact’s first name
target/lastName	None	Target - Last name: Displays the contact’s last name
target/middleName	None	Target - Middle name: Displays the contact’s middle name.
target/fullName	None	Target - Contact: Displays the contact to which an item is linked
target/fullNameWithContact	None	Target - Contact and company: The fully formatted contact name, and full company name
target/personHasInterests	None	Target - Has interests: Displays an Icon indicating if the contact has active interests
target/mrMrs	None	Target - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
target/position	None	Target - Position
target/personNumber	None	Target - Number: Displays the contact’s number
target/title	None	Target - Title: Displays the contact’s job title
target/personCountry	None	Target - Country: Country
target/personCountryId	None	Target - Country ID: Country ID
target/personNoMail	None	Target - No Mailings: Displays the contact’s No Mailings checkbox
target/rank	None	Target - Rank: Displays a contact’s current rank
target/birthdate	None	Target - Birthdate: Displays the contact’s date of birth
target/associateType	None	Target - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading.
target/useAsMailingAddress	None	Target - Use as postal address: Use as postal address
target/personSource	None	Target - Source: Source (Contact)
target/retired	None	Target - Former employee: Indicates whether the contact has retired/left the company
target/birthYear	None	Target - Birth year: Displays contact’s birth year
target/birthMonth	None	Target - Birth month: Displays contact’s birth month
target/birthDay	None	Target - Birth day: Displays contact’s birth day (day of month)
target/kanaFirstName	None	Target - First name, kana: Contact’s first name, in kana alphabet
target/kanaLastName	None	Target - Last name, kana: Contact’s last name, in kana alphabet
target/personUpdatedBy	None	Target - Updated by: The user who last updated the data
target/personUpdatedByFullName	None	Target - Updated by - Full name: The user who last updated the data
target/personUpdatedDate	None	Target - Updated: The date/time the data was last updated in UTC.
target/personRegisteredBy	None	Target - Registered by: The user who registered the data
target/personRegisteredByFullName	None	Target - Registered by - Full name: The user who registered the data
target/personRegisteredDate	None	Target - Registered date: The date/time the data was registered in UTC.
target/portraitThumbnail	None	Target - Person image: Person image
target/personActiveErpLinks	None	Target - ERP connected: Is there an active ERP Sync?
target/ticketPriority	None	Target - Service priority: Default service priority for this contact
target/supportLanguage	None	Target - Preferred language: Preferred language used for reply templates and more
target/supportAssociate	None	Target - Our service contact: Default service contact for this contact
target/supportAssociateFullName	None	Target - Our service contact - Full name: Default service contact for this contact
target/personAssociateId	None	Target - Our contact: Displays our contact
target/personAssociateFullName	None	Target - Our contact - Full name: Displays our contact
target/personCategory	None	Target - Category
target/personCategoryGroup	None	Target - Category group
target/personCategoryRank	None	Target - !!Category rank
target/personBusiness	None	Target - Business
target/leadStatus	None	Target - Lead status
target/leadstatusRank	None	Target - !!Lead status RANK
target/personDeletedDate	None	Target - Deleted date: Deleted date
target/hasCompany	None	Target - Has company: The contact is associated with a company
target/isProjectMember	None	Target - Is project member: This person is a project member
target/isStakeholder	None	Target - Is stakeholder: This person is a sale stakeholder
target/updatedByWorkflow	None	Target - Updated by flow: Updated by flow
target/whenUpdatedByWorkflow	None	Target - When updated by flow: When updated by flow
target/createdByForm	None	Target - Created by form: Created by form
target/restrictionPersonId	None	Target - Company ID: Database ID of company to fetch relations for
target/personDirectPhone/formattedNumber	None	Target - Direct - Phone: Displays phone number
target/personDirectPhone/description	None	Target - Direct - Description: Phone number description
target/personMobilePhone/formattedNumber	None	Target - Mobile - Phone: Displays phone number
target/personMobilePhone/description	None	Target - Mobile - Description: Phone number description
target/personPrivate/formattedNumber	None	Target - Private - Phone: Displays phone number
target/personPrivate/description	None	Target - Private - Description: Phone number description
target/personPager/formattedNumber	None	Target - Other - Phone: Displays phone number
target/personPager/description	None	Target - Other - Description: Phone number description
target/personDirectFax/formattedNumber	None	Target - Fax - Phone: Displays phone number
target/personDirectFax/description	None	Target - Fax - Description: Phone number description
source/contactFax/formattedNumber	None	Source - Fax - Phone: Displays phone number
source/contactFax/description	None	Source - Fax - Description: Phone number description
source/searchPhone/formattedNumber	None	Source - Searchphone - Phone: Displays phone number
source/searchPhone/description	None	Source - Searchphone - Description: Phone number description
source/email/emailProtocol	None	Source - Protocol: E-mail protocol, such as SMTP
source/email/emailAddress	None	Source - E-mail
source/email/emailDescription	None	Source - Description
source/email/emailId	None	Source - ID
source/email/emailLastSent	None	Source - Last sent: The date and time an e-mail was last sent to this address
source/email/emailBounceCount	None	Source - Bounce count: Bounce count for this e-mail address
source/email/emailLastBounce	None	Source - Last bounce: Date and time for last bounce to this e-mail address
source/email/emailHasBounced	None	Source - Has bounced: This checkbox is active if delivery to this e-mail address has failed.
source/postAddress/addressId	None	Source - Postal address - Address ID: Database ID for the address record
source/postAddress/line1	None	Source - Postal address - Address 1: First line of the address
source/postAddress/line2	None	Source - Postal address - Address 2: Second line of the address
source/postAddress/line3	None	Source - Postal address - Address 3: Third line of the address

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
source/postAddress/county	None	Source - 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.
source/postAddress/city	None	Source - Postal address - City: This criterion corresponds to the City field on the Company card.
source/postAddress/zip	None	Source - Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
source/postAddress/state	None	Source - 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.
source/postAddress/wgs84latitude	None	Source - Postal address - Latitude: Latitude
source/postAddress/wgs84longitude	None	Source - Postal address - Longitude: Longitude
source/postAddress/formattedAddress	None	Source - Postal address - :
source/postAddress/formattedMultiLineAddress	None	Source - Postal address - :
source/streetAddress/addressId	None	Source - Street address - Address ID: Database ID for the address record
source/streetAddress/line1	None	Source - Street address - Address 1: First line of the address
source/streetAddress/line2	None	Source - Street address - Address 2: Second line of the address
source/streetAddress/line3	None	Source - Street address - Address 3: Third line of the address
source/streetAddress/county	None	Source - 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.
source/streetAddress/city	None	Source - Street address - City: This criterion corresponds to the City field on the Company card.
source/streetAddress/zip	None	Source - Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
source/streetAddress/state	None	Source - 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.
source/streetAddress/wgs84latitude	None	Source - Street address - Latitude: Latitude
source/streetAddress/wgs84longitude	None	Source - Street address - Longitude: Longitude
source/streetAddress/formattedAddress	None	Source - Street address - :
source/streetAddress/formattedMultiLineAddress	None	Source - Street address - :
source/restrictionAddress/addressId	None	Source - Search address - Address ID: Database ID for the address record
source/restrictionAddress/line1	None	Source - Search address - Address 1: First line of the address
source/restrictionAddress/line2	None	Source - Search address - Address 2: Second line of the address
source/restrictionAddress/line3	None	Source - Search address - Address 3: Third line of the address
source/restrictionAddress/county	None	Source - 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.
source/restrictionAddress/city	None	Source - Search address - City: This criterion corresponds to the City field on the Company card.
source/restrictionAddress/zip	None	Source - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
source/restrictionAddress/state	None	Source - 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.
source/restrictionAddress/wgs84latitude	None	Source - Search address - Latitude: Latitude
source/restrictionAddress/wgs84longitude	None	Source - Search address - Longitude: Longitude
source/restrictionAddress/formattedAddress	None	Source - Search address - :
source/restrictionAddress/formattedMultiLineAddress	None	Source - Search address - :
source/url/URLAddress	None	Source - URL
source/url/URLDescription	None	Source - Description
source/contactAssociate/firstName	None	Source - First name: Displays the contact’s first name
source/contactAssociate/lastName	None	Source - Last name: Displays the contact’s last name
source/contactAssociate/middleName	None	Source - Middle Name: Displays the contact’s middle name.
source/contactAssociate/fullName	None	Source - Full name: Displays full name of user (first, middle, last - according to settings)
source/contactAssociate/contactId	None	Source - Company ID: Database ID of the company the user belongs to
source/contactAssociate/personId	None	Source - Contact ID: Database ID of the contact row
source/contactAssociate/mrMrs	None	Source - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
source/contactAssociate/title	None	Source - Title: Displays whether the contact is addressed as Mr or Ms
source/contactAssociate/associateDbId	None	Source - ID
source/contactAssociate/contactName	None	Source - Owning company: Name of the company the user belongs to
source/contactAssociate/contactDepartment	None	Source - Owning department: Name of the department at the company the user belongs to
source/contactAssociate/usergroup	None	Source - Primary group: The user’s primary user group
source/contactAssociate/usergroupId	None	Source - Group ID: The user’s primary user group
source/contactAssociate/contactFullName	None	Source - Owner: Name and department of the company the user belongs to
source/contactAssociate/contactCategory	None	Source - Category: Category
source/contactAssociate/role	None	Source - Role: Role
source/contactAssociate/assocName	None	Source - User ID: User ID
source/contactAssociate/assocTooltip	None	Source - Description: Description
source/contactAssociate/assocType	None	Source - Type: Type of user: associate, external user, system user, anonymous account
source/contactAssociate/ejUserId	None	Source - Service user ID: The database ID of a Service user
source/contactAssociate/simultaneousEjUser	None	Source - 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
source/contactAssociate/ejDisplayName	None	Source - Nickname: User’s nickname in Service
source/contactAssociate/ejStatus	None	Source - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
source/contactAssociate/credentialType	None	Source - Auth. type: What type of credentials to use when this user logs in
source/contactAssociate/credentialDisplayValue	None	Source - Auth. value: Credential value (public, visible part) to be used when this user logs in
source/contactAssociate/isActive	None	Source - Active: Is this user active, and should be able to log in?
source/contactAssociate/isActiveText	None	Source - Active status: Is this user active, and should be able to log in?
source/contactAssociate/portraitThumbnail	None	Source - Person image: Person image
source/contactAssociate/otherGroups	None	Source - Other groups: Other groups
source/contactAssociate/userName	None	Source - User name: User name
source/contactAssociate/personEmail	None	Source - E-mail
source/contactAssociate/locationAddress	None	Source - Location: Location
source/contactAssociate/isLocation	None	Source - Is a location: Is a location
source/contactInterestIds	None	Source - Company Interest: This criterion corresponds to the Interests tab on the Company card.
source/contactUdef/SuperOffice:1	None	Source - companyshorttext: tooltipshorttext
source/contactUdef/SuperOffice:2	None	Source - companylongtext: tooltiplongtext
source/contactUdef/SuperOffice:3	None	Source - companynumber
source/contactUdef/SuperOffice:4	None	Source - companydate
source/contactUdef/SuperOffice:5	None	Source - companyunlimiteddate: tooltipunlimiteddate
source/contactUdef/SuperOffice:6	None	Source - companycheckbox
source/contactUdef/SuperOffice:7	None	Source - companydropdownlistbox
source/contactUdef/SuperOffice:8	None	Source - companydecimal
source/contactUdef/SuperOffice:9	None	Source - page1saleonly
source/contactUdef/SuperOffice:10	None	Source - page1marketingonly
source/contactUdef/SuperOffice:11	None	Source - page1adminonly
source/contactUdef/SuperOffice:12	None	Source - Udlist one: Static tooltip for udlist one
source/contactUdef/SuperOffice:13	None	Source - Udlist two: Static tooltip for udlist two
source/contactExtra/x_contact_integer	None	Source - Extra Integer: Custom integer field
source/contactExtra/x_contact_hidden_integer	None	Source - Extra hidden integer: Custom integer field - hidden
source/contactExtra/x_contact_default_integer	None	Source - Extra Default Integer: Custom integer field with default value 123.
source/contactExtra/x_contact_float	None	Source - Extra Float: Custom float field with 3 decimals
source/contactExtra/x_contact_longtext	None	Source - Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor
source/contactExtra/x_contact_dropdown	None	Source - Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.
source/contactExtra/x_contact_date	None	Source - Extra date: Custom date field. User current as default.
source/contactExtra/x_contact_datetime	None	Source - Extra DateTime: Custom Date Time field. No default value. External
source/contactExtra/x_contact_time	None	Source - Extra time: Custom time field.
source/contactExtra/x_contact_boolean	None	Source - Extra boolean: Custom boolean field.
source/contactExtra/x_contact_timespan	None	Source - Extra timespan: Custom timespan field. Hours and minutes in 10 units
source/contactExtra/x_contact_shorttext	None	Source - Extra short text: Custom short text field. Keep HTML tags.
source/contactExtra/x_contact_short_dropdown	None	Source - Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.
source/contactExtra/x_contact_contact_relation	None	Source - Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons
source/contactExtra/x_contact_request_relation	None	Source - Extra Request relation: Request relation on company
source/contactExtra/x_contact_contact	None	Source - Extra contact relation: Contact relation on company
source/contactExtra/y_organization/x_name	None	Source - Organization - Name: Name
source/NumberOfActivities	None	Source - Number of activities
source/NumberOfActivitiesInPeriod	None	Source - Number of activities in last 90 days

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
source/NumberOfNotCompletedActivities	None	Source - Number of non-completed activities
source/NumberOfNotCompletedActivitiesInPeriod	None	Source - Number of non-completed activities in last 90 days
source/LastActivity	None	Source - Date of last activity
source/LastCompletedActivity	None	Source - Date of last completed activity
source/LastDoByActivity	None	Source - Date of last non-completed activity
source/NumberOfSales	None	Source - Number of sales
source/NumberOfSalesInPeriod	None	Source - Number of sales in last 90 days
source/NumberOfNotCompletedSales	None	Source - Number of non-completed sales
source/NumberOfNotCompletedSalesInPeriod	None	Source - Number of non-completed sales in last 90 days
source/LastSale	None	Source - Date of last sale
source/LastCompletedSale	None	Source - Date of last completed sale
source/LastDoBySale	None	Source - Date of last non-completed sale
source/NumberOfTickets	None	Source - Number of requests
source/NumberOfTicketsInPeriod	None	Source - Number of requests in last 90 days
source/NumberOfNotCompletedTickets	None	Source - Number of non-completed requests
source/NumberOfNotCompletedTicketsInPeriod	None	Source - Number of non-completed requests in last 90 days
source/LastTicket	None	Source - Date of last request
source/LastCompletedTicket	None	Source - Date of last completed request
source/LastDoByTicket	None	Source - Date of last non-completed request
source/SaintStatus1	None	Source - Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden.
source/SaintStatus2	None	Source - C-company: Kundens navn starter med bokstaven C
source/saintSaleStatus	None	Source - With status
source/saintAmountClass	None	Source - Amount class
source/saintActivityType	None	Source - SAINT type
source/saintDirection	None	Source - Direction
source/saintIntention	None	Source - Intention
source/saintTicketStatus	None	Source - Status
source/saintTicketCategory	None	Source - Category

Sample

GET /api/v1/archive/Relation?$select=target/postAddress/line3,target/contactAssociate/otherGroups,target/contactUdef/SuperOffice:4,credentialType,target/leadStatus
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.

Related topics

Relations Request relations Relation events Relations tab Relation rules

⌘I