PersonRelation - SuperOffice

“PersonRelation”

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

Supported Entities

Name	Description
”relation"
"retired"
"stop”

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool
getNoRows	bool
relationName	string		x
relationComment	string		x
reversedName	string		x
processedName	None
relationId	int		x
relationDefinitionId	int		x
direction	int		x
associateId	associate		x
source/personId	None
source/firstName	None
source/lastName	None
source/middleName	None
source/fullName	None
source/fullNameWithContact	None
source/contactId	int		x
source/hasInfoText	bool		x
source/hasInterests	bool		x
source/personHasInterests	None
source/mrMrs	None
source/position	None
source/personNumber	None
source/title	None
source/personCountry	None
source/personCountryId	None
source/personNoMail	None
source/rank	None
source/birthdate	None
source/associateType	None
source/useAsMailingAddress	None
source/personSource	None
source/retired	None
source/birthYear	None
source/birthMonth	None
source/birthDay	None
source/kanaFirstName	None
source/kanaLastName	None
source/personUpdatedBy	None
source/personUpdatedByFullName	None
source/personUpdatedDate	None
source/personRegisteredBy	None
source/personRegisteredByFullName	None
source/personRegisteredDate	None
source/portraitThumbnail	None
source/personActiveErpLinks	None
source/personSourcedFrom	None
source/personLinkedinUrl	None
source/ticketPriority	None
source/supportLanguage	None
source/supportAssociate	None
source/supportAssociateFullName	None
source/personAssociateId	None
source/personAssociateFullName	None
source/personCategory	None
source/personCategoryGroup	None
source/personCategoryRank	None
source/personBusiness	None
source/leadStatus	None
source/leadstatusRank	None
source/personDeletedDate	None
source/hasCompany	None
source/isProjectMember	None
source/isStakeholder	None
source/updatedByWorkflow	None
source/whenUpdatedByWorkflow	None
source/createdByForm	None
source/phone/formattedNumber	string
source/restrictionContactId	int
source/restrictionPersonId	None
source/who	None		x
source/personDirectPhone/formattedNumber	None
source/personDirectPhone/description	None
source/personMobilePhone/formattedNumber	None
source/personMobilePhone/description	None
source/personPrivate/formattedNumber	None
source/personPrivate/description	None
source/personPager/formattedNumber	None
source/personPager/description	None
source/personDirectFax/formattedNumber	None
source/personDirectFax/description	None
source/name	stringorPK		x
source/department	string		x
source/nameDepartment	string		x
source/associateId	associate		x
source/category	listAny		x
source/categoryGroup	listAny		x
source/companyCategoryRank	int		x
source/business	listAny		x
source/country	listAny		x
source/countryId	int		x
source/number	string		x
source/code	string		x
source/orgnr	string		x
source/stop	bool		x
source/contactNoMail	bool		x
source/updatedBy	associate		x
source/updatedByFullName	associate		x
source/updatedDate	date		x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
source/registeredBy	associate		x
source/registeredByFullName	associate		x
source/registeredDate	date		x
source/contactSource	listAny		x
source/contactDeleted	bool		x
source/activeErpLinks	bool		x
source/numEmployees	int		x
source/yearFounded	int		x
source/revenueYear	int		x
source/revenueBasecurrency	decimal		x
source/sharecapitalBasecurrency	decimal		x
source/sourcedFrom	string		x
source/linkedinUrl	string		x
source/deletedDate	datetime
source/mainContact	None		x
source/forceCompany	bool
source/contactPhone/formattedNumber	string
source/contactPhone/description	string		x
target/contactId	int		x
target/name	stringorPK		x
target/department	string		x
target/nameDepartment	string		x
target/hasInfoText	bool		x
target/hasInterests	bool		x
target/associateId	associate		x
target/category	listAny		x
target/categoryGroup	listAny		x
target/companyCategoryRank	int		x
target/business	listAny		x
target/country	listAny		x
target/countryId	int		x
target/number	string		x
target/code	string		x
target/orgnr	string		x
target/stop	bool		x
target/contactNoMail	bool		x
target/updatedBy	associate		x
target/updatedByFullName	associate		x
target/updatedDate	date		x
target/registeredBy	associate		x
target/registeredByFullName	associate		x
target/registeredDate	date		x
target/contactSource	listAny		x
target/contactDeleted	bool		x
target/phone/formattedNumber	string
target/activeErpLinks	bool		x
target/numEmployees	int		x
target/yearFounded	int		x
target/revenueYear	int		x
target/revenueBasecurrency	decimal		x
target/sharecapitalBasecurrency	decimal		x
target/sourcedFrom	string		x
target/linkedinUrl	string		x
target/deletedDate	datetime
target/mainContact	None		x
target/forceCompany	bool
target/restrictionContactId	int
target/who	None		x
target/contactPhone/formattedNumber	string
target/contactPhone/description	string		x
target/contactFax/formattedNumber	None
target/contactFax/description	None
target/searchPhone/formattedNumber	None
target/searchPhone/description	None
target/email/emailProtocol	None
target/email/emailAddress	None
target/email/emailDescription	None
target/email/emailId	None
target/email/emailLastSent	None
target/email/emailBounceCount	None
target/email/emailLastBounce	None
target/email/emailHasBounced	None
target/postAddress/addressId	None
target/postAddress/line1	None
target/postAddress/line2	None
target/postAddress/line3	None
target/postAddress/county	None
target/postAddress/city	None
target/postAddress/zip	None
target/postAddress/state	None
target/postAddress/wgs84latitude	None
target/postAddress/wgs84longitude	None
target/postAddress/formattedAddress	None
target/postAddress/formattedMultiLineAddress	None
target/streetAddress/addressId	None
target/streetAddress/line1	None
target/streetAddress/line2	None
target/streetAddress/line3	None
target/streetAddress/county	None
target/streetAddress/city	None
target/streetAddress/zip	None
target/streetAddress/state	None
target/streetAddress/wgs84latitude	None
target/streetAddress/wgs84longitude	None
target/streetAddress/formattedAddress	None
target/streetAddress/formattedMultiLineAddress	None
target/restrictionAddress/addressId	None
target/restrictionAddress/line1	None
target/restrictionAddress/line2	None
target/restrictionAddress/line3	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
target/restrictionAddress/county	None
target/restrictionAddress/city	None
target/restrictionAddress/zip	None
target/restrictionAddress/state	None
target/restrictionAddress/wgs84latitude	None
target/restrictionAddress/wgs84longitude	None
target/restrictionAddress/formattedAddress	None
target/restrictionAddress/formattedMultiLineAddress	None
target/url/URLAddress	None
target/url/URLDescription	None
target/contactAssociate/firstName	None
target/contactAssociate/lastName	None
target/contactAssociate/middleName	None
target/contactAssociate/fullName	None
target/contactAssociate/contactId	None
target/contactAssociate/personId	None
target/contactAssociate/mrMrs	None
target/contactAssociate/title	None
target/contactAssociate/associateDbId	None
target/contactAssociate/contactName	None
target/contactAssociate/contactDepartment	None
target/contactAssociate/usergroup	None
target/contactAssociate/usergroupId	None
target/contactAssociate/contactFullName	None
target/contactAssociate/contactCategory	None
target/contactAssociate/role	None
target/contactAssociate/assocName	None
target/contactAssociate/assocTooltip	None
target/contactAssociate/assocType	None
target/contactAssociate/ejUserId	None
target/contactAssociate/simultaneousEjUser	None
target/contactAssociate/ejDisplayName	None
target/contactAssociate/ejStatus	None
target/contactAssociate/credentialType	None
target/contactAssociate/credentialDisplayValue	None
target/contactAssociate/isActive	None
target/contactAssociate/isActiveText	None
target/contactAssociate/portraitThumbnail	None
target/contactAssociate/otherGroups	None
target/contactAssociate/userName	None
target/contactAssociate/personEmail	None
target/contactAssociate/locationAddress	None
target/contactAssociate/isLocation	None
target/contactInterestIds	None
target/contactUdef/SuperOffice:1	None
target/contactUdef/SuperOffice:2	None
target/contactUdef/SuperOffice:3	None
target/contactUdef/SuperOffice:4	None
target/contactUdef/SuperOffice:5	None
target/contactUdef/SuperOffice:6	None
target/contactUdef/SuperOffice:7	None
target/contactUdef/SuperOffice:8	None
target/contactUdef/SuperOffice:9	None
target/contactUdef/SuperOffice:10	None
target/contactUdef/SuperOffice:11	None
target/contactUdef/SuperOffice:12	None
target/contactUdef/SuperOffice:13	None
target/contactExtra/x_contact_integer	None
target/contactExtra/x_contact_hidden_integer	None
target/contactExtra/x_contact_default_integer	None
target/contactExtra/x_contact_float	None
target/contactExtra/x_contact_longtext	None
target/contactExtra/x_contact_dropdown	None
target/contactExtra/x_contact_date	None
target/contactExtra/x_contact_datetime	None
target/contactExtra/x_contact_time	None
target/contactExtra/x_contact_boolean	None
target/contactExtra/x_contact_timespan	None
target/contactExtra/x_contact_shorttext	None
target/contactExtra/x_contact_short_dropdown	None
target/contactExtra/x_contact_contact_relation	None
target/contactExtra/x_contact_request_relation	None
target/contactExtra/x_contact_contact	None
target/contactExtra/y_organization/x_name	None
target/NumberOfActivities	None
target/NumberOfActivitiesInPeriod	None
target/NumberOfNotCompletedActivities	None
target/NumberOfNotCompletedActivitiesInPeriod	None
target/LastActivity	None
target/LastCompletedActivity	None
target/LastDoByActivity	None
target/NumberOfSales	None
target/NumberOfSalesInPeriod	None
target/NumberOfNotCompletedSales	None
target/NumberOfNotCompletedSalesInPeriod	None
target/LastSale	None
target/LastCompletedSale	None
target/LastDoBySale	None
target/NumberOfTickets	None
target/NumberOfTicketsInPeriod	None
target/NumberOfNotCompletedTickets	None
target/NumberOfNotCompletedTicketsInPeriod	None
target/LastTicket	None
target/LastCompletedTicket	None
target/LastDoByTicket	None
target/SaintStatus1	None
target/SaintStatus2	None
target/saintSaleStatus	None
target/saintAmountClass	None
target/saintActivityType	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
target/saintDirection	None
target/saintIntention	None
target/saintTicketStatus	None
target/saintTicketCategory	None
firstName	string		x
lastName	string		x
middleName	string		x
fullName	string		x
contactId	int
personId	int
mrMrs	string		x
title	string		x
associateDbId	associate		x
contactName	string		x
contactDepartment	string		x
usergroup	userGroup		x
usergroupId	int		x
contactFullName	string		x
contactCategory	listAny		x
role	listAny		x
assocName	associate		x
assocTooltip	string
assocType	listAny		x
ejUserId	int
simultaneousEjUser	bool
ejDisplayName	string		x
ejStatus	int
credentialType	None		x
credentialDisplayValue	None		x
isActive	bool		x
isActiveText	bool		x
portraitThumbnail	None
otherGroups	userGroup
userName	string		x
personEmail	string		x
locationAddress	string		x
isLocation	bool		x
target/personId	None
target/firstName	None
target/lastName	None
target/middleName	None
target/fullName	None
target/fullNameWithContact	None
target/personHasInterests	None
target/mrMrs	None
target/position	None
target/personNumber	None
target/title	None
target/personCountry	None
target/personCountryId	None
target/personNoMail	None
target/rank	None
target/birthdate	None
target/associateType	None
target/useAsMailingAddress	None
target/personSource	None
target/retired	None
target/birthYear	None
target/birthMonth	None
target/birthDay	None
target/kanaFirstName	None
target/kanaLastName	None
target/personUpdatedBy	None
target/personUpdatedByFullName	None
target/personUpdatedDate	None
target/personRegisteredBy	None
target/personRegisteredByFullName	None
target/personRegisteredDate	None
target/portraitThumbnail	None
target/personActiveErpLinks	None
target/personSourcedFrom	None
target/personLinkedinUrl	None
target/ticketPriority	None
target/supportLanguage	None
target/supportAssociate	None
target/supportAssociateFullName	None
target/personAssociateId	None
target/personAssociateFullName	None
target/personCategory	None
target/personCategoryGroup	None
target/personCategoryRank	None
target/personBusiness	None
target/leadStatus	None
target/leadstatusRank	None
target/personDeletedDate	None
target/hasCompany	None
target/isProjectMember	None
target/isStakeholder	None
target/updatedByWorkflow	None
target/whenUpdatedByWorkflow	None
target/createdByForm	None
target/restrictionPersonId	None
target/personDirectPhone/formattedNumber	None
target/personDirectPhone/description	None
target/personMobilePhone/formattedNumber	None
target/personMobilePhone/description	None
target/personPrivate/formattedNumber	None
target/personPrivate/description	None
target/personPager/formattedNumber	None
target/personPager/description	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
target/personDirectFax/formattedNumber	None
target/personDirectFax/description	None
source/contactFax/formattedNumber	None
source/contactFax/description	None
source/searchPhone/formattedNumber	None
source/searchPhone/description	None
source/email/emailProtocol	None
source/email/emailAddress	None
source/email/emailDescription	None
source/email/emailId	None
source/email/emailLastSent	None
source/email/emailBounceCount	None
source/email/emailLastBounce	None
source/email/emailHasBounced	None
source/postAddress/addressId	None
source/postAddress/line1	None
source/postAddress/line2	None
source/postAddress/line3	None
source/postAddress/county	None
source/postAddress/city	None
source/postAddress/zip	None
source/postAddress/state	None
source/postAddress/wgs84latitude	None
source/postAddress/wgs84longitude	None
source/postAddress/formattedAddress	None
source/postAddress/formattedMultiLineAddress	None
source/streetAddress/addressId	None
source/streetAddress/line1	None
source/streetAddress/line2	None
source/streetAddress/line3	None
source/streetAddress/county	None
source/streetAddress/city	None
source/streetAddress/zip	None
source/streetAddress/state	None
source/streetAddress/wgs84latitude	None
source/streetAddress/wgs84longitude	None
source/streetAddress/formattedAddress	None
source/streetAddress/formattedMultiLineAddress	None
source/restrictionAddress/addressId	None
source/restrictionAddress/line1	None
source/restrictionAddress/line2	None
source/restrictionAddress/line3	None
source/restrictionAddress/county	None
source/restrictionAddress/city	None
source/restrictionAddress/zip	None
source/restrictionAddress/state	None
source/restrictionAddress/wgs84latitude	None
source/restrictionAddress/wgs84longitude	None
source/restrictionAddress/formattedAddress	None
source/restrictionAddress/formattedMultiLineAddress	None
source/url/URLAddress	None
source/url/URLDescription	None
source/contactAssociate/firstName	None
source/contactAssociate/lastName	None
source/contactAssociate/middleName	None
source/contactAssociate/fullName	None
source/contactAssociate/contactId	None
source/contactAssociate/personId	None
source/contactAssociate/mrMrs	None
source/contactAssociate/title	None
source/contactAssociate/associateDbId	None
source/contactAssociate/contactName	None
source/contactAssociate/contactDepartment	None
source/contactAssociate/usergroup	None
source/contactAssociate/usergroupId	None
source/contactAssociate/contactFullName	None
source/contactAssociate/contactCategory	None
source/contactAssociate/role	None
source/contactAssociate/assocName	None
source/contactAssociate/assocTooltip	None
source/contactAssociate/assocType	None
source/contactAssociate/ejUserId	None
source/contactAssociate/simultaneousEjUser	None
source/contactAssociate/ejDisplayName	None
source/contactAssociate/ejStatus	None
source/contactAssociate/credentialType	None
source/contactAssociate/credentialDisplayValue	None
source/contactAssociate/isActive	None
source/contactAssociate/isActiveText	None
source/contactAssociate/portraitThumbnail	None
source/contactAssociate/otherGroups	None
source/contactAssociate/userName	None
source/contactAssociate/personEmail	None
source/contactAssociate/locationAddress	None
source/contactAssociate/isLocation	None
source/contactInterestIds	None
source/contactUdef/SuperOffice:1	None
source/contactUdef/SuperOffice:2	None
source/contactUdef/SuperOffice:3	None
source/contactUdef/SuperOffice:4	None
source/contactUdef/SuperOffice:5	None
source/contactUdef/SuperOffice:6	None
source/contactUdef/SuperOffice:7	None
source/contactUdef/SuperOffice:8	None
source/contactUdef/SuperOffice:9	None
source/contactUdef/SuperOffice:10	None
source/contactUdef/SuperOffice:11	None
source/contactUdef/SuperOffice:12	None
source/contactUdef/SuperOffice:13	None
source/contactExtra/x_contact_integer	None

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
source/contactExtra/x_contact_hidden_integer	None
source/contactExtra/x_contact_default_integer	None
source/contactExtra/x_contact_float	None
source/contactExtra/x_contact_longtext	None
source/contactExtra/x_contact_dropdown	None
source/contactExtra/x_contact_date	None
source/contactExtra/x_contact_datetime	None
source/contactExtra/x_contact_time	None
source/contactExtra/x_contact_boolean	None
source/contactExtra/x_contact_timespan	None
source/contactExtra/x_contact_shorttext	None
source/contactExtra/x_contact_short_dropdown	None
source/contactExtra/x_contact_contact_relation	None
source/contactExtra/x_contact_request_relation	None
source/contactExtra/x_contact_contact	None
source/contactExtra/y_organization/x_name	None
source/NumberOfActivities	None
source/NumberOfActivitiesInPeriod	None
source/NumberOfNotCompletedActivities	None
source/NumberOfNotCompletedActivitiesInPeriod	None
source/LastActivity	None
source/LastCompletedActivity	None
source/LastDoByActivity	None
source/NumberOfSales	None
source/NumberOfSalesInPeriod	None
source/NumberOfNotCompletedSales	None
source/NumberOfNotCompletedSalesInPeriod	None
source/LastSale	None
source/LastCompletedSale	None
source/LastDoBySale	None
source/NumberOfTickets	None
source/NumberOfTicketsInPeriod	None
source/NumberOfNotCompletedTickets	None
source/NumberOfNotCompletedTicketsInPeriod	None
source/LastTicket	None
source/LastCompletedTicket	None
source/LastDoByTicket	None
source/SaintStatus1	None
source/SaintStatus2	None
source/saintSaleStatus	None
source/saintAmountClass	None
source/saintActivityType	None
source/saintDirection	None
source/saintIntention	None
source/saintTicketStatus	None
source/saintTicketCategory	None

Sample

GET /api/v1/archive/PersonRelation?$select=source/personUpdatedByFullName,source/sourcedFrom,source/email/emailId
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.